Master Schedule Collection File Layout Course Section

Record Type

Hard-coded value

"C"

X

X

Section ID

Unique identifier associated with the Master Schedule record (schd_ms.section_key)

Required

X

X

Serving Division

State code equivalent for the state-assigned Division number associated with the Master Schedule record

(reg_district.state_code_equiv where schd_ms.district = reg_district.district)

Number for the division, center, or agency providing the course.

X

X

Serving School

State code equivalent for the state-assigned School number associated with the Master Schedule record

(reg_building.state_code_equiv where schd_ms.building = reg_building.building)

Number for the school, center, program, or placement providing the course (or resource to the course).

X

X

SCED Course Code

Administration > Mark Reporting Setup > Calculation Setup > Course Equivalency Definition: first two characters from State ID field for record associated with this Master Schedule course (mr_crsequ_det.state_id)

or,

Scheduling > Courses > Course Sections > Master Schedule: Subject Area field for Subject Order = 1 (schd_ms_subj.subject_area for subj_order = 1)

The Subject Area is converted to the appropriate State Code Equiv value from Administration > General Setup > District > Validation Tables > select Mark Reporting > Graduation Requirement Area

(mr_req_areas.state_code_equiv where schd_ms_subj.subject_area = mr_req_areas.code)

For information on valid state codes, refer to the VA DOE Master Schedule Collection page.

X

X

Retired

Formerly Course Identifier

SCED Course Level

Scheduling > Courses > Course Sections > VA Course Information: Co-Op Count

schd_ms_user.screen_number = 200 and field_number = 4

X

X

Retired

Formerly Available Credit or Grade Span

SCED Sequence

Calculated based on which part of the course state equivalency sequence gets fulfilled by this course. This is expressed in terms of the course's position in the sequence followed by the total number of parts in the sequence.

This is determined by the Course Equivalency setup, and you can view this information by selecting Administration > Mark Reporting Setup > Calculation Setup > Course Equivalency Definition

(mr_crsequ_det.equiv_parts mr_crsequ_det.equiv_sequence)

For example, suppose the course can be taken as the second part in a three-course sequence. In the submission file, this field will show: 2 3

This indicates part 2 of 3.

X

X

VA Extended Description

Scheduling > Courses > Course Sections > VA Course Information: Co-Op Count

schd_ms_user.screen_number = 200 and field_number = 140

X

X

Associated SOL Test Code

X

X

Retired

Formerly VA State Course Code

Local Course Code

Scheduling > Courses > Course Sections > Master Schedule: Course field – Course-Section field

(schd_ms.course – schd_ms.course_section)

X

X

Local Course Title

Scheduling > Courses > Course Sections > Master Schedule: Description field (schd_ms.description)

X

X

Semester

Scheduling > Courses > Course Sections > Master Schedule: Marking Period

1 = First Sememster (Quarter 1 and/or Quarter 2

2 = Second Semester (Quarter 3 and/or Quarter 4

3 = Yearlong (Q1, Q2, Q3, and Q4)

4 = Summer School Session

Check the Term in reg_mp_weeks, and if both term 1 and 2 are found, then semester should be set to 3. If only term 1 is found, then semester should be 1. If only term 2 is found, then semester should be 3.

X

X

Minutes Per Course

Calculated field

For a course, look at schd_cfg, schd_ms_session, schd_ms_house, schd_period (for start and end), schd_timetable_hdr, schd_timetable, reg_cal_days, and schd_ms_cycle for dates between reg_mp_dates for the marking periods the course meets.

Total minutes that the course is taught. Product of minutes per period, periods per day and class meeting per week.

Required for CTE courses, but optional for all others.

X

X

Scheduling > Courses > Course Sections > VA Course Information: MOP ID

schd_ms_user.screen_number = 200 and field_number = 160