EL

Field #	Field Name	eSchoolPLUS table.column	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)	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	Date First enrolled in District	Reg.distrct_enroll_date	Format mm/dd/yyyy
8	First Year in US School	Reg.us_enroll_date – if date <1 year prior to reporting date then set to 01 (yes); otherwise set to 02 (no)	01=Yes 02=No (default to 02)
9	EL Placement - Entry Status	reg_v_programs.entry_reason (state code equiv = ILELL) for date – convert to state_code_equiv using regtb_prog_entry
10	Date Student Enrolled or re-entered to receive EL Services	reg_v_programs.start_date (state code equiv = ILELL) for date range	Format mm/dd/yyyy
11	Date EL Services Ended	reg_v_programs.end_date (state code equiv = ILELL) for date range	Format mm/dd/yyyy
12	Reason for Ending EL Services	reg_v_programs.withdrawal_reason (state code equiv = ILELL) for date – convert to state_code_equiv using regtb_prog_with	Required if Date ELL Services Ended is filled in
13	Class Periods Provided per week	Reg_user.field_value for screen 915 field 2	Options = 01-Low 02-Moderate 03-High
14	EL Services Provided	reg_programs.program_value where program_id and field_number joins to reg_program_column with state_code_equiv = ILELSERV	Valid values range from 00 to 06.