Master Schedule Collection File Layout Interdisciplinary Connection Record Section

Record Type

Hard-coded value

"K"

X

X

Serving Division

Administration > General Setup > District > District: State Equivalency Code field (reg_district.state_code_equiv where reg_staff.district = reg_district.district)

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

Serving School

Administration > Registration Setup > Building > Building Definition > Preferences panel: State Equivalency Code field (reg_building.state_code_equiv where reg_staff_bldgs.building = reg_building.building)

Download first finds the appropriate Staff Building record, then converts the Building number to the State Equivalency Code from the Registration Building configuration.

X

X

Section ID

Unique identifier associated with the Master Schedule record ( schd_ms.section_key + ' ' + schd_ms_session.course_session)

Must match a Section ID provided in C Record

Must be unique within the Serving School

Required.

This will be the course with the highest sequence # or the most students if the course is not sequenced.

X

X

Connected Section ID

Unique identifier associated with the Master Schedule record ( schd_ms.section_key + ' ' + schd_ms_session.course_session)

Must match a Section ID provided in C Record

Must be unique within the Serving School

Cannot be the same section number as the Primary Section ID

Required.

Locally defined number that identifies a particular section of a course.

This will be the course with the lowest sequence # or the least students if the course is not sequenced.

X

X

Required. Currently, passed as NULL.

Locally defined course title where two different SCED codes are combined to create one course.