SAT Pre-ID
| Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes |
|---|---|---|---|---|---|---|---|
| 1 | Student Id | reg_personal.state_report_id | Y | 9 | Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field | ||
| 2 | SAP Id | reg_entry_with.student_id | N | 50 | Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID field | ||
| 3 | Legal Last Name | reg.last_name | Y | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field | ||
| 4 | Legal First Name | reg.first_name | Y | 30 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field | ||
| 5 | Birth Date | reg.birthdate | Y | 10 | Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field | Formatted mm/dd/yyyy | |
| 6 | RCDTS for Home School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = H_RCDTS Otherwise, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = ILALT. This is the same reg_building.state_code_equiv for the building stored in reg.alt_building. If there is no alternate building use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | The download goes through these steps:
| Note: default to the Serving School if none entered If no alternate building – uses Entry/Withdrawal building… If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alternate and Building | |
| 7 | RCDTS for Serving School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = S_RCDTS Otherwise, use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | For the override value, go to Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides: Serving School RCDTS Override Otherwise, reference Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building | If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building | |
| 8 | RCDTS for Testing School | If student has an override, use reg_building.state_code_equiv where building equals reg_programs.program_value for program_id with reg_program_column.state_code_equiv = T_RCDTS Otherwise, use reg_entry_with.building and map to the reg_building.state_code_equiv | Y | 15 | For the override value, go to Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides: Testing School RCDTS Override Otherwise, reference Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building | Note: default to the Serving School if none entered If anything in timeframe in Programs – RCDTS Overrides for Testing School – this will override. | |
| 9 | Sort Group | Based on the Sort Group field selection from IL SAT Pre-ID page. | N | 10 | Regulatory > ISBE > Assessment > IL SAT Pre-ID: Sort Group selection | ||
| 10 | Placeholder 1 | N/A | Blank | N/A | |||
| 11 | Placeholder 2 | N/A | Blank | N/A | |||
| 12 | First Year in US | Set this field to 01 for Yes if the student meets these criteria: The student has reg_programs.program_value = Y as of the prompted Reporting Date for the program_id mapping to reg_program_column.state_code_equiv = ILELL The student's reg.us_enroll_date is within twelve months of the Reporting Date. If the student does not meet both criteria, use 02 for No. | Y | 2 | 01 = Yes, 02 = No | Registration > Entry & Reports > Student District-Defined > ISBE ELL and ELL Screener: ELL Program field Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: US Enrollment Date field |