Skip to content

USPS Reports Guide
USPS Reports by Number

Report 921 TWC Quarterly Report – Wages by Employee

This report displays total wages paid for each employee and the number of employees paid by the agency and is used by the agency to prepare TWC reports. USPS sends a magnetic tape to TWC with the detailed employee information. Elected officials (EEO code = E) and judges (job class = JD25) are excluded. Board member per diem and compensatory per diems are excluded. All special pays are included except special pays on table 978 are included as per the directions in that table. Employees with negative quarterly wages are not included on the report.

Report Criteria

Category Payroll Administration
Distribution Agency, TWC
Frequency Quarterly
Form 111
Sort Sequence Employee Name, Employee SSN
Page Break  
Parameters HNKU3 – QUARTER START DATE, QUARTER END DATE
Databases Used H0C, HNK, H0H, HNP, HID, H0M
Selection Criteria All employees paid during the selected quarter.
Produce Output? Yes
Request Screen Not requestable by agencies. Automatically processed quarterly.
Posting Report? No
Additional Notes

Do not submit this report to TWC. Only Box 13 on the TWC form needs to be completed.

TWC wages are H0H.GROSS minus special pays marked with an X or N on the HPABR921 line on table 978. Agencies should submit TWC Form C-7 to adjust values submitted on the tape.

Board members who are paid TWC wages have those wages included.

Report Headings

FROM/THRU HNK.QTDSTDT/HNK.QTDEDT
Displays the warrant date ranges for the quarter.
ACCOUNT NUMBER H08.STATEID
Displays the TWC account number.
EMPLOYEE SSN H0H.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
TWC WAGES PAID DERIVED FROM H1TZZ (TABLE 978) AND H0H.GROSS
Displays the total amount of the employee's TWC wages.
RSN HMH.HRISREASCD
Displays the reason code of the last personnel action which occurred in the reporting period.
EFFECTIVE DATE HNH.HISTORYDT
Displays the effective date of the last personnel action.
SPECIAL MESSAGE DECODE TABLE 887
Displays a detailed message if an HRIS action occurred during the requested time frame. For example: new hire, terminated, on leave without pay, merit increase, etc. The last reason code is displayed.
NUMBER OF EMPLOYEES DERIVED
Displays the number of employees reported.
TOTAL GROSS WAGES DERIVED
Displays the sum of all employees' wages reported to TWC.

Sample Report

   REPORT:   921                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:    21    
   AGENCY:   XXX                                   XXXXXXXX XXXXXXXXX XXXXXXXXXX                                RUN DATE: XX/XX/20XX
                                              TWC QUARTERLY REPORT - WAGES BY EMPLOYEE                          RUN TIME: 08:09:52 
                                                  FROM 10/01/20XX THRU 12/31/20XX                                                  
   ACCOUNT NUMBER: 9999999999                                                                                                      
                                                                                                                                   
      EMPLOYEE SSN    EMPLOYEE NAME                 TWC WAGES PAID     RSN    EFF DATE    SPECIAL MESSAGE                          
      ------------    -------------------------     --------------     ---   ----------   -----------------------------------------
                                                                                                                                   
      XXX-XX-XXXX     XXXXXX, XXXXXX XXXXXXX              7,263.00     038   09/01/20XX   EMPLOYEE DESCRIPTIVE DATA - ALL EMPLOYEES
      XXX-XX-XXXX     XXXX, XXXXXX X                     14,952.00                                                                 
      XXX-XX-XXXX     XXXXXXX, XXXXXX X                       0.00                                                                 
      XXX-XX-XXXX     XXXXXXXXX, XXXXXXXX                 1,392.88     067   10/07/20XX   DISMISSAL FOR CAUSE                      
      XXX-XX-XXXX     XXXXXXXXXX, XXXXXXX                 7,350.00                                                                 
      XXX-XX-XXXX     XXXXXXX, XXXXXXX                        0.00                                                                 
      XXX-XX-XXXX     XXXXX,XXXXXX                            0.00                                                                 
      XXX-XX-XXXX     XXXXX,XXXXXXX                       4,300.00     010   10/01/20XX   NEWLY HIRED OR REHIRED EMPLOYEE          
      XXX-XX-XXXX     XXXXXXXX, XXXXX                         0.00                                                                 
      XXX-XX-XXXX     XXXXXXX, XXXXX                          0.00                                                                 
      XXX-XX-XXXX     XXXXXX, XXXXXXXX                      675.36                                                                 
      XXX-XX-XXXX     XXXXXX, XXXXXXXXXX                  6,592.85                                                                 
      XXX-XX-XXXX     XXXX,XXXXXXXX                           0.00                                                                 
      XXX-XX-XXXX     XXXX, XXXXXXXXX                         0.00                                                                 
      XXX-XX-XXXX     XXXXXXXX, XXXXXXXXX                     0.00