FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

Veteran Workforce Summary Reports and Veteran Complaint Reporting

FPP F.038

SPRS Veteran Workforce Summary Report Criteria

This quarterly report is available with your daily downloads.

VETERAN INDICATOR Field

Values Value Descriptions
Y Yes: A Veteran
N No: Not a Veteran
U Unknown

VETERAN PREFERENCE INDICATOR Field

Values Value Descriptions
V Veteran Preference
W A Surviving Spouse
O Orphan of a Veteran
U Unknown
N Not Eligible

HRIS/SPRS/USPS INDICATOR Field

Values Value Descriptions
S Data extracted from Standardized Payroll/Personnel Reporting System

Report Criteria

  1. All employees hired during the report period are reflected in the New Hire figures.
  2. All employees that were employed during the report period are reflected in the Workforce figures.
  3. The Veteran status reflected in the New Hire section is determined by the Veteran Indicator and Veteran Preference Indicator values reported for the hire date.
  4. Reason Codes 010, 012 and LEG are used to determine New Hire status.
  5. All employees, excluding employees in job classification codes EXCS, BD25, JD25, CP25, SAD1 and PD25 are reflected in the report.
  6. Employees with a Veteran Indicator value of Y and a Veteran Preference Indicator value of V, W or O on the Detail Report will be counted only once within the Veteran Preference figure on the Summary Report. Employees with W or O are not counted in the Total Veteran figure on the summary Report.
  7. Employees with a Veteran Indicator value of Y and a Veteran Preference Indicator value of U on the Detail Report will be counted only once within the Other Veteran figure and will be counted once in the Total Veterans figure on the Summary Report.
  8. Employees with a Veteran Indicator value of Y, but who do not qualify for Veteran Preference, should be reported to SPRS with a Veteran Preference Indicator value of N. These employees will be counted only once in the Detail Report, and will be counted only once within the Other Veteran figure and will be counted once in the Total Veterans figure on the Summary Report.
  9. Employees with a Veteran Indicator value of N and a Veteran Preference Indicator value of V, W or O on the Detail Report will be counted only once within the Veteran Preference figure on the Summary Report.
  10. Employees with W or O are not counted in the Total Veteran figure.
  11. Employees with a Veteran Indicator value of U must be reported to SPRS with a Veteran Preference Indicator value of U. These employees will not be included in the Other Veteran or Veteran Preference figures on the Summary Report.
  12. A Veteran Indicator value of U, and a Veteran Preference Indicator of U must be reported on an employee's record when the employee does not return the veteran survey form to the agency.
  13. Employees with a Veteran Indicator value of N or U and a Veteran Preference Indicator value of N or U on the Detail Report will not be included in the Other Veteran or Veteran Preference figures on the Summary Report.
  14. A newly hired employee reported with a Veteran Indicator value of Y, N or U or a Veteran Preference Indicator value of V, W, O, U or N at the time of hire will be listed on the Summary Report in the New Hire section and counted accordingly. A change to the Veteran Indicator or Veteran Preference Indicator values after the hire date but during the report period will be reflected only on the Summary Report in the Total Employee section of the Workforce Detail Report and counted accordingly.
  15. The most current Veteran Indicator or Veteran Preference Indicator value reported within the report period will be used to determine an employee's veteran status in the Workforce Detail and Summary Reports.
  16. Employee records will reflect an S in the HRIS/SPRS/USPS Indicator field, denoting from which system the data was extracted.
  17. The Total Veterans figure counts all employees with either a Y or a V. Employees with W or O are not counted in the Total Veteran figure.
  18. The Total Veterans column is the percentage of all agency employees who are veterans.

The file format for the Extract File is shown below. If you need help reporting data corrections or to request the Extract File via electronic file transfer, please contact your SPRS representative or call the Help Desk at (512) 463-4008.

Extract File Information

Record Length: 40  
Block Size: 24000  
Recording Format: FB  
     
Layout: Agency Number X(3)
  Social Security Number X(9)
  Name X(25)
  Vet Flag X(1)
  Vet Preference X(1)
  HRIS/SPRS/USPS Flag X(1)

This is a raw data file that allows agencies to write their own reconciliation programs and create custom reports.

Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy