The default file names for the Teacher Service History report are:
-
Excel: historyrpt<####_#####>.xlsx
-
PDF: history_<#####>.pdf
-
RPT: history.rpt
The following table shows the columns, column names, descriptions, and data sources or valid values for the Teacher Service History report’s .xlsx file format.
|
Column |
Column Name |
Description |
Data Source or Valid Values |
|---|---|---|---|
|
A |
STATE STAFF ID
|
The employee’s unique TSDS identification. |
Retrieved from the State Staff ID field on the TX Teacher Service Records (TEA) page (Employee Information section). |
|
B |
NAME
|
The employee's name. The format is last name, first name middle name. |
Retrieved from the Last Name, First Name, and Middle Name fields on the TX Teacher Service Records (TEA) page (Employee Information section). |
|
C |
PUBLIC/PRIVATE |
Indicates whether the employee works at a public or private school. |
Retrieved from the Private School field on the TX Teacher Service Records (TEA) - Reports page. |
|
D |
YEAR
|
The school year for this service record. The format is YY-YY. |
Retrieved from the Year field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
E |
YEARS EXPERIENCE
|
The total years of teaching/professional experience in Texas public schools. |
Retrieved from the Years Experience field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
F |
RECORD NUMBER
|
The sequential number for multiple service records within the same year. |
Retrieved from the Record Number field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
G |
% OF DAY EMPLOYEE |
The Full-Time Equivalent (FTE) expressed as a percentage. |
Retrieved from the FTE field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
H |
POST HELD
|
The employee’s job classification or title (e.g., "TEACH", "COUNS", "LIBRAR"), showing their role during this service period. |
Retrieved from the Position Held field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
I |
FULL SEMESTER
|
Indicates whether contracts of less than 90 days should count as a full semester. |
Retrieved from the Full semester field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
J |
NUMBER DAYS EMPLOYED
|
The total number of contract days for this service period (e.g., 187 days). |
Retrieved from the Days Worked field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
K |
FROM DATE OF SERVICE
|
The contract start date for this service period (e.g., 08/15/2024), or the first day of the employment contract. |
Retrieved from the From Date field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
L |
TO DATE OF SERVICE
|
The contract end date for this service period (e.g., 05/30/2025), or the last day of the employment contract. |
Retrieved from the To Date field on the TX Teacher Service Records (TEA) page (Service Information section). |
|
M |
STATE SICK LEAVE PRIOR YEAR BALANCE
|
The ending leave balance carried forward from the previous school year for sick leave. |
Retrieved from the Prior Year field in the Sick Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
N |
STATE SICK LEAVE YEAR EARN
|
The school year when the leave was earned, for sick leave, displayed in YY-YY format (e.g., "23-24" for the 2023-2024 school year). |
Retrieved from the Year Earned field in the Sick Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
O |
STATE SICK LEAVE DAYS EARN
|
The number of leave days accrued/earned during this school year for sick leave. |
Retrieved from the Days Earned field in the Sick Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
P |
STATE SICK LEAVE DAYS USED
|
The number of leave days taken/used by the employee during this school year for sick leave. |
Retrieved from the Days Used field in the Sick Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
Q |
STATE SICK LEAVE END YEAR BALANCE
|
The ending sick leave balance for this school year. |
Retrieved from the Days End field in the Sick Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
R |
STATE PERSONAL LEAVE PRIOR YEAR BALANCE
|
The ending leave balance carried forward from the previous school year for personal leave. |
Retrieved from the Prior Year field in the Personal Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
S |
STATE PERSONAL LEAVE YEAR EARN
|
The school year when the personal leave was earned, displayed in YY-YY format (e.g., "23-24" for the 2023-2024 school year). |
Retrieved from the Year Earned field in the Personal Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
T |
STATE PERSONAL LEAVE DAYS EARN
|
The number of leave days accrued/earned during this school year for personal leave. |
Retrieved from the Days Earned field in the Personal Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
U |
STATE PERSONAL LEAVE DAYS USED
|
The number of leave days taken/used by the employee during this school year for personal leave. |
Retrieved from the Days Used field in the Personal Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |
|
V |
STATE PERSONAL LEAVE END YEAR BALANCE
|
The ending leave balance for this school year, for personal leave. |
Retrieved from the Days End field in the Personal Leave section on the TX Teacher Service Records (TEA) page (Leave Balances section). |