Attendance Codes 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 Attendance Codes file.
* = Required for all records
+ = Required only for specified records
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 | ATTENDANCE CODE | 9 – 10 |
| Blank |
|
3 | ATTENDANCE DESCRIPTION | 11 – 1133 | NYS Reporting | att_code.description | Administration > Attendance Setup > Setup > Attendance Codes: Description |
4 | ATTENDANCE CATEGORY | 1134 – 1183 |
| Blank |
|
5 | *ATTENDANCE CODE LONG | 1184 – 1208 | NYS Reporting | att_code.attendance_code | Administration > Attendance Setup > Setup > Attendance Codes: Attendance Code |
6 | ATTENDANCE TYPE | 1209 – 1216 |
| Blank |
|
7 | SORT SEQUENCE | 1217 – 1220 |
| Blank |
|
8 | ATTENDANCE STATUS | 1221 – 1232 |
| Blank |
|
9 | *STATE ATTENDANCE CODE | 1233 – 1257 | NYS Reporting | att_code.state_state_code_equiv | Administration > Attendance Setup > Setup > Attendance Codes: State Code Equiv |
10 | *STATE ATTENDANCE DESCRIPTION | 1258 – 1512 | NYS Reporting | atttb_state_grp.description where atttb_state_grp.code = att_code.state_code_equiv | Administration > General Setup > District > Validation Tables > select Attendance > State Groups: Description |
11 | *SCHOOL YEAR DATE | 1513 – 1522 | NYS Reporting | School Year Prompt-06-30 | Regulatory > Downloads > Downloads > NY Attendance Download: School Year followed by -06-30 |
12 | *ATTENDANCE CODE TYPE | 1523 – 1537 | NYS Reporting | STUDENT | Hardcoded value STUDENT populated here |
13 | ATTENDANCE SHORT DESCRIPTION | 1538 - 1612 |
|
|
|