Student Daily Attendance File Layout
The following table shows field numbers, field names, the eSchoolPlus Tables and Columns and where the data is coming from in eSchoolPlus for the Student Daily Attendance file.
* = Required for all students
+ = Required only for specified students
Field # | FIELD NAME from eScholar template (DATA ELEMENT NAME)as used by NYSED, if different from eScholar name | Positions | NYS or Local Purpose | eSchoolPlus Table.Column | Where in eSchoolPlus? |
|---|---|---|---|---|---|
1 | *DISTRICT CODE (DISTRICT OF RESPONSIBILITY CODE) | 1 - 8 | NYS Reporting | reg_district.state_code_equiv "NY" + first 6 characters of state_code_equiv | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE | 9 – 14 | NYS Reporting | att_stu_day_totals.building | Attendance > All > Student > Day Totals: Building |
3 | *STUDENT ID (SCHOOL DISTRICT STUDENT ID) | 15 – 26 | NYS Reporting | att_stu_day_totals.student_id | Attendance > All > Student > Day Totals: ID |
4 | *ATTENDANCE DATE | 27 – 36 | NYS Reporting | att_stu_day_totals.attendance_date | Attendance > All > Student > Day Totals > enter criteria and click Load Totals: Date |
5 | ATTENDANCE CODE | 37 – 38 |
| Blank |
|
6 | ATTENDANCE COMMENT | 39 – 78 |
| Blank |
|
7 | ABSENCE DURATION | 79 – 84 |
| Blank |
|
8 | *ATTENDANCE CODE LONG | 85 – 109 | NYS Reporting | att_stu_day_totals.attendance_code | Attendance > All > Student > Day Totals > enter criteria and click Load Totals: Att Code |
9 | *SCHOOL YEAR DATE | 110 - 119 | NYS Reporting | School Year Prompt-06-30 | Regulatory > Downloads > Downloads > NY Attendance Download: School Year followed by -06-30 |
10 | MARKING PERIOD CODE | 120 – 159 |
| Leave blank | N/A |
11 | TERM CODE | 160 – 179 |
| Leave blank | N/A |