Student Attendance

Field #	Field Name	eSchoolPLUS table.column	Required?	Field Length	Validation Table	Where in eSchoolPlus?	Notes
1	Student ID	reg_personal.state_report_id	M	9		Registration > Entry & Reports > Student Demographic > Personal > General panel: State ID field
2	SAP ID	reg.student_id	O	50		Registration > Entry & Reports > Student Demographic > Registration > Student Information bar: ID field
3	Legal Last Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30		Registration > Entry & Reports > Student Demographic > Registration > Student panel: Last Name field
4	Legal First Name	Use reg_legal_info.legal_last_name if it has a value. If not, use reg.last_name	M	30		Registration > Entry & Reports > Student Demographic > Registration > Student panel: First Name field
5	Birth Date	reg.birthdate	M	10		Registration > Entry & Reports > Student Demographic > Registration > Student panel: Birth Date field
6	RCDTS for Home School	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 3 for the reported list_sequence Otherwise, use the following logic: reg_building.state_code_equiv for reg_programs.program_value where program_id = reg_program_column.program_id for state_code_equiv = H_RCDTS Or, reg_building.state_code_equiv for reg.alt_building Or, reg_building.state_code_equiv for reg_entry_with.building	M	15	iltb_rcdts_nums	The download uses Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: RCDTS Home School field if there is a record for the reported month and year. If the attendance comes from student day totals, the download goes through these steps: It checks to see if the student has an active program vector as of the Reporting Date for Home School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides). If there is no active vector for this program, the download checks whether the student has an active Alternate Building program vector (Registration > Entry & Reports > Student Demographic > Registration > Other Enrollment panel: Alternate Building field). If there is also no Alternate Building, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).
7	RCDTS for Serving School	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 4 for the reported list_sequence. If the attendance comes from att_stu_day_totals, convert att_stu_day_totals.building to reg_building.state_code_equiv	M	15	iltb_rcdts_nums	The download uses Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: RCDTS Serving School field if there is a record for the reported month and year. If the attendance comes from student day totals, the download converts the student's attendance building to the appropriate RCDTS number. It checks to see if the student has an active program vector as of the Reporting Date for Serving School RCDTS Override (Registration > Entry & Reports > Student Demographic > Programs > click link for RCDTS - RCDTS Overrides). If there is no active vector for this program, use the student’s Entry/Withdrawal Building (Registration > Entry & Reports > Student Demographic > Entry/Withdrawal: Building).
8	Enrollment Date	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 2 for the reported list_sequence. Otherwise, use reg_entry_with.entry_date.	M	10		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Enrollment Date field Registration > Entry & Reports > Student Demographic > Entry/Withdrawal > click appropriate School Year link > Enrollment panel: Entry Date field
9	School Year	Fiscal Year prompt selection from IL Download ISBE Submission Files page.	M	4	regtb_school_year	Regulatory > ISBE > ISBE > IL Download ISBE Submission Files: Fiscal Year prompt	This is the school year for the reported attendance month. For example, the 2018-2019 school year reports as 2019.
10	Month of Attendance	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 5 for the reported list_sequence. Otherwise, the month is based on the att_stu_day_totals.attendance_dates reported in a given record.	M	2	iltb_months	Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Month of Attendance field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates.	A student can have more than one record for the same month and year of attendance. This would happen if the student withdraws from and re-enrolls in the same serving building within the same reporting month and year.
11	Year of Attendance	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 6 for the reported list_sequence. Otherwise, the Year of Attendance is based on the att_stu_day_totals.attendance_dates reported in a given record.	M	4	regtb_school_year	Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Year of Attendance field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates.	This is the actual calendar year when the reported attendance month falls. November 2019 attendance reports with a Year of Attendance value of 2019.
12	Days Present	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field_number = 13 for the reported list_sequence. Otherwise, use system-calculated based on att_stu_day_totals for the prompted School Year and Attendance View Type from the Download ISBE Submission Files page. See the Notes column for details.	M	5,3		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Days Present field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates. See the Notes column for calculation details.	The download reports attendance up to your Reporting Date entry on the IL Download ISBE Submission Files page. Make sure to run the Student Day Totals Calculation before you create this file. Total the student's membership days for the selected School Year and View Type. Limit to the month reported in a given record. Add the att_code_value for att_stu_day_totals records where attendance_code = any of the Excused Absence Codes you selected. Do the same where attendance_code = ATT_CODE.STATE_CODE_EQUIV = 'PRSNT' Attendance date LOCATION_TYPE not in ('A','S') and Attendance_Date day type is not REGTB_DAY_TYPE .STATE_CODE_EQUIV = 'ELRN'.
13	Days Absent - Excused	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field _number = 9 for the reported list_sequence. Otherwise, system-calculated based on att_stu_day_totals for the prompted School Year and Attendance View Type from the Download ISBE Submission Files page. See the Notes column for details.	M	5,3		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Days Absent - Excused field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates. See the Notes column for calculation details.	The download reports attendance up to your Reporting Date entry on the IL Download ISBE Submission Files page. Make sure to run the Student Day Totals Calculation before you create this file. For the prompted School Year and View Type, add the att_code_value for att_stu_day_totals records where attendance_code = any of the Excused Absence Codes you selected. Limit to the month reported in a given record.
14	Days Absent - Unexcused	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field _number = 10 for the reported list_sequence. Otherwise, system-calculated based on att_stu_day_totals for the prompted School Year and Attendance View Type from the Download ISBE Submission Files page. See the Notes column for details.	M	5,3		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Days Absent - Unexcused field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates. See the Notes column for calculation details.	The download reports attendance up to your Reporting Date entry on the IL Download ISBE Submission Files page. Make sure to run the Student Day Totals Calculation before you create this file. For the prompted School Year and View Type, add the att_code_value for att_stu_day_totals records where attendance_code = any of the Unexcused Absence Codes you selected. Limit to the month reported in a given record.
15	Days Medically Homebound	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field _number = 11 for the reported list_sequence. Otherwise, system-calculated based on att_stu_day_totals for the prompted School Year and Attendance View Type from the Download ISBE Submission Files page. See the Notes column for details.	M	5,3		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Medically Homebound field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates. See the Notes column for calculation details.	The download reports attendance up to your Reporting Date entry on the IL Download ISBE Submission Files page. Make sure to run the Student Day Totals Calculation before you create this file. For the prompted School Year and View Type, add the att_code_value for att_stu_day_totals records where attendance_code = any of the Medically Homebound Codes you selected. Limit to the month reported in a given record.
16	Days Hospitalized	If the attendance comes from the IL Out of District Attendance student page, use reg_user.field_value where screen_number = 1100 and field _number = 12 for the reported list_sequence. Otherwise, system-calculated based on att_stu_day_totals for the prompted School Year and Attendance View Type from the Download ISBE Submission Files page. See the Notes column for details.	M	5,3		Registration > Entry & Reports > Student District Defined > IL Out of District Attendance: Hospitalization field if this comes from a student district-defined page entry. To see a student's Day Totals attendance for a month and year, use Attendance > All > Student > Day Totals > select View Type > choose Date Range, and then enter the month's start and end dates. See the Notes column for calculation details.	The download reports attendance up to your Reporting Date entry on the IL Download ISBE Submission Files page. Make sure to run the Student Day Totals Calculation before you create this file. For the prompted School Year and View Type, add the att_code_value for att_stu_day_totals records where attendance_code = any of the Hospitalized Codes you selected. Limit to the month reported in a given record.