FileSpec:201406JuneCycleSummerCourseAssignment
Item Item Name Column Name Required Definition Code Set Data Type Length Precision
005 Collection Version CollectionVersion Required Collection version should contain this value '2014Jun1.0SumCrsAssign' for the 2014 June Cycle Summer Course Assignment file layout.
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
050 ED SSN EDSSN Required 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
060 Educator Last Name LastName Required Educator's Legal last name.
Text 60
065 Educator First Name FirstName Required Educator's Legal first name.
Text 60
070 Position Code PosCode Required Position code of educator’s assignment. Position_Codes Text 2
080 CTE Program Type CTEProgType Optional Program type code of CTE approved program. CTE_Program_Type_Codes Text 4
090 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
100 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
110 Local Course Name LocCourseName Optional Course name abbreviation.
Text 60
120 Local Section Number LocSecNum Optional Local Section Number
Text 6
130 State Course Number CourseNum Conditional 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
140 Assignment Start Date AssignStartDate Optional Date course is added after beginning of school year or filled for first time after beginning of school year or an individual replaces original course educator after beginning of school year else null.
Text 10
150 Assignment End Date AssignEndDate Optional Date course is eliminated prior to end of school year or individual is transferred out of position prior to end of school year (leaving position vacant) or individual is replaced in position with another individual prior to end of school year else null.
Text 10
170 Course Sequence Number CourseSeqNum Optional 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
180 Course Grade Level CourseGradeLevel Required Grade level at which curriculum for the specific course is designed to be taught. Grade level should reflect the grade at which the course curriculum is meant to be offered; not necessarily describe the students in the classroom. For example, if General Science is offered as a 9th grade class, it should be reported as grade 9 even though some 10th or 11th grade students may be in the classroom. Conversely, a Physics class offered as a junior level (or third high school year) course that contains advanced standing freshmen and/or sophomores should be coded grade 11 (not grade 13). Assignment_Grade_Level_Codes Text 2
190 Course Semester CourseSem Optional Semester (blank - full year, 1 - first semester, 2 - second semester) else null. Course_Semester_Codes Text 1
200 Course Delivery System CourseDeliverySys Conditional Delivery System. Instructional delivery method else null. Course_Delivery_System_Codes Text 2
210 Course Program Code CourseProgCode Conditional Program code that identifies special funding or approval else null. Course_Program_Codes Text 2
220 Course Minutes CourseMins Optional Minutes per week for class/assignment. (Student passing time and “Channel One” are not included.)
Integer 4
230 Course Credits CourseCredit Conditional Credit. Units of high school credit granted for assignment else null.
Number 4 2
235 Caseload Caseload Conditional Number of students served in an educational setting other than a regularly scheduled class.
Integer 4
240 Course Total Hours CourseHours Required Total hours the class meets during the full duration of the summer school program (normally 60 to 120 clock hours). This item is not allowed to be reported in October.
Number 6
242 Assignment Comment AssignComment 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
245 Combined Course CombinedCourse Conditional Combined classes are situations where students of two or more different subjects or course sequence levels (or grade levels for self-contained elementary classes) are taught during the same time period by the same teacher.
Integer 2