State Reporting

User Tools

Site Tools

Trace: • fall_extracts • fall_extract_staff • fall_import • ecds_pk_extract

Sidebar

Table of Contents

academy:ecds_pk_extract
Book Creator
 Add this page to your book
Book Creator
 Remove this page from your book  

 Manage book(0 page(s))
 Help

This is an old revision of the document!


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.


Select the following for the ECDS PK submission:

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

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


❏ Click Run.

  • You can either wait for an email notification that the extract is complete, or view the status of the extract on Extracts > Extracts Status.
  • If errors are encountered, the Error button is displayed. Click Errors to view the list of errors.
academy/ecds_pk_extract.1556287577.txt.gz · Last modified: 2019/04/26 09:06 (external edit)

Page Tools

Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International

Americans with Disabilities Act (ADA) and Web Accessibility

The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.