Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.