Student Participant Demographic
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? |
---|---|---|---|---|---|---|
1 | Student ID | reg_personal.state_report_id | M | 9 | Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field | |
2 | SAP ID | reg.student_id | O | 50 | Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID field | |
3 | Legal Last Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | M | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field | |
4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | M | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field | |
5 | Birth Date | reg.birthdate | M | 10 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field | |
6 | RCDTS for Home School | reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS Or, reg_building.state_code_equiv for reg.alt_building Or, reg_building.state_code_equiv for reg_entry_with.building | M | 15 | The download goes through these steps:
| |
7 | RCDTS for Serving School | reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = S_RCDTS Or, reg_building.state_code_equiv for reg_entry_with.building | M | 15 | The download goes through these steps:
| |
8 | Caregiver SID | reg_user.field_value where screen_number = 1005 and field_number = 1 | O | 9 | Registration > Entry & Reports > Student District Defined: Caregiver SID field | |
9 | Caregiver Last Name | reg_user.field_value where screen_number = 1005 and field_number = 2 | O | 30 | Registration > Entry & Reports > Student District Defined: Caregiver Last Name field | |
10 | Caregiver First Name | reg_user.field_value where screen_number = 1005 and field_number = 3 | O | 30 | Registration > Entry & Reports > Student District Defined: Caregiver First Name field | |
11 | Birth Date of Caregiver | reg_user.field_value where screen_number = 1005 and field_number = 4 | M | 10 | Registration > Entry & Reports > Student District Defined: Caregiver Birthdate field | |
12 | Caregiver's Relationship to Child | reg_user.field_value where screen_number = 1005 and field_number = 5 | M | 2 | iltb_care_relation | Registration > Entry & Reports > Student District Defined: Relationship to Child field |
13 | Caregiver's Race | reg_user.field_value where screen_number = 1005 and field_number = 6 | M | 2 | regtb_ethnicity | Registration > Entry & Reports > Student District Defined: Caregiver Race field |
14 | Educational Background of Caregiver | reg_user.field_value where screen_number = 1005 and field_number = 7 | M | 2 | iltb_care_edustatus | Registration > Entry & Reports > Student District Defined: Educational Background field |
15 | Current Employment Status of Caregiver | reg_user.field_value where screen_number = 1005 and field_number = 8 | M | 2 | iltb_care_empstatus | Registration > Entry & Reports > Student District Defined: Employment Status field |