State Reporting > Extracts > Summer

Summer Extract with ECDS PK options selected

CAUTION! Each time you extract data, you overwrite the data in the frozen files (i.e., State Reporting maintenance pages), including any data that was manually entered.


Ending School Year

(Display only) The submission year as entered in the Submission Year field on State Reporting > Options is displayed.

For the 2018-2019 ECDS PK submission, the field should display 2019.


❏ For the ECDS PK submission, select the following:

❏ Attendance

Select to extract attendance data.

Semester to Extract

For the ECDS PK submission, the field should be set to All.

❏ Course Extracts

NOTE: You can select to run the Classroom Link and Course Completions extracts individually; however, the program expects the Classroom Link extract to be run first. If you select to extract Course Completion data but do not select to extract Classroom Link data, the program verifies that Classroom Link records exist for the current school year. If they do not exist, a message is displayed and no data is extracted.

NOTE: A student's course entry date cannot be the same as the semester end date.

❏ Classroom Link

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 the end date is blank, the latest semester end date for the campus is used. If there are multiple tracks, the end date for the track that ends on the latest date is used. The date will be adjusted as needed when the course completion extract is run. Example: At campus 001, track 1 ends on 5/29/20, and track 4 ends on 6/5/20. The end date for all records will be 6/5/20.



• 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.

If the names match and the staff demographic data is being extracted from HR, the record in ASCENDER State Reporting is updated.

If the names do not match, a warning message is listed on the error report.

❏ Flexible Attendance

Select to extract the following data: InterchangeStudentExtension and InterchangeStudentAttendanceExtension.



Email field on the extract page

Email

(Optional) Type your email address if you wish to receive email notification when the extract is complete.


❏ Click Run.

A message is displayed indicating that the extract is in progress.

Extract in progress message