Skip to main content
Skip table of contents

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

 

 

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.