Student Class Entry Exit 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 Student Class Entry/Exit file.
* = Required for all staff
+ = Required only for specified staff
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 If length is not 8 or value does not begin with '8', then use 'NY' followed by first six digits of state_code_equiv | Administration > General Setup > District > District: State Equivalency Code |
2 | *LOCATION CODE | 9 – 14 | NYS Reporting | schd_ms.building | Scheduling > Courses > Course Sections > Master Schedule: Building |
3 | *COURSE CODE | 15 – 17 | NYS Reporting | schd_ms.course | Scheduling > Courses > Course Sections > Master Schedule: Course |
4 | *SCHOOL YEAR DATE | 18 – 27 | NYS Reporting | (School Year from Download prompt) + '-06-30' | School Year from New York Teacher Course Download page |
5 | *SUPPLEMENTARY COURSE DIFFERENTIATOR | 28 – 47 | NYS Reporting | NA (hard-coded value) |
|
6 | *SECTION CODE | 48 – 72 | NYS Reporting | schd_ms.course_section | Scheduling > Courses > Course Sections > Master Schedule: Course Section |
7 | *STUDENT ID | 73 – 84 | NYS Reporting | Schd_stu_crs_dates.student_id | Scheduling > Student Schedules > Schedule Entry > click Course-Section description link; ID field |
8 | *CLASS ENTRY DATE | 85 – 94 | NYS Reporting | Schd_stu_crs_dates.date_added | Scheduling > Student Schedules > Schedule Entry > click Course-Section description link; Date Added field |
9 | CLASS ENTRY TYPE CODE | 95 – 114 |
| Leave blank |
|
10 | CLASS ENTRY COMMENT | 115 – 154 |
| Leave blank |
|
11 | +CLASS EXIT DATE | 155 – 164 | NYS Reporting | Schd_stu_crs_dates.date_dropped | Scheduling > Student Schedules > Schedule Entry > click Course-Section description link; Date Dropped field |
12 | CLASS EXIT TYPE CODE | 165 – 184 |
| Leave blank |
|
13 | CLASS EXIT COMMENT | 185 – 224 |
| Leave blank |
|
14 | CLASS PERIOD | 225 – 254 |
| Leave blank |
|
15 | COURSE DELIVERY MODEL CODE | 255 – 274 |
| Leave blank |
|
16 | COURSE CONTENT CODE | 275 – 294 |
| Leave blank |
|
17 | COURSE INCLUSION CODE | 295 – 314 |
| Leave blank |
|
18 | SPECIAL PROGRAM CODE | 315 – 317 |
| Leave blank |
|
19 | ALTERNATE CREDIT COURSE CODE | 318 – 347 |
| Leave blank |
|
20 | COURSE INSTRUCTOR SNAPSHOT DATE | 348 – 357 |
| Leave blank |
|
21 | HOMEROOM INDICATOR | 358 – 360 |
| Leave blank |
|
22 | STUDENT GRADE LEVEL CODE WHEN TAKEN | 361 – 385 |
| Leave blank |
|
23 | EXCLUDE FROM EVALUATION INDICATOR | 386 – 388 |
| Leave blank |
|
24 | *TERM CODE | 389 – 408 | NYS Reporting | Nytb_Terms.State_Code_Equiv where reg_mp_weeks.Term = nytb_terms.Code | Administration > General Setup > District > Validation Tables > select New York State Reporting > Term: State Code Equiv |
25 | *MARKING PERIOD CODE | 409 – 448 | NYS Reporting | NA (hard-coded value) |
|
26 | *DUAL/CONCURRENT CREDIT INDICATOR | 449 – 451 | NYS Reporting | First, check for a Master Schedule district-defined page value. Schd_ms_user.field_value where schd_ms_user.screen_number = 2000 and field_number = 6 If there is no value at the Master Schedule level, check for a building Course Catalog district-defined page value. Schd_course_user.field_value where schd_course_user.screen_number = 2000 and field_number = 6 If the Building Course Catalog value is missing, default a value of N. | First, check Scheduling > Courses > Course Sections > Master Schedule > NY Course Information: Dual Credit |