Course Instructor Assignment 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 Course Instructor Assignment 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 | *COURSE DISTRICT CODE (DISTRICT OF RESPONSIBILITY 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 | *COURSE LOCATION CODE | 9 – 14 | NYS Reporting | schd_ms.building | Scheduling > Courses > Course Sections > Master Schedule: Building |
3 | *SCHOOL YEAR DATE | 15 – 24 | NYS Reporting | (School Year from Download prompt) + '-06-30' | School Year from New York Teacher Course Download page |
4 | *COURSE CODE (LONG) | 25 – 28 | NYS Reporting | schd_ms.course | Scheduling > Courses > Course Sections > Master Schedule: Course |
5 | *SUPPLEMENTARY COURSE DIFFERENTIATOR | 29 – 31 | NYS Reporting | Leave blank | |
6 | *SECTION CODE (LONG) | 32 – 56 | NYS Reporting | schd_ms.course_section | Scheduling > Courses > Course Sections > Master Schedule: Course Section |
7 | *TERM CODE | 57 – 76 | 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 |
8 | *MARKING PERIOD CODE | 77 – 116 | NYS Reporting | Leave blank | |
9 | *INSTRUCTOR DISTRICT CODE | 117 – 124 | 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 |
10 | *INSTRUCTOR ID | 125 – 136 | NYS Reporting | Schd_ms_staff_date.staff_id | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Staff |
11 | *INSTRUCTOR START DATE | 137 – 146 | NYS Reporting | Schd_ms_staff_date.start_date | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Start Date |
12 | +INSTRUCTOR END DATE | 147 – 156 | NYS Reporting | Schd_ms_staff_date.end_date | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: End Date |
13 | *PRIMARY INSTRUCTOR INDICATOR | 157 – 159 | NYS Reporting | Schd_ms_staff_date.primary_secondary | This is not a setting that explicitly displays in the software. On the Master Schedule page, you can click the Primary or Secondary Staff link to see designations for a course-section session's staff. If a secondary staff member has the Staff Date Tracking page's Co-Teacher box selected, the teacher reports a Y in this field. |
14 | *PRIMARY SPECIAL ED INSTRUCTOR INDICATOR | 160 – 162 | NYS Reporting | Schd_ms_staff_user.field_value where field_number = 6 | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Special Education Instructor |
15 | INSTRUCTOR TYPE CODE | Leave blank | |||
16 | *PRIMARY INSTRUCTION DELIVERY METHOD CODE | 163 - 182 | NYS Reporting | Schd_ms_staff_user.field_value where field number = 7 | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Primary Delivery Method |
17 | *PRIMARY ENL INSTRUCTOR INDICATOR | 183 – 185 | NYS Reporting | Schd_ms_staff_user.field_value where field number = 8 | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: ENL Instructor |
18 | *PRIMARY COURSE INSTRUCTION LANGUAGE INDICATOR (PRIMARY INSTRUCTION LANGUAGE CODE) | 186 – 205 | NYS Reporting | Schd_ms_user.field_value where screen_number = 2000 and field_number = 9 If the Master Schedule value does not exist, use the schd_course_user.field_value where screen_number = 2000 and field_number = 9 If the value does not exist at the level of course-section or building course catalog, use the field_value from schd_course_user where building = -1, indicating the District Course Catalog | Scheduling > Courses > Course Sections > NY Course Information: Primary Instruction Lang Code field The download defaults ENG for English. |
19 | ALTERNATIVE INSTRUCTION LANGUAGE CODE | 206 – 225 | Leave Blank | N/A | N/A |
20 | INCIDENTAL TEACHING ASSIGNMENT INDICATOR Note: This field no longer exists in the Course information page and has been moved to the Master Schedule page. | 226 – 228 | NYS Reporting | Schd_ms_staff_user.field_value where field number = 9 | Scheduling > Courses > Course Sections > Master Schedule > click link for Primary or Secondary Staff: Incidental Teacher Assign Ind |