Demographic
Field # | Field Name | eSchoolPLUS table.column | Required? | Field Length | Validation Table | Where in eSchoolPlus? | Notes (include any prerequisites needed to obtain this value before running a download) |
---|---|---|---|---|---|---|---|
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 | All special chars removed | ||||
4 | Legal First Name | Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name | All special chars removed | ||||
5 | Legal Middle Name | Use reg_legal_info.legal_middle_name if it has a value. If not, use reg.middle_name | * if blank All special chars removed | ||||
6 | Lineage (Suffix) | reg.generation converted using state_code_equiv | |||||
7 | Mothers Maiden Name | reg_personal.mother_maiden | All special chars removed | ||||
8 | Race | reg_personal.fed_race_ethic + 10 | |||||
9 | Gender | Use reg_legal_info.gender if it has a value. Otherwise, use reg.gender | |||||
10 | Birth Date | reg.birthdate | Formated mm/dd/yyyy | ||||
11 | Birth Place | reg_personal.birth_city + birth_state OR reg_personal.birth_city + birth_country | The city space state OR The city space country | ||||
12 | Reading First Indicator | reg_user - screen 900 - field 8 (Program tracked ILREAD) (il_v_stu_demo.reading_first) | 01 = Yes, 02 = No (defaults to 02) | ||||
13 | Reading Improvement Block Grant Indicator | reg_user - screen 900 - field 9 (Program tracked ILREADBL) (il_v_stu_demo.reading_grant) | 01 = Yes, 02 = No (defaults to 02) | ||||
14 | Title I Indicator | reg_user - screen 900 - field 10 (Program tracked ILTITLE) (il_v_stu_demo.title_1) OR Reg_user_building – screen 100 – field 1 | 11 = School Wide, 12 = Targeted, 13 = No If an entire school is Title I, update the Building District-defined screen, Building Title I, to checked and then all students enrolled in that building will get a value of 11 in this field. | ||||
15 | Eligible for Immigrant Education Program | reg_programs where program_id=’ELL’ and field_number=’3’, state_code_equiv=’IMMED’ | Registration > Entry & Reports > Student District Defined > IL ELL and ELL Screener: Immigrant Education Program field | ||||
16 | Home Language | reg.language (converted to regtb_language.state_code_equiv) | regtb_language | ||||
17 | Native Language | Reg.native_language (converted to regtb_language.state_code_equiv) | Regtb_language | ||||
18 | Homeless Indicator | reg_programs.program_value where state_code_equiv = ILISHOME | regtb_homeless | If the student was enrolled in the Homeless program at any time during the school year, they will have a 01 (Yes) in this field. | |||
19 | Migrant Indicator | reg_personal.migrant (Program tracked ILMIG) | 01 = Yes, 02 = No (defaults to 02) | ||||
20 | Private School Indicator | reg_programs.program_value where program_id and field_number map to reg_program_column with state_code_equiv = ILPSS | |||||
21 | Military Connected Student | System-calculated based on reg_programs.program_value where program_id and field_number map to reg_program_column with state code equiv = ILPARARMED or reg_programs.program_value where program_id and field_number map to reg_program_column with state_code_equiv = ILPARACTIV | Download gives student a value of 01 (Yes) if the Value box is checked for either of the following programs: Parent/Guard in armed forces or Parent/Guard depl active duty Otherwise, the download gives the student 02 (No). | ||||
22 | SES Indicator | reg_user - screen 900 - field 3 (Program tracked ILSES) (il_v_stu_demo.ses) | 01 = Yes, 02 = No (defaults to 02) You may enter other codes into the SES Indicator Validation Table (Administration>System Setup>Validation Tables: Illinois State Reporting tab). The state code equiv should be 01 for codes that mean Yes. Any other State Code Equivs will translate to an 02 in this field in the State file. | ||||
23 | LEP Indicator | reg_user - screen 900 - field 1 (Program tracked ILLEP) (il_v_stu_demo.lep) | 01 = Yes, 02 = No (defaults to 02) | ||||
24 | IDEA Services | reg_user - screen 900 - field 4 (program tracked ILIEP) (il_v_stu_demo.iep) | 01 = Yes, 02 = No (Defaults to 02) | ||||
25 | Dual Language | reg_programs.program_value converted to iltb_dual_language.state_code_equiv where program_id = ELL and field_number = 21 | iltb_dual_language | Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener: Dual Language | Default 03 - Not a Participant in Dual Language Program | ||
26 | Language of Instruction | reg_programs.program_value converted to regtb_language.state_code_equiv where program_id = ELL and field_number = 22 | regtb_language | Registration > Entry & Reports > Student District Defined > ISBE EL with ELL Screener: Language of Instruction | Required if Dual Language = 01 This field is ignored if Dual Language = 03 | ||
27 | FRL/Low Income | reg_programs - (converted to state code equiv) (Program Tracked ILFRL) | regtb_meal_status | ||||
28 | Century 21 Indicator | reg_user - screen 900 - field 6 (il_v_stu_demo.century21) | 01 = Yes, 02 = No (Defaults to 02) | ||||
29 | Enrollment/Entry Type | reg_entry_with.entry_code - converted to state code equiv | regtb_entry | First attendance code for current year (for current building) | |||
30 | Enrollment/Entry Date | reg_entry_with.entry_date | First date of attendance for current year MM/DD/YYYY | ||||
31 | RCDTS for Home School | reg.alt_building - state_code_equiv (program tracked ILALT) | If no alternate building – uses Entry/Withdrawal building… | ||||
32 | RCDTS for Serving School | Reg_entry_with.building converted using reg_building - state_code_equiv | If anything for timeframe in Programs – RCDTS Overrides for Home School – this will override both Alternate and Building | ||||
33 | Entry / Grade Level | reg_entry_with.grade | If anything for timeframe in Programs – RCDTS Overrides for Serving School – this will override Entry/Withdrawal Building | ||||
34 | School Year | prompted school year | |||||
35 | FTE | reg_user - screen 900 - field 7 (Program Tracked) (il_v_stu_demo.fte) | |||||
36 | Tuition-In Indicator | reg_programs.program_value where program_id = TUIT and field_number = 1 | Registration > Entry & Reports > Student District Defined > ISBE: Tuition In | Only report the value 01 (Yes) if the student is in a K-12 grade level. Do not mark Private School Students with the 01 (Yes) value. Private School Student is tracked on the ISBE student page. | |||
37 | Result Code | Defaults to 1.00 if blank | |||||
38 | Result Message Code |