The extract does the following:

• All existing course-section and teacher class assignment records are deleted. Staff demographic records are not deleted in order to accommodate districts that manually update staff demographic data or merge staff demographic data from a TEA file.

• Course-section data is selected for all course-sections in the master schedule that have student enrollment, and a record is created for each course-section.

• Teacher class assignment records are created if the non campus-based instruction code for the course-section is 00 or blank. If a course-section has multiple teachers (multiple meeting times), a record is created for each teacher.

• The begin and end dates on the teacher class assignment record captures the classroom assignments for classroom teachers records are extracted from the meeting time records for each course-section in Grade Reporting.

• If a district is using the Business system, staff demographic data is extracted from HR. The staff type code is set to 1 (school district employee) for all instructors extracted from HR. If an instructor is on the master schedule but not in HR, a partial staff demographic record is created (staff ID and name only), and the staff type code is set to 3 (contracted professional staff).

• If a district is not using the Business system, partial staff demographic records (staff ID and name only) are created for all instructors in the master schedule with staff type code 1 (school district employee).

• If a duplicate record is found when attempting to add a staff demographic record, the first and last names on the two records with the same staff ID are compared.