Skip to Content

Course Instructor Template

Course Instructor Template 2019-07-29T15:53:00-06:00

Target Table: CRSE_INSTRUCT_SNAPSHOT; eDM name:  CRSE_INSTRUCT

Data Submission Schedule: K5P, 40 Day, 80 Day, 120 Day, End of Year (EOY), Open Year Round (7/15), Summer (Optional)

Grain:  One record per district / location / school year / course code / section / semester (reporting period)

Load Dependencies:
1.   Course Required
2.   Staff Required

Template Description – The Course Instructor Template is used to identify the instructor(s) of each course/section (unique classroom) in which students are enrolled.

School Year 2019-2020 Changes:

  1. Field 21 ALTERNATE INSTRUCTION LANGUAGE CODENo change in code set. However important additional clarification was added regarding the language of instruction for PreK classes.

File Name Format:  DDD_CRSE_INSTRUCT_YYYYMMDDHHMM.fff
File Name Format Example:  001_CRSE_INSTRUCT_201807071201.csv

Field NumberField NameData Type, Required, CodeValid Values
1DISTRICT CODECharacter, Required, Key
2LOCATION CODECharacter, Required, Key
3SCHOOL YEAR DATEDate, Required, Key
  • 2019-06-30 = SY18-19
  • 2020-06-30 = SY19-20
8PRIMARY INSTRUCTOR IDCharacter, Required, Key9 digit staff id
9OTHER INSTRUCTOR 1Character, Optional, Updateable9 digit staff id
10OTHER INSTRUCTOR 2Character, Optional, Updateable9 digit staff id
16STAFF NAMECharacter, Optional, Updateable
17SEMESTERCharacter, Required, Key
  • 1 = 40D
  • 2 = 80D
  • 3 = 120D
  • 4 = EOY
  • 5 = K5P
  • 6 = Summer (optional)
  • 9 = Open Year Round
18CLASS PERIODCharacter, Required, Updateable
  • AM = Morning
  • PM = Afternoon
  • FD = Full Day
  • SEM = Semester
  • TRI = Trimester
  • YR = Year-long
  • BLK = Block Scheduling
  • SP = Self-paced
  • QTR = Quarter
  • PO = Pull-out
