Course Instructor Assignment File Layout

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