Master Schedule Collection File Layout Student Section
Field Name | Where in eSchoolPlus? | Notes/Issues | Fall | EOY |
---|---|---|---|---|
Record Type | Hard-coded value | "F" | X | X |
Section ID | Unique identifier associated with the Master Schedule record (schd_ms.section_key) | Required | X | X |
Local Provider ID | Scheduling > Courses > Course Sections > Master Schedule: Primary Staff field (schd_ms.primary_staff_id) or, For secondary staff, schd_ms_staff_student.staff_id | Required | X | X |
State Testing ID | Registration > Entry & Reportss > Personal: State ID field (reg_personal.state__report_id) | Required | X | X |
Local Student ID | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Student ID field (schd_stu_crs_dates.student_id) | X | X | |
Final Grade | Based on Local Student ID and Section ID, the submission file reports mr_stu_marks.mark_value where mr_stu_marks.marking_period = N/A You can view final grades here: Mark Reporting > Entry & Reports > Student > Transcript Summary: Final column for a particular course. | For information on valid entries, refer to the VA DOE Master Schedule Collection page. | X | |
Virtual Course Indicator | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Virtual Course Type field (schd_stu_user.field_value where screen_number = 10450 and field_number = 4) or, Scheduling > Courses > Course Sections > VA Course Information: Virtual Course Type field (schd_ms_user.field_value where screen_number = 200 and field_number = 2) In either case, the submission file converts to vatb_virt_crs_type.state_code_equiv. | 1 = School sponsored/coordinated 2 = Student coordinated | X | X |
Dual Enrollment Flag | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Dual Enrollment field (schd_stu_user.field_value where screen_number = 10450 and field_number = 5) or, Scheduling > Courses > Course Sections > VA Course Information: Dual Enrollment field (schd_ms_user.field_value where screen_number = 200 and field_number = 3) | X | X | |
Work Based Learning Code | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Virtual Course Type field (schd_stu_user.field_value where screen_number = 10450 and field_number = 7) | CTE courses only | X | X |
Governor Academy | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Virtual Course Type field (schd_stu_user.field_value where screen_number = 10450 and field_number = 8) | X | X | |
Responsible Division | Program tracked field reg_programs inner join with reg_program_columns Where state_code_equiv= ALTDIS | X | X | |
Credit Awarded Flag | Scheduling > Student Schedules > Schedule Entry > select course > Date Range Detail panel > Other Student Course Information section > VA Course Enrollment: Verified Credit Awarded field (schd_stu_user.field_value where screen_number = 10450 and field_number = 6) | X |