USPS Reports Guide –
USPS Reports by Number –
Report 162 Payroll and Deduction Register – Detail
This report displays payment and deduction data (gross to net) for each employee for the current payroll at sub-deduction level. This includes any adjustments or cancellations processed on that payroll.
Current, MTD and YTD totals are provided on a summary page along with the number of transactions processed.
Report Criteria
| Category | Payroll Administration | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Distribution | Agency | |||||||||
| Frequency | Runs with payrolls | |||||||||
| Form | 957 | |||||||||
| Sort Sequence |
|
|||||||||
| Page Break |
|
|||||||||
| Parameters | ||||||||||
| Databases Used | H0B, H0C, H0H, H0M, H0N, H0V, H0W, H0Z, H10, H1T, H7O, HID, HMP, HNH, HNO, HNY, HNZ, HO0 | |||||||||
| Selection Criteria | All employees on the current payroll. | |||||||||
| Produce Output? | Yes | |||||||||
| Request Screen | HSRPT; HPRPT – Set up to run automatically with each payroll. | |||||||||
| Posting Report? | No | |||||||||
| Additional Notes | This report can only run on HSRPT when a final payroll is requested. |
Report Headings
- ORGANIZATION CODE H0H.ORGCODE
- Displays the employee's organization code if the organization code sort is being used.
- PAYROLL FOR WARRANT DATE OF H0H.CHKDATE
- Displays the warrant date of the current payroll.
- DOC NO H0H.ALPHACONS1
- Displays the USAS number assigned to the payroll.
- RUN TYPE H0H.ALPHACONS2
- Displays the type of payroll being processed.
ER Edit Regular ES Edit Supplemental EA Edit Auto Supplemental EN Edit New Hire Supplemental EC Edit Constitutional Per Diem TR Trial Regular TS Trial Supplemental TA Trial Auto Supplemental TN Trial New Hire Supplemental TC Trial Constitutional Per Diem FR Final Regular FS Final Supplemental FA Final Auto Supplemental FN Final New Hire Supplemental FC Final Constitutional Per Diem - ORG CODE H0H.ALPHACONS1
- Displays the employee's organization code.
- EMPLOYEE SSN H0H.EMPLOYEENO/DERIVED
- Displays the employee's SSN.
- CASH GROSS DERIVED
- Displays the total of all cash payments made to the employee including regular, longevity, hazardous duty, BRP, overtime, compensatory time, lump sum vacation or sick and any other miscellaneous special pays. Non-cash pays are excluded.
- NET H0H.NET + H0M.DEDA,T(70)
- Displays the employee's take home pay after all deductions have been taken. A checking direct deposit is considered net pay.
Note: 0.00 will display if the employee has a saving deduction taking 100% of the net pay or when there is no pay being paid (for example, an adjustment).
- MISC SPECIAL PAYS H0H.SPECPAY, H11TZZ (TABLE 983)
- Displays the special pay's three character abbreviation and the amount that was paid. This will include any special pays not separately detailed on this report.
- W/H H0H.FITTAX
- Displays the federal income tax that was deducted.
- DEFCOMP H0M.DEDAMT(54)
- Displays the 457 compensation that was deducted.
- PAYMENT NO H0H.CHECKNO
- Displays the warrant or direct deposit advice number.
- NAME HID.RPTNAME
- Displays the employee's name.
- LV H0H.LEVELIND
- Displays whether or not the employee is leveling benefit replacement pay.
Y Leveled N Not leveled W Not eligible for BRP - ES H0B.EMPSTATUS
- Displays the employment status for this employee.
- HAZ H0M.SPECPAY(05)
- Displays the hazardous duty that was paid.
- ST PHC H0M.DEDAMT(23)
- Displays the payroll health insurance contribution paid by the agency.
- OASDI H0H.OASDITAX
- Displays the OASDI tax that was deducted.
- TXSVER H0M.DEDAMT(53)
- Displays the 401(k) that was deducted.
- PAY PERIOD H0H.BEGINDATE, H0H.PERIODEND
- Displays the beginning and ending dates of the transaction being paid or posted.
- POSITION HNH.POSITION
- Displays the employee's position number for this payment.
- TB/GR/ST HNH.AGYCOMMENT*302/HHNH.POSPAYGRP/HNH.ACTUALSTEP
- Displays the pay table and group associated with the employee's job class code. Displays the employee's pay step, if applicable.
- LGV H0M.SPECPAY(06)
- Displays the longevity that was paid.
- NONCASH DERIVED H0M.SPECPAY
- Displays the non-cash compensation (excluding imputed income) that was added to the employee's taxable wages.
- MED H0H.HITAX
- Displays the HI/Medicare tax that was deducted.
- STPD INS H0M.DEDAMT(26, 43)
- Displays the state-paid health insurance and the state-paid health savings account for the employee.
- MISC DEDUCTIONS H0M.DEDAMT, H1TZZ (TABLE 885)
- Displays the deduction's three character abbreviation and amount that was deducted. This will include any deduction not separately detailed on this report. Those that may have multiple occurrences will have a counter added to the abbreviation. For example: child support (CS1, CS2), savings bond (BD1, BD2), tuition (TU1, TU2).
- HRS/RTE DERIVED H0H/HOH.PAIDRATE
- Displays the hours paid along with the rate of pay, if either are applicable.
- SC HNH.SCHCARD
- Displays the employee's job schedule card, if applicable.
- AMOUNT DERIVED H0H
- Displays the amount of regular, overtime, compensatory, lump sum vacation, or lump sum sick that was paid.
- D DERIVED
- Displays the type of pay being paid in the AMOUNT field.
R Regular O Overtime C Compensatory Time V Vacation Lump Sum S Sick Lump Sum - BRP H0M.SPECPAY(96)
- Displays the benefit replacement pay that was paid.
- IMPUT H0M.SPECPAY(10)
- Displays the imputed income calculated for the employee.
- RETIR H0M.DEDAMT(5-10)
- Displays the retirement contribution that was deducted.
- ST RET H0M.DEDAMT(25)
- Displays the state paid retirement for the employee.
- AGENCY TOTALS DERIVED
- Displays the current, month, and year totals for all pay types, hours, taxes, and deductions. Edit and Trial payroll run types will only produce current totals. Agency Payables (deduction 48) will be summarized and displayed at sub-deduction level.
- TRANSACTION COUNT DERIVED
- Displays the number of transactions processed on this payroll.
Sample Report
REPORT: 162 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL FOR WARRANT DATE OF 11/04/20XX RUN TIME: 10:10:59
PAYROLL AND DEDUCTION REGISTER-DETAIL
DOC NO: XXXXXXXX RUN TYPE: FS
------------------------------------------------------------------------------------------------------------------------------------
ORG CODE EMPLOYEE SSN CASH GROSS NET MISC W/H DEFCOMP
PAYMENT NO NAME L E HAZ ST PHC SPECIAL OASDI TXSVER
PAY PERIOD POSITION TB/GR/ST V S LGV NONCASH PAYS MED STPD INS M I S C D E D U C T I O N S
HRS/RTE SC AMOUNT D BRP IMPUT RETIR ST RET
-----------------------------------------------------------------------------------------------------------------------------------
00002000100 XXX-XX-XXXX 3,666.66 2,241.69 353.24 0.00 STF 3.00 TAD .80 TDN 22.46
XXXXXXXXXXX XXXXX, XXXX 0.00 36.67 126.18 0.00 THI 425.78 TOL 9.24 FDD 200.00
10/01-31/20XX XXXXXX 1B/20/ W 1 0.00 0.00 43.56 832.63 FDF 4.00 DEP 1.38
168:00 21.82535 3,666.66 R 0.00 0.00 238.33 254.83
REPORT: 162 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 2
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
PAYROLL FOR WARRANT DATE OF 11/04/20XX RUN TIME: 10:10:59
PAYROLL AND DEDUCTION REGISTER-SUMMARY
CASH GROSS REGULAR PAY REGULAR HOURS OVERTIME PAY OVERTIME HR WITHHOLDING OASDI TAX MED TAX
CUR 3666.66 3666.66 168.00 0.00 0.00 353.24 126.18 43.56
MTD 771728.38 758120.58 27984.00 0.00 0.00 110410.29 29070.16 10917.13
YTD 1605370.27 1576132.94 66871.00 63.61 2.10 188909.41 62764.39 22549.66
NET PAY TOTAL DEDUCT EIC 06 LONGEVTY 10 IMPUTED 96 BRP 05 ERS RET 23 STPAYPHC
CUR 2241.69 901.99 0.00 0.00 0.00 0.00 238.33 36.67
MTD 544669.42 76661.38 0.00 13180.00 1148.78 427.80 44822.71 4532.43
YTD 1144978.05 186168.76 0.00 27120.00 2921.63 1026.86 92082.72 4532.43
24 STRETFEE 25 STRETIRE 26 STHEALTH 28 STOPTOUT 30 ADD FLEX 31 DENTFLEX 32 HLTHFLEX 33 OPTLFLEX
CUR 3.00 254.83 832.63 0.00 0.80 22.46 425.78 9.24
MTD 15.00 47925.67 59458.34 177.51 294.30 3759.69 10212.54 1763.11
YTD 30.00 99972.09 117675.40 177.51 762.70 9692.29 27390.26 4481.58
36 FSA HLTH 37 FSA DAY 39 FSA DFEE 44 DISSHORT 45 DISLONG 46 DEP LIFE 50 MEM DUES 52 401KLOAN
CUR 0.00 200.00 4.00 0.00 0.00 1.38 0.00 0.00
MTD 3535.00 400.00 8.00 677.23 1389.23 59.34 30.00 2252.00
YTD 10409.00 400.00 8.00 1793.34 3544.04 142.14 30.00 4475.16
53 401K 54 457 69 SAVINGS 70 CHECKING NET WARRANT
CUR 0.00 0.00 0.00 0.00 2241.69
MTD 7008.23 450.00 0.00
YTD 14705.96 4845.00 11406.57
TRANSACTION COUNT 1