19COURSE CODE LONGCharacter, Required, KeySY19 Course Codes (xlsx)
21ALTERNATE INSTRUCTION LANGUAGE CODECharacter, Conditionally Required, Updateable
00 = English
01 = Spanish
02 = Vietnamese
03 = Hmong; Mong
04 = Chinese (Cantonese or Mandarin)
05 = Cambodian – Khmer
06 = Korean
07 = Laotian
08 = Navajo; Navaho (Diné)
09 = Tagalog
10 = Russian
11 = Creoles, French-based
12 = Arabic
13 = Portuguese
14 = Japanese
16 = Tiwa
17 = Tewa
18 = Towa
19 = Keres
20 = Jicarilla Apache
21 = Mescalero Apache
22 = Zuni
24 = Sign Languages – American
25 = Sign Languages – English Based
26 = Albanian
27 = Armenian
28 = Azerbaijani
29 = Baltic languages
30 = Basque
31 = Bosnian
32 = Bulgarian
33 = Burmese
34 = Chechen
35 = Creoles, English based
36 = Creoles, Portuguese-based
37 = Croatian
38 = Czech
39 = Danish
40 = Dutch; Flemish
41 = Estonian
42 = Farsi – Persian
43 = Filipino; Pilipino
44 = Finnish
45 = French
46 = German
47 = Greek
48 = Haitian; Haitian Creole
49 = Hawaiian
50 = Hebrew
51 = Hungarian
52 = Icelandic
53 = India and Bangladesh – Bengali
54 = India – Gujarati
55 = India – Marathi
56 = India – Rajasthani
57 = India – Telugu
58 = India and Assam – Assamese
59 = India and Pakistan – Hindi
60 = India and Pakistan – Urdu
61 = India or Pakistan Panjabi; Punjabi
62 = India, Malaysia, Sri Lanka – Tamil
63 = Indonesian
64 = Iranian languages
65 = Italian
66 = North American Indian languages Other
67 = Norwegian
68 = Polish
69 = Romanian; Moldavian; Moldovan
70 = Somali
71 = Serbian
72 = Slavic languages
73 = Swedish
74 = Thai
75 = Tibetan
76 = Ukrainian
77 = Hocano
78 = Kurdish (includes any country where spoken such as Iraq and Afganistan)
79 = Syriac
80 = Cebuano (Visayan)
81 = Chamorro
82 = Kinyarwanda (includes Kirundi)
83 = Lithuanian
84 = Malayalam
85 = Marshallese
86 = Mixteco
87 = Nepali
88 = Pashto (includes Pushto)
89 = Samoan
90 = Sinhalese (includes Sinhala)
91 = Swahili
92 = Tongan (includes Raratongan)
93 = Turkish
94 = Wolof
95 = Yao (includes Mien)
96 = Fanti (spoken in Ghana
22SECTION CODE LONGCharacter, Required, Key
24SNAPSHOT DATECharacter, Required, Key

  • 2018-10-01 = 40D
  • 2018-12-15 = 80D
  • 2019-03-01 = 120D
  • 2019-06-01 = EOY
  • 2019-06-29 = Summer (Optional)
  • 2018-09-01 = K3P
  • 2018-07-15 = Open-Year-Round

  • 2019-10-01 = 40D
  • 2019-12-15 = 80D
  • 2020-03-01 = 120D
  • 2020-06-01 = EOY
  • 2020-06-29 = Summer (Optional)
  • 2019-09-01 = K5P
  • 2019-07-15 = Open-Year-Round

60COURSE SPECIAL PROGRAM CODECharacter, Conditionally Required, Updateable
  • BEP = Bilingual Multicultural Education Program
64HONORS INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
65ADVANCED PLACEMENT INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
66CAREER AND TECHNICAL INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
67GIFTED INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
69REMEDIAL INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
70BASIC/GENERAL INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
71SPECIAL EDUCATION INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
72INTERNATIONAL BACCALAUREATE INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
74ELECTIVE INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
78LAB COMPONENT INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No
83ADVANCED INDICATORCharacter, Required, Updateable
  • Y = Yes
  • N = No

Guidance:

  • The Course Instructor template must be submitted at each reporting period. Be sure to include all courses taught on the reporting period’s snapshot date. It may be necessary to include courses that have ended between reporting periods in order to submit a student’s grade.
  • Only submit a Course Instructor record if there are students enrolled in the class. If no students are enrolled in the course (but the course is part of your Course Catalog), you must still report the Course Code in the COURSE template as a course being offered for the reporting period; however, you would NOT report a COURSE INSTRUCTOR record.
  • Semester, Course Instructor Snapshot Date, Course Code Long, and Section Code Long MUST match the corresponding fields in the Student Course Enrollment Template and the Course Template for proper HQT results.
  • This template requires the combination of the COURSE CODE LONG and SECTION CODE LONG fields to be unique (PRIMARY INSTRUCTOR ID is NOT part of the unique key). PED is aware that some districts have multiple sections of the same course with the same section number. If a district’s or charter school’s PED-defined course code and local section code are not unique, it may be necessary to concatenate the district or school’s local section code with the PRIMARY INSTRUCTOR ID (masked) in the SECTION CODE LONG field. PED suggests that the format be [local section code + “-” + PRIMARY INSTRUCTOR ID (masked)]. For example, a SECTION CODE LONG of “1-111223333” could be used (1 representing the local section code and 111223333 representing the staff member teaching that section). If this format is used for SECTION CODE LONG in this template, it must be used in the required SECTION CODE LONG fields in other templates.

 

Page last updated July 29, 2019