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