Day Calendar 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 Day Calendar 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 | 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 | reg_user_building.building | Administration > Registration Setup > Building District Defined > NY Calendar Setup: Building field |
3 | *SCHOOL YEAR DATE | 15 – 24 | NYS Reporting | Use June 30 of the reported school year. Ex: For 2013-14, use 2014-06-30. | Use the School Year entered on the NY Student Downloads page. |
4 | *SCHOOL DATE | 25 – 34 | NYS Reporting | reg_cal_days.cal_date | Administration > Registration Setup > Calendars > Calendar > click Calendar link > Month View button > click appropriate calendar date link: Date field |
5 | *LOCATION GRADE LEVEL | 35 – 37 | NYS Reporting | Create separate record for each two-character grade level entered for a building and calendar in reg_user_building.field_value for screen_number = 2010 and field_number = 2 | Administration > Registration Setup > Building District Defined > NY Calendar Setup: Grades field |
6 | DURATION | 38 – 42 | |||
7 | *DAY TYPE | 43 – 62 | NYS Reporting | If reg_cal_days.membership_day = Y, report Instructional day If membership_day = N, see if reg_cal_days.day_type exists has corresponding value in regtb_day_type.state_code_equiv. If yes, report the state_code_equiv. If not, report Other | Administration > Registration Setup > Calendars > Calendar > click Calendar link > Month View button > click appropriate calendar date link: Membership Day field and Day Type field Administration > General Setup > Validation Tables > select Registration > Day Types: State Code Equiv field |
8 | DAY STATUS | 63 – 102 | Leave blank | N/A | |
9 | DAY NUMBER | 103 – 106 | Leave blank | N/A | |
10 | SCHOOL MONTH NUMBER | 107 – 108 | Leave blank | N/A | |
11 | SCHOOL MONTH NAME | 109 – 128 | Leave blank | N/A | |
12 | INSTRUCTIONAL MINUTES | 129 – 132 | Leave blank | N/A |