Master Schedule Collection File Layout Teacher Section

Record Type

Hard-coded value

"D"

X

X

Section ID

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

Required unless Teacher Role Code = 8

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

Teacher/ Administrator License Prefix

Scheduling > Courses > Course Sections > Master Schedule > Staff Info link: Staff field (schd_ms_staff_date.staff_id).

Converted to Staff State ID on Administration > Registration Setup > Building > Staff

(reg_staff.staff_state_id where schd_ms_staff_date.staff_id = reg_staff.staff_id)

This field reports the characters preceding the hyphen in the Staff State ID. For instance, if the ID is XXX-9999999, this field would report XXX.

If the record lacks a valid Staff State ID, then the staff member requires a Section E record, Provider.

X

X

Teacher/ Administrator License Number

Scheduling > Courses > Course Sections > Master Schedule > Staff Info link: Staff field (schd_ms_staff_date.staff_id).

Converted to Staff State ID on Administration > Registration Setup > Building > Staff

(reg_staff.staff_state_id where schd_ms_staff_date.staff_id = reg_staff.staff_id)

This field reports the characters following the hyphen in the Staff State ID. For instance, if the ID is XXX-9999999, this field would report 9999999.

If the record lacks a valid Staff State ID, then the staff member requires a Section E record, Provider.

X

X

Local Provider ID

Scheduling > Courses > Course Sections > Master Schedule: Primary Staff field or Secondary Staff field (schd_ms_staff.staff_id)

A separate record is created for the Primary Staff and each Secondary Staff associated with the course.

X

X

Teacher Role Code

Scheduling > Courses > Course Sections > Master Schedule > Staff Info link: Role field (schd_ms_staff_user.field_value where schd_ms_staff_user.field_number = 1).

Converted to statetb_staff_role.state_code_equiv where schd_ms_staff_user.field_number = 1 and schd_ms_staff_user.field_value = statetb_staff_role.code

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

X

X

Defined Class Type

Scheduling > Courses > Course Sections > Master Schedule > Staff Info link: Defined Class Types field (schd_ms_staff_user.field_value where schd_ms_staff_user.field_number = 2).

Converted to statetb_def_class.state_code_equiv where schd_ms_staff_user.field_number = 2 and schd_ms_staff_user.field_value = statetb_def_class.code

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

X

X

Retired

Formerly Highly Qualified Code

Retired

Formerly Flexibility Criteria Flag