| 005 |
Collection Version |
CollectionVersion |
Required |
Collection version should contain this value '2018Jun1.0StuCRSComp' for the 2018 June Student Course Completion Collection. |
|
Text |
50 |
|
| 010 |
Current School Year |
CurrentSchoolYear |
Required |
The ending year of the current school year. For example, use '2007' for the 2006-2007 school year. |
|
Integer |
4 |
|
| 025 |
Reporting District Code |
ReportingDistrictCode |
Required |
DESE assigned 6 digit county district code for the district reporting. |
DESE_District_Codes |
Text |
6 |
|
| 030 |
Reporting School Code |
ReportingSchoolCode |
Required |
DESE assigned 4 digit school code where the student is being reported from. |
DESE_School_Codes |
Text |
4 |
|
| 032 |
Receiving Coll/Dist Code |
ReceivingCollDistCode |
Conditional |
Required if student was sent to another institution. 6 digit code for site at which instruction of normal or college credit (dual credit) course is given. |
|
Text |
6 |
|
| 034 |
Sending District Code |
SendDistCode |
Conditional |
Required if student was sent to another institution. 6-digit number and name of sending district else null. |
DESE_District_Codes |
Text |
6 |
|
| 036 |
Sending School Code |
SendSchoolCode |
Conditional |
Required if student was sent to another institution. 4-digit number and name of sending high school else null. |
DESE_School_Codes |
Text |
4 |
|
| 045 |
MOSIS ID |
StateID |
Required |
State assigned student identifier. See http://dese.mo.gov/MOSIS for more information. |
|
Text |
10 |
|
| 055 |
Student Local Student ID |
LocalStudentID |
Optional |
Local student id maintained by the district. Allows for data to be associated to local systems from DESE source systems. |
|
Text |
20 |
|
| 060 |
Student Legal Last Name |
StudentLastName |
Optional |
Legal last name as appears on certificate of birth. |
|
Text |
60 |
|
| 065 |
Student Legal First Name |
StudentFirstName |
Optional |
Legal first name as appears on certificate of birth. |
|
Text |
60 |
|
| 070 |
Student Legal Middle Name |
StudentMiddleName |
Optional |
Legal middle name as appears on certificate of birth. |
|
Text |
60 |
|
| 075 |
Student Legal Name Suffix |
StudentNameSuffix |
Optional |
Legal name suffix as appears on certificate of birth. E.g. Jr, Sr |
|
Text |
10 |
|
| 080 |
Student Date of Birth |
StudentDateofBirth |
Required |
Date of birth as appears on certificate of birth. |
|
Text |
10 |
|
| 095 |
Student Grade Level |
StudentGradeLevel |
Required |
Required for all students who are not adults taking special adult programs. Grade level at the time of completion of the course. |
Student_Grade_Level_Codes |
Text |
2 |
|
| 111 |
ED SSN |
EDSSN |
Conditional |
Required if the Reporting and Receiving district are the same or if there is no Receiving district. Educator Social Security Number. Formats allowed '999999999'. |
|
Text |
9 |
|
| 113 |
Educator Last Name |
EDLastName |
Optional |
Educator's Legal last name. |
|
Text |
60 |
|
| 115 |
Educator First Name |
EDFirstName |
Optional |
Educator's Legal first name. |
|
Text |
60 |
|
| 117 |
Position Code |
PosCode |
Required |
Position code of educator’s assignment. |
Position_Codes |
Text |
2 |
|
| 119 |
CTE Program Type |
CTEProgType |
Conditional |
Required for approved career education courses. Program type code of CTE approved program. |
CTE_Program_Type_Codes |
Text |
4 |
|
| 120 |
Assignment Number |
AssignNum |
Required |
The number used to uniquely identify an instance of an educators course assignment also used to link that course to the records of students within the course. |
|
Text |
20 |
|
| 121 |
Local Section Number |
LocSecNum |
Optional |
Local Section Number |
|
Text |
6 |
|
| 123 |
Local Course Number |
LocCourseNum |
Optional |
Course code that identifies assignment. Every assignment must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. If a teacher has more than one grade in a self-contained elementary |
|
Text |
12 |
|
| 125 |
Local Course Name |
LocCourseName |
Optional |
Course name abbreviation. |
|
Text |
60 |
|
| 130 |
State Course Number |
CourseNum |
Required |
Required if not a self-contained classroom. Course code that identifies assignment. Every assignment must be identified by a course code except pre-kindergarten, kindergarten, and elementary classes in self-contained classrooms. If a teacher has more th |
State_Course_Codes |
Text |
6 |
|
| 190 |
Course Time Unit |
CourseTimeUnit |
Required |
The unit of time for which the grade and credit earned was for. (Q1, Q2, Q3, Q4, S1, S2, T1, T2, T3, YL) |
Course_Time_Unit_Codes |
Text |
2 |
|
| 191 |
Dual Credit Site |
DualCreditSite |
Conditional |
Required if RecevingColDistCode is not equal to ReportingDistrictCode and the RecevingColDistCode is a college. Site at which instruction of college credit (dual credit) course is given. Enter DIST if instruction is provided at district attendance cente |
Dual_Credit_Site_Codes |
Text |
4 |
|
| 192 |
Course Semester |
CourseSem |
Optional |
Semester (0 - full year, 1 - first semester, 2 - second semester, 3 - third semester) else null. Superceded by Item 190 Course Time Unit. |
Course_Semester_Codes |
Text |
1 |
|
| 193 |
Student Credits Earned |
CreditEarned |
Required |
The amount of credit earned by the student for the course in the unit of time specified in CourseTimeUnit. |
|
Number |
4 |
2 |
| 195 |
Student Credits Scheduled |
CreditScheduled |
Required |
The amount of credit the student was scheduled to earn. If the student signed up for 1 semester of a 2 semester course and earned full credit from the 1 semester completed then credit earned and credit scheduled would have the same value. |
|
Number |
4 |
2 |
| 201 |
Student Grade Earned |
GradeEarned |
Required |
Grade the student earned for the course in the unit of time specified in CourseTimeUnit. |
Grade_Codes |
Text |
2 |
|
| 205 |
Advanced Placement |
AdvPlacement |
Required |
Course is designated as an advanced placement course (AP). |
Yes_No |
Text |
1 |
|
| 207 |
Honors |
Honors |
Optional |
Course is designated as a honors level course. |
Yes_No |
Text |
1 |
|
| 233 |
Course Completion Comment |
CrsCompComment |
Optional |
Free-form notes. |
|
Text |
70 |
|
| 235 |
Course Sequence Number |
CourseSeqNum |
Conditional |
Sequence number that identifies the content of courses taught at more than one level. If only one level of course content is offered, leave SEQ blank. |
Course_Seq_Num_Codes |
Text |
1 |
|