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