Course Assignment File Layout
| Field # | Field Name | Data Type | Field Length | eSchoolPLUS table.column | Validation Table | Where in eSchoolPLUS? |
|---|---|---|---|---|---|---|
| 5 | Collection Version | Text | 50 | calculated | ||
| 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 equiv | Administration > General Setup > District > District > Preferences panel > Other panel: State Code Equivalent | |
| 30 | Reporting School Code | Text | 4 | schd_ms.building converted to state code | reg_buildings | Scheduling > Courses > Course Sections > Master Schedule > Course panel: Building |
| 50 | ED SSN | Text | 9 | reg_staff.ssn | Scheduling > Courses > Resources > Staff > Staff Information panel: Social Security Number | |
| 60 | Educator Last Name | Text | 60 | reg_staff.last_name | Scheduling > Courses > Resources > Staff > Staff Information panel: Last Name | |
| 65 | Educator First Name | Text | 60 | reg_staff.first_name | Scheduling > Courses > Resources > Staff > Staff Information panel: First Name | |
| 70 | Position Code | Text | 2 | get reg_user_staff.field_value for reg_user_staff.field_number = 1 and screen_number 550. converted to state_code_equiv using motb_position | motb_position | Scheduling > Courses > Resources > Staff > District-Defined panel > MOSIS Staff: Position Code Only non teachers need a value. Defaults to Teacher Code if blank. |
| 80 | CTE Program Type | Text | 4 | get schd_ms_user.field_value for field_number 1 and screen_number 550 | motb_cte_program | Scheduling > Courses > Course Sections > MOSIS Course Information: CTE Program Type |
| 90 | Assignment Number | Integer | 20 | schd_ms.section_key | Section Key for the course-section Section Key cannot be seen through eSchoolPLUS-- this is a unique key for course-sections. | |
| 100 | Local Course Number | Text | 12 | schd_ms.course | Scheduling > Courses > Course Sections > Master Schedule > Course panel: Course | |
| 110 | Local Course Name | Text | 60 | schd_ms.description | Scheduling > Courses > Course Sections > Master Schedule > Course-Section panel > General Information panel: Description | |
| 120 | Local Section Number | Text | 6 | schd_ms.course_section | Scheduling > Courses > Course Sections > Master Schedule > Course panel: Section | |
| 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 | motb_state_course | Scheduling > Courses > Course Sections > MOSIS Course Information: State Course Number |
| 140 | Assignment Start Date | Text | 10 | calculated value | Scheduling > Student Schedules > Student > Schedule Entry > Schedule List panel: Add Date or Scheduling > Courses > Resources > Staff > Building Information panel > click Building link > District-Defined panel > Course Assignments: Start Date | |
| 150 | Assignment End Date | Text | 10 | calculated value | Scheduling > Student Schedules > Student > Schedule Entry > Schedule List panel: Drop Date or Scheduling > Courses > Resources > Staff > Building Information panel > click Building link > District-Defined panel > Course Assignments: End Date | |
| 170 | Course Sequence Number | Text | 1 | schd_course/schd_ms_user.screen_number = 550, field_number = 3 get the field_value | motb_course_seq | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Sequence Number |
| 180 | Course Grade Level | Text | 2 | schd_course/schd_ms_user.screen_number = 550, field_number = 4 get the field_value | motb_course_grade | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Grade Level |
| 190 | Course Semester | Text | 1 | schd_course/schd_ms_user.screen_number = 550, field_number = 5 get the field_value | motb_semester | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Semester |
| 200 | Course Delivery System | Text | 2 | schd_course/schd_ms_user.screen_number = 550, field_number = 7 get the field_value | motb_delivery | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Delivery System |
| 210 | Course Program Code | Text | 2 | schd_course/schd_ms_user.screen_number = 550, field_number = 6 get the field_value | motb_program_code | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Program Code |
| 220 | Course Minutes | Integer | 4 | calculated value | The download first looks at Scheduling Center > Master Schedule > MOSIS Course Information: Instructional Minutes field. If no value found, then it is calculated in the following manner: for scheduled courses, we are using the minutes from the Attendance Periods setup. For Planning and Travel time, we have created Staff Building User defined screen - Staff Assignment, for each staff in a building we will be capturing Planning Time/Travel, Start Date, End Date and Number of Minutes. | |
| 230 | Course Credits | Number | 4 | calculated value | Scheduling > Courses > Course Sections > Master Schedule > Session Information panel > Mark Reporting and Attendance Information panel: Credit Sum of all credits for all sessions of a course section. | |
| 235 | Caseload | Integer | 4 | schd_course/schd_ms_user.screen_number = 550, field_number = 13 get the field_value | ||
| 240 | Course Total Hours | Number | 4 | schd_course/schd_ms_user.screen_number = 550, field_number = 14 get the field_value | Scheduling > Courses > Course Sections > MOSIS Course Information: Course Hours | |
| 242 | Assignment Comment | Text | 70 | get reg_user_staff.field_value for reg_user_staff.field_number = 2 and screen_number 550 | Scheduling > Courses > Resources > Staff > District-Defined panel > MOSIS Staff: Assignment Comment | |
| 245 | Combined Course | Integer | 2 |