Staff Salary Data Report (TEA)
Use the TX Staff Salary Data Report (TEA) page to add, load, and update staff salary data. You can also generate reports that count the number of employees paid in specific staff positions defined by the Texas Education Agency (TEA).
The Staff Salary Data report provides information for district staff salary by role. Data is compiled from the October snapshot of the statewide data system for public education information in Texas, known as the Public Education Information Management System (PEIMS). Reports include staff in public school districts and charter schools while excluding staff members in private schools.
Menu Path
From the Human Resources menu, select State. From the State menu, select Staff Salary Data Report (TEA).
Selection Rule
The report includes all employees paid in specific staff positions defined by the TEA.
Prerequisites
You must load data before clearing month-to-date accruals.
You must copy live databases for testing and run the 'Special Month-To-Date Restore' option on the test database before running the Load and Report options to create reports for prior months.
Create user-defined tables and codes. For more information, refer to User-Defined Table - Medical Insurance.
Exceptions and Restrictions
Full‐time teachers are loaded regardless of whether there is an amount in the MTD accrual field for the TRS deduction.
Pending employees are excluded.
Load Data
On the TX Staff Salary Data Report (TEA) page, select Load.
Select the Report Month and Report Year.
Select Accept.
Maintain Data
On the TX Staff Salary Data Report (TEA) page, enter Search Criteria and click Search.
To add a record, select Add new. Refer to Field Descriptions, enter valid information in the required fields, and select Accept.
To edit a record, select the record, and select Accept. Update the information and select Accept.
To delete, select the record, and select Delete. Select Yes.
Field Descriptions
Field | Description |
|---|---|
Report Month | The month to report. Once saved, this field cannot be updated. |
Report Year | The year to report. Once saved, this field cannot be updated. |
Employee Number | The unique number identifying the employee. Select Lookup to display the Employee Lookup page and search for a valid employee number. Once saved, this field cannot be updated. |
Social Security Number | The employee's social security number. This field is display-only. |
Last Name | The employee's last name. This field is display-only. |
First Name | The employee's first name. This field is display-only. |
Position | The employee's position. Select:
|
Part-Time Status | The employee's full-time equivalent (FTE) status. Select:
|
Number of Months Worked | The number of months worked for the selected report. |
Contract Start | The date the employee's contract started. The format is MM/DD/YYYY. |
Contract End | The date the employee's contract ends. The format is MM/DD/YYYY. |
Create File
Select Report.
Select Summary or Detail.
Select the Report Month and Report Year.
Select Accept.
Select the Destination for the report:
Select File to save the report in .rpt format.
Select Screen to save the report in .pdf format.
Save the file and navigate to the folder containing the report file.
Inspect the file. Update the data if needed.
Repeat these steps until all the data is included.
Follow the state's submission procedures to file the report.
Purge Data
You can purge the data for the report when:
You want to discard the data for the report completely.
You want to change the setup or employee data and reload the data.
To purge report data:
Select Purge.
Select the Report Month and Report Year.
Select Accept, then Yes.