Location Marking Period 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 Location Marking Period 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 | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE | 9 – 20 | NYS Reporting | schd_course.Building |
|
3 | *MARKING PERIOD CODE | 21 – 40 | NYS Reporting | reg_mp_dates.Marking_Period reg_mp_dates.state_code_equiv | Administration > Registration Setup > Calendars > Marking Periods (Weeks Section): State Code Equiv |
4 | *SCHOOL YEAR DATE | 41 – 50 | NYS Reporting | schd_ms.school_year. Ex: For 2011-12, enter 2012 and the system will report as 2012-06-30. | Regulatory > Extracts > Extracts > NY Teacher Course Extracts |
5 | *MARKING PERIOD START DATE | 51 – 60 | Local use only | reg_mp_dates.start_date | Administration > Registration Setup > Calendars > Marking Periods (Dates Section): Start Date for Marking Period(s) in current school year |
6 | *MARKING PERIOD END DATE | 61 – 70 | Local use only | reg_mp_dates.end_date | Administration > Registration Setup > Calendars > Marking Periods (Dates Section): End Date for Marking Period(s) in current school year |
7 | LOCATION MARKING PERIOD DESCRIPTION | 71 – 170 | Local use only | reg_mp_weeks.Description | Administration > Registration Setup > Calendars > Marking Periods (Weeks Section): Description |
8 | *TERM CODE | 171 – 190 | NYS Reporting | reg_mp_weeks.Term | Administration > Registration Setup > Calendars > Marking Periods (Weeks Section): Term |
9 | INSTRUCTIONAL DAYS | 191 – 193 |
| Leave blank | N/A |
10 | INSTRUCTIONAL MINUTES | 194 – 198 |
| Leave blank | N/A |
11 | LOCATION TERM CATEGORY | 199 – 248 |
| Leave blank | N/A |
12 | SCHOOL DAY MINUTES | 249 – 252 |
| Leave blank | N/A |
13 | DAYS IN SESSION | 253 - 255 |
| Leave blank | N/A |