Skip to content

Military Workforce Summary Reports and Military Complaint Reporting

FPP F.038

SPRS Military 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
S Spouse of an active-duty member
H Disabled veteran’s spouse who is primary source of income
U Unknown
N Not eligible

HRIS/SPRS Indicator Field

Values Value Description
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 who were employed during the report period are reflected in the workforce figures.
  3. The military 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 L015, 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, O, S or H on the detail report will be counted only once in the military preference figure on the summary report. Employees with W, O, S or H are not counted in the total military 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 in the other military figure and will be counted once in the total military figure on the summary report.
  8. Employees with a veteran indicator value of Y, but who do not qualify for military 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, will be counted only once in the other military figure and will be counted once in the total military figure on the summary report.
  9. Employees with a veteran indicator value of N and a veteran preference indicator value of V, W, O, S or H on the detail report will be counted only once in the military preference figure on the summary report.
  10. 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 military or military preference figures on the summary report.
  11. 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 a military survey form to the agency.
  12. 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 military or military preference figures on the summary report.
  13. 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, S, H, 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.
  14. The most current veteran indicator or veteran preference indicator value reported in the report period will be used to determine an employee's military status in the workforce detail and summary reports.
  15. Employee records will reflect an S in the HRIS/SPRS INDICATOR field, denoting which system the data was extracted from.
  16. The total military figure counts all employees with either a Y or a V. Employees with W, O, S or H are not counted in the total military figure.
  17. The total military 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, contact the SPRS and CAPPS authorized support staff help desk at (512) 463-2277 or capps.help@cpa.texas.gov.

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 X(1)

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