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

×