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 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 | *MARKING PERIOD CODE | 1 - 8 | NYS Reporting | reg_mp_dates.Marking_Period | Administration > Registration Setup > Calendars > Marking Periods > Dates Heading |
2 | *SCHOOL YEAR DATE | 9 – 18 | NYS Reporting | schd_ms.school_year. Use June 30 of the reported school year. Ex: For 2011-12, use 2012-06-30. | School Year from Master Schedule |
3 | MARKING PERIOD NAME | 19 – 68 | Local use only | reg_mp_weeks.Description | Administration > Registration Setup > Calendars > Marking Periods > Weeks Heading |
4 | MARKING PERIOD DESCRIPTION | 69 – 168 | Local use only | reg_mp_weeks.Description | Administration > Registration Setup > Calendars > Marking Periods > Weeks Heading |
5 | MARKING PERIOD CATEGORY | 169 – 218 | Local use only | Leave blank. |
|
6 | MARKING PERIOD SORT SEQUENCE | 219 – 222 | Local use only | reg_mp_weeks.MP_Order | Administration > Registration Setup > Calendars > Marking Periods > Weeks Heading |
7 | *TERM CODE | 223 – 242 | NYS Reporting | Nytb_Terms.State_Code_Equiv where reg_mp_weeks.Term = nytb_terms.Code |
|
8 | TERM DESCRIPTION | 243 – 342 | Local use only | Nytb_Terms.Description where reg_mp_weeks.Term = nytb_terms.Code | Administration > General Setup > District > Validation Tables > select NY State Reporting > Term |
9 | TERM CATEGORY | 343 – 392 | Local use only |
|
|
10 | TERM SORT SEQUENCE | 393 – 396 | Local use only | Nytb_Terms.Term_Sequence where reg_mp_weeks.Term = nytb_terms.Code | Administration > General Setup > District > Validation Tables > select NY State Reporting > Term |
11 | TERM MARKING PERIOD DESCRIPTION | 397 – 496 | Local use only |
|
|
12 | MARKING PERIOD ID | 497 – 516 |
| Leave blank | N/A |
13 | TERM ID | 517 – 536 |
| Leave blank | N/A |
14 | ALTERNATE MARKING PERIOD DESCRIPTION | 537 – 636 |
| Leave blank | N/A |