| 005 |
Collection Version |
CollectionVersion |
Required |
Collection version should contain this value '2010Jun1.0StuCRSComp' for the 2010 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. |
DESE_District_Codes |
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 as of the time data is being submitted unless otherwise specified. |
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 classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes, show as separate assignments. |
|
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 than one grade in a self-contained elementary classroom or is teaching morning and afternoon pre-kindergarten or kindergarten classes, show as separate assignments. |
State_Course_Codes |
Text |
6 |
|
| 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 center, COLL if instruction is provided on college campus, or ITV if instruction is provided by college through instructional television to students in district classroom else null. |
Dual_Credit_Site_Codes |
Text |
4 |
|
| 192 |
Course Semester |
CourseSem |
Conditional |
Required if (GradeEarned is not IC or WD) or if CreditEarned is greater than zero. Semester (0 - full year, 1 - first semester, 2 - second semester) else null. |
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 CourseSem. |
|
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 CourseSem. |
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 |
Required |
Course is designated as a honors level course. |
Yes_No |
Text |
1 |
|
| 233 |
Course Completion Comment |
CrsCompComment |
Optional |
Free-form notes used to indicate (1) job titles for Course 887900, (2) course titles for "Other" (xxxx99) courses, (3) supplemental assignment for Course 880000, (4) teachers assisted by an aide, (5) aides assisting a teacher or (6) other nonstandard info |
|
Text |
70 |
|