| Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table |
|---|
| 5 | Collection Version | Text | 50 | Collection version should contain this value '2010Jun1.0StuCRSComp' for the 2010 June Student Course Completion Collection. | |
| 10 | Current School Year | Integer | 4 | The ending year of the current school year. For example, use '2007' for the 2006-2007 school year. | |
| 25 | Reporting District Code | Text | 6 | reg_district.district converted to state code | |
| 30 | Reporting School Code | Text | 4 | reg_entry_with.building converted to state code | |
| 32 | Receiving Coll/Dist Code | Text | 6 | schd_stu_user, screen 550, field 1 | motb_dese_district.state_code_equiv |
| 34 | Sending District Code | Text | 6 | schd_stu_user, screen 550, field 2, left 6 digits | |
| 36 | Sending School Code | Text | 4 | schd_stu_user, screen 550, field 2, right 4 digits | |
| 45 | MOSIS ID | Text | 10 | reg_personal.state_report_id | |
| 55 | Student Local Student ID | Text | 20 | reg.student_id | |
| 60 | Student Legal Last Name | Text | 60 | reg.last_name | |
| 65 | Student Legal First Name | Text | 60 | reg.first_name | |
| 70 | Student Legal Middle Name | Text | 60 | reg.middle_name | |
| 75 | Student Legal Name Suffix | Text | 10 | reg.generation | |
| 80 | Student Date of Birth | Text | 10 | reg.birthdate | |
| 95 | Student Grade Level | Text | 2 | reg_entry_with.grade converted to state code equiv using reg_grade table. | |
| 111 | ED SSN | Text | 9 | reg_staff.ssn | |
| 113 | Educator Last Name | Text | 60 | reg_staff.last_name | |
| 115 | Educator First Name | Text | 60 | reg_staff.first_name | |
| 117 | Position Code | Text | 2 | get reg_user_staff.field_value for reg_user_staff.field_number = 1 and screen_number 550 (Mosis Staff Screen). converted to state_code_equiv using motb_position | |
| 119 | CTE Program Type | Text | 4 | schd_ms_user.field_value for field_number 1 and screen_number 550 | |
| 120 | Assignment Number | Integer | 20 | schd_ms.section_key | |
| 121 | Local Section Number | Text | 6 | schd_ms.course_section | |
| 123 | Local Course Number | Text | 12 | schd_ms.course | |
| 125 | Local Course Name | Text | 60 | schd_ms.description | |
| 130 | State Course Number | Text | 6 | schd_course/schd_ms_user.screen_number = 550, field_number = 2 get the field_value. Converted to state code using motb_state_course | |
| 190 | Course Time Unit | Text | 2 | | |
| 191 | Dual Credit Site | Text | 4 | schd_stu_user, screen 550, field 3 | |
| 192 | Course Semester | | | Using the state code equiv from reg_mp_weeks where marking period equals the marking period associated with the mark | |
| 193 | Student Final Credits Earned | Number | 4 | mr_stu_hdr.earned_credits | |
| 195 | Student Credits Scheduled | Number | 4 | mr_stu_hdr.att_credits | |
| 201 | Student Grade Earned | Text | 2 | mr_stu_marks.mark | |
| 205 | Advanced Placement | Text | 1 | schd_course/schd_ms_user.screen_number = 550, field_number = 15 get the field_value. | |
| 207 | Honors | Text | 1 | schd_course/schd_ms_user.screen_number = 550, field_number = 16 get the field_value. | |
| 233 | Course Completion Comment | Text | 70 | schd_stu_user, screen 550, field 4 | |
| 235 | Course Sequence Number | Text | 1 | | |
