Sidebar
academy:fall_extract_staff
This is an old revision of the document!
If you will be manually entering the staff responsibility data on the TxEIS State Reporting maintenance pages, skip the following steps.
Import Staff Data (for Student-only Districts)
Districts that do not use TxEIS Business applications can import basic staff demographic data to be used for the TSDS Staff Interchange records (i.e., to join the unique staff ID with a teacher/staff record). The import adds “non-employee” data to HR that will be read by the extract, along with data from TxEIS Grade Reporting. This utility must be run before running the staff extract.
State Reporting > Utilities > Import Staff File
| File | Click Browse to locate and select the file to import. |
|---|
❏ Click Import.
The results of the import are displayed, including a count of records with errors, and total records read, updated, and imported.
| Print Report | Print the error report. |
|---|
Before Extracting Staff Data:
❏ Verify and correct data in the master schedule as described in the Verify Master Schedule Data section of this guide.
❏ Ensure that all inactive employees have a termination date entered (Termination - Date and Reason fields on Human Resources > Maintenance > Staff Job/Pay Data > Employment Info). If the Reason field is blank, the employee is not extracted.
❏ Ensure that all Type 3 (hourly) employees have one of the following:
- A payroll activity code with a budget number and estimated amount (Estimated Annual Salary (Hourly Employees Only fields on Human Resources > Maintenance > Staff Job/Pay Data > Employment Info)
- An annual salary (Human Resources > Maintenance > Staff Job/Pay Data > Job Info)
The fall Staff Extract page will extract data for the StaffAssociationExtension interchange, including staff demographic, payroll accounting, and responsibility data from the master schedule and the Human Resources (HR) application. You can extract subsets of data, multiple times. You can extract from HR only, master schedule only, or both at the same time.
Districts with contracted instructional staff serving as classroom teachers (i.e., PEIMS type 2) will also enter data on TxEIS District Administration > Maintenance > Non-Employee.
NOTE:
When extracting from the master schedule, class ID is set to the course number (four to eight digits) + two-digit section number + one-digit semester number + padding with zeros.
- Class ID is only repeated if more that one instructor is assigned to the same course-section (e.g., assistant or support teacher).
- If Class Type is blank in the district master schedule, the extract will use 01 - Regular.
Monthly minutes are determined as follows:
- If Time Begin and Time End on Grade Reporting > Maintenance > Master Schedule > Campus Schedule > Section contain values, monthly minutes are calculated from the begin and end times, days of week, and weeks of month code.
- If Time Begin and Time End are blank, monthly minutes are set to the value in the Campus/Service ID crosswalk table.
- If Time Begin and Time End are blank and the Campus/Service ID crosswalk table does not exist, the monthly minutes are set to the value in the Campus/Period crosswalk table.
- If Time Begin and Time End are blank and neither the Campus/Service ID crosswalk table nor the Campus/Period crosswalk table exist, an error message is displayed.
- See the Verify Master Schedule Data section of this guide for more information.
If a district has responsibility data in both HR and the master schedule, and the options to extract from both sources are selected, the following occurs:
- Existing staff responsibility records in TSDS are deleted (unless you selected the option to update class counts only).
- Staff responsibility records are extracted from the master schedule.
- Staff responsibility records are extracted from Human Resources. Only new records are added. If a record with the same key already exists in TSDS, the record from HR is not written, an error is displayed the summary report for the Human Resources record.
academy/fall_extract_staff.1533905868.txt.gz · Last modified: 2018/08/10 07:57 (external edit)