Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 021 Employees Within Deduction

This report displays employees and their current payroll deductions sorted by deduction type.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with payroll.
Form 111
Sort Sequence
Options H0XCR Break H0XCR Sort
Last Name, First Name, Middle Name 0000 403
11-digit Organization code, Employee Social Security Number 5555 401
Organization Code, Last Name, First Name, Middle Name 5555 402
Employee SSN 0000 400

 
Page Break Deduction Number and Document Number with:
0000–400 5555–401
0000–403 5555–402
Parameters  
Databases Used H0B, H0C, H0H, HID, H0V, H0Z, H0M, HNP
Selection Criteria All employees with deductions taken on the current payroll.
Produce Output? Yes
Request Screen HPRPT – Set up to run automatically with each payroll.
Posting Report? No
Additional Notes

Whether a deduction is included on the report is determined by the H0VCD SR flag for the deduction number. A 1 will display the deduction.

** EDIT/REPORT RUN ** will display in the top left corner of the report if the report was produced from a trial/edit payroll. This report will generate twice only when a final payroll is rejected. Use the latest RUN TIME/DATE, which is found in the top right corner of the report.

If an agency wants a different sort option, it can be requested by an LOA identifying which break/sort option is desired.

Report Headings

ORG HNP.ORGCODE
Displays the 11-digit organization code for the employee. This field only displays for sort option 2 and 3.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
SOC SEC NUMBER H0Z.EMPLOYEENO
Displays the employee's SSN.
EMP STAT H0B
This field displays the employee's status as of the last day of the pay period that is being processed. Status, Term, LWOP Blank means the employee is active.
DED FREQ H0Z
Displays the employee's deduction frequency as of the last day of the pay period processing.
DEDUCTION CURR H0M.DEDAMT
Displays the amount withheld for this deduction for the current payroll run.
DEDUCTION MTD H0Z.DEDMTD
Displays the amount withheld for this deduction for the current month.
DEDUCTION YTD H0Z.DEDYTD
Displays the amount withheld for this deduction for the current year.
GOAL AMT/DTE H0Z.DEDGOAL, H0Z.DEDENDDT
Displays the goal amount, if applicable, or the date the deduction is set to stop.
UTILITY H0Z.DEDUTIL
Displays the processing and taxing codes for the deduction.

Sample Report

  REPORT:   21                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1  
AGENCY: XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXXX                                 RUN DATE: XX/XX/20XX
                                             EMPLOYEES WITHIN DEDUCTION  5 - ERS RET                         RUN TIME: 20:45:00
* EDIT/REPORT RUN **                        DOCUMENT 84083005 - PAYMENT DT 09/01/20XX  
                                         
                              SOC SEC      EMP     DED      DEDUCTION     DEDUCTION     DEDUCTION           GOAL                
EMPLOYEE NAME                 NUMBER       STAT    FREQ       CURR         M T D          Y T D          AMT/DTE      UTILITY   
                                                                                                                                
XXXXXXX, XXXXXXX             XXX-XX-XXXX             09        175.50           .00      1,404.00            .00      3122200   
XXXXX, XXXXXXXXX             XXX-XX-XXXX             09        254.70           .00      2,067.11            .00      3122200   
XXXXXXX, XXXXXXXXX           XXX-XX-XXXX             09        174.72           .00      1,341.36            .00      3122200   
XXXXXXXXX, XXXX              XXX-XX-XXXX             09        132.54           .00      1,047.18            .00      3122200   
XXXXXXX, XXXXXXXXXXX         XXX-XX-XXXX             09        227.50           .00      1,820.00            .00      3122200   
XXXXXXXXX, XXXXXXXX          XXX-XX-XXXX             09        350.40           .00      2,797.61            .00      3122200   
XXXXXX, XXXXXXXXXX           XXX-XX-XXXX             09        302.64           .00      2,482.74            .00      3122200   
XXXXXXXX, XXXXXXXXX          XXX-XX-XXXX             09        291.90           .00      2,396.81            .00      3122200   
XXXXXXXX, XXXXXXXXXXX        XXX-XX-XXXX             09        295.68           .00      2,365.44            .00      3122200   
XXXXXXXX, XXXXXXXX           XXX-XX-XXXX             09        241.50           .00      1,986.40            .00      3122200   
XXXX, XXXXXXXXX              XXX-XX-XXXX   TERM      09           .00           .00      1,150.49            .00      3122200   
XXXXXX, XXXXXXX              XXX-XX-XXXX             09        274.26           .00      2,255.68            .00      3122200   
XXXX, XXXXXXXXXX             XXX-XX-XXXX             09        358.92           .00      2,932.97            .00      3122200   
XXXXXXX, XXXXXXXXX           XXX-XX-XXXX             09        280.20           .00      2,294.81            .00      3122200   
XXXXXX, XXXXXXXXX            XXX-XX-XXXX   TERM      09           .00           .00        324.03            .00      3122200   
XXXXXX, XXXXX X              XXX-XX-XXXX             09        148.68           .00        799.20            .00      3122200   
XXXXXX, XXXXXXXX             XXX-XX-XXXX             09        300.00           .00      2,363.10            .00      3122200 
XXXXX, XXXXXXX               XXX-XX-XXXX             09        670.00           .00      5,360.00            .00      0000000  
XXXXXX, XXXXXX               XXX-XX-XXXX   TERM      09           .00           .00      4,811.27            .00      0000000  
XXXXX, XXXXXXXX              XXX-XX-XXXX             09        120.00           .00        960.00            .00      0000000  
XXXXXXX, XXXXXXX             XXX-XX-XXXX             00           .00           .00      1,501.77            .00      0000000  
XXXXXX, XXXXXXX              XXX-XX-XXXX             09        386.09           .00      3,297.82            .00      0000000  
XXXXXX, XXXXXX X             XXX-XX-XXXX             09        698.00           .00      5,584.00            .00      0000000  
XXXXXXXX, XXXXXXX, XXX       XXX-XX-XXXX             09        738.38        422.00-     5,183.66            .00      0000000  
XXXXXXXX, XXXXXXXX           XXX-XX-XXXX             09        630.00           .00      5,040.00            .00      0000000  
                                  DEDUCTION  05  TOTAL      28,281.49        422.00-   235,566.15