Master Schedule Collection File Layout Student Section

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