Skip to content

USPS Reports Guide
USPS Reports by Number

Report 923 TWC Quarterly Report – Wages by County

This report displays TWC gross wages by county for each month in the quarter and is used by agencies to prepare TWC Quarterly Reports. Wages for employees who transfer mid-month with the same position number, but with a new county code will be reported in the county code of the latest assignment. Elected officials (EEO code = E) and judges (job class = JD25) are excluded. Board member per diem and compensatory per diems are excluded from wage totals. All special pays are included except special pays on table 978 are included as per the directions in that table.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Quarterly
Form 111
Sort Sequence County Name
Page Break  
Parameters HNKU3 – QUARTER START DATE, QUARTER END DATE
Databases Used H0H, H0M, HNH, HMP, HNJ, HNK, HNP
Selection Criteria All employees with H0H.GROSS not equal to zero for the selected quarter. Employees must be paid for the period which includes the first of the month to be included in the counts.
Produce Output? Yes
Request Screen Not requestable by agencies. Automatically processed quarterly.
Posting Report? No
Additional Notes

TWC wages are H0H.GROSS minus special pays marked with an "X" or "N" on the HPABR001 line on Table 978. Employees on LWOP who receive no pay for a reporting month are not counted in that month.

Board members who are paid TWC wages have those wages included though the employees are not included in the counts.

Report Headings

FROM/THRU HNK.QTDSTDT/HNK.QTDEDT
Displays the warrant date ranges for the quarter.
USPS COUNTY NAME DERIVED FROM H1TZZ (TABLE 872) AND HNP.PLANTLOC
Displays the county name.
USPS COUNTY CODE HNP.PLANTLOC
Displays the USPS county code number. Employees with data discrepancies are reported in county 0.
FIPS COUNTY CODE DERIVED
Displays the FIPS County Code Number. The FIPS county code is 2 x USPS County code minus 1.
NBR EMP MONTH 1 DERIVED
Displays the count of employees during the first month of the quarter. (Based on H0H pay period start date.)
NBR EMP MONTH 2 DERIVED
Displays the count of employees during the second month of the quarter. (Based on H0H pay period start date.)
NBR EMP MONTH 3 DERIVED
Displays the count of employees during the third month of the quarter. (Based on H0H pay period start date.)
TOTAL NBR EMP DERIVED
Displays the greatest number of individuals in any one period, by county code, during the quarter.
TOT WAGES QUARTER DERIVED FROM H0H.GROSS
Displays the TWC wages paid during the quarter (based on payment date), by county code.
STATEWIDE TOTAL DERIVED
Displays the total number of employees for each month and the total wages for the agency.

Sample Report

  REPORT:   923                                UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE    1
  AGENCY:   XXX                                     XXXXXXXXX XXXXXXXXX XXXXXXXXXX                                RUN DATE  01/16/20XX
                                                TWC QUARTERLY REPORT - WAGES BY COUNTY                            RUN TIME   12:00:0
                                                   FROM 10/01/20XX THRU 12/31/20XX                                      
                                                                                                                        
                        USPS      FIPS                                                                                  
  COUNTY               COUNTY    COUNTY     NBR EMP     NBR EMP     NBR EMP      TOTAL               TOTWAGES           
   NAME                 CODE      CODE      MONTH 1     MONTH 2     MONTH 3     NBR EMP               QUARTER           
  --------------       ------    ------     -------     -------     -------     -------          ---------------        
                                                                                                                        
  BASTROP                 11        21            8           8           7           8                59,518.27        
  BEXAR                   15        29           23          23          23          23               202,831.66        
  BROWN                   25        49            8           7           8           8                52,153.73        
  CORYELL                 50        99           12          12          12          12                78,942.64        
  DALLAS                  57       113            4           4           4           4                30,102.44        
  EL PASO                 71       141            4           4           4           4                31,175.70        
  GALVESTON               84       167           53          52          52          53               371,120.45        
  HARRIS                 101       201           70          70          70          70               646,532.15        
  JEFFERSON              123       245            2           2           2           2                14,158.64        
  LAMAR                  139       277            5           5           5           5                29,812.96        
  PALO PINTO             182       363           10          10          10          10                74,332.14        
  TARRANT                220       439          232         226         224         232             1,681,889.84        
  TRAVIS                 227       453          697         229         242         697             2,129,184.68