Student 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 | |||||
| 2 | SAP Id | reg.student_id | |||||
| 3 | Legal Last Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |||||
| 4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | |||||
| 5 | Birth Date | reg.birthdate | Formatted mm/dd/yyyy | ||||
| 6 | RCDTS for Home School | reg.alt_building - state_code_equiv (program tracked ILALT) | Note: default to the Serving School if none entered If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alternate and Building | ||||
| 7 | RCDTS for Serving School | reg_entry_with.building – converted reg_building.state_code_equiv | If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building | ||||
| 8 | RCDTS for Testing School | reg_user - Screen 905, field 1 (il_v_stu_preid.testing_school) | Note: default to the Serving School if none entered If anything in timeframe in Programs – RCDTS Overrides for Testing School – this will override. | ||||
| 9 | Grade Level at Time of Testing | reg.grade converted using reg_grade.state_code_equiv | Kindergarten students will not be included (State Code Equiv = 15) | ||||
| 10 | First Year in US | reg.us_enrolled | 01 = Yes, 02 = No | If date>= July 1 of previous year, then set to 01. Otherwise, set to 02. If no date found then default to 01. | |||
| 11 | Years in any TBE/TPI Program | reg_user - screen 905, field 4 (Program Tracked) (il_v_stu_preid.tbe_prog) reg_user - screen 905, field 5 (Program Tracked) (il_v_stu_preid.tpi_prog ) | The system will look first to see if there is a value in the TBETPI Years Enrolled Override field on the ISBE Pre-ID screen (Student Center>Demographic). If there is a value in this field, it will use that. If there isn’t a value here and the student has TBE and/or TPI Program records, the start and end dates will be used to calculate the number of years. The system will subtract the program date year(s) from the Reporting Date field on the ISBE Submission File page to determine the value in this field. If a student has never participated in either program and does not have a value in the Override field, then this field will be set to 07. If a student has been/was enrolled in the programs for more than 6 years, the value in the file will be 06. | ||||
| 12 | Years since exited TBE/TPI Program | reg_user - screen 905, field 4 (Program Tracked) (il_v_stu_preid.tbe_prog) reg_user - screen 905, field 5 (Program Tracked) (il_v_stu_preid.tpi_prog ) | The system will look first to see if there is a value in the TBETPI Years Exited Override field on the ISBE Pre-ID screen (Student Center>Demographic). If there is a value in this field, it will use that. If there isn’t a value here and the student has TBE and/or TPI Program records, the last end date for the program(s) will be used to calculate the number of years. The system will subtract the program end date year(s) from the Reporting Date field on the ISBE Submission File screen (State Center>Illinois) to determine the value in this field. If a student has never participated in either program and does not have a value in the Override field, then this field will be set to 03. If a student has been out of the program(s) for more than two years, the value in the file will be 02. | ||||
| 13 | Enrolled in home school on /before May 1 | reg_user - screen 905, field 7 (il_v_stu_demo.school_enroll) Calculates Yes/No from Entry/Withdrawal if option is set to E Sets to Yes or No if the Yes/No overrides are set. | 01 = Yes, 02 = No | If option E is set for the student - if registered for all membership days in the May 1st building, the student is considered continuously enrolled. If there are membership days for the building that are not covered by Entry/Withdrawal records, the student is not continuously enrolled. To bypass this calculation, you can select Y or N as appropriate for the student, and the system will use this override value in the Pre-Id file. Defaults to 01 (Yes) | |||
| 14 | Enrolled in home district on/before may 1 | reg_user - screen 905, field 8 (il_v_stu_demo.district_enroll) Calculates Yes/No from Entry/Withdrawal if option is set to E Calculates Yes/No from the District Enrollment Date on the Registration page if the option is set to R. Sets to Yes or No if the Yes/No overrides are set. | 01 = Yes, 02 = No | If option E is set for the student - if registered for all membership days in the May 1st building, the student is considered continuously enrolled. If there are membership days for the building that are not covered by Entry/Withdrawal records, the student is not continuously enrolled. If option R is set for the student - if the district enrollment date is on or before May 1st of the prior year, then the student is considered continuously enrolled in the district. To bypass this calculation, you can select Y or N as appropriate for the student, and the system will use this override value in the Pre-Id file. Defaults to 01 (Yes) | |||
| 15 | Test to be taken | reg_user - screen 905, field 2 | iltb_test_type | ||||
| 16 | Result Code | ||||||
| 17 | Result message codes |