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:
- Field 21 ALTERNATE INSTRUCTION LANGUAGE CODE – No 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 Number | Field Name | Data Type, Required, Code | Valid Values |
|---|---|---|---|
| 1 | DISTRICT CODE | Character, Required, Key | |
| 2 | LOCATION CODE | Character, Required, Key | |
| 3 | SCHOOL YEAR DATE | Date, Required, Key |
|
| 8 | PRIMARY INSTRUCTOR ID | Character, Required, Key | 9 digit staff id |
| 9 | OTHER INSTRUCTOR 1 | Character, Optional, Updateable | 9 digit staff id |
| 10 | OTHER INSTRUCTOR 2 | Character, Optional, Updateable | 9 digit staff id |
| 16 | STAFF NAME | Character, Optional, Updateable | |
| 17 | SEMESTER | Character, Required, Key |
|
| 18 | CLASS PERIOD | Character, Required, Updateable |
|
| 19 | COURSE CODE LONG | Character, Required, Key | SY19 Course Codes (xlsx) |
| 21 | ALTERNATE INSTRUCTION LANGUAGE CODE | Character, 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 |
| 22 | SECTION CODE LONG | Character, Required, Key | |
| 24 | SNAPSHOT DATE | Character, Required, Key |
|
| 60 | COURSE SPECIAL PROGRAM CODE | Character, Conditionally Required, Updateable |
|
| 64 | HONORS INDICATOR | Character, Required, Updateable |
|
| 65 | ADVANCED PLACEMENT INDICATOR | Character, Required, Updateable |
|
| 66 | CAREER AND TECHNICAL INDICATOR | Character, Required, Updateable |
|
| 67 | GIFTED INDICATOR | Character, Required, Updateable |
|
| 69 | REMEDIAL INDICATOR | Character, Required, Updateable |
|
| 70 | BASIC/GENERAL INDICATOR | Character, Required, Updateable |
|
| 71 | SPECIAL EDUCATION INDICATOR | Character, Required, Updateable |
|
| 72 | INTERNATIONAL BACCALAUREATE INDICATOR | Character, Required, Updateable |
|
| 74 | ELECTIVE INDICATOR | Character, Required, Updateable |
|
| 78 | LAB COMPONENT INDICATOR | Character, Required, Updateable |
|
| 83 | ADVANCED INDICATOR | Character, Required, Updateable |
|
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.