Skip to content

USPS Reports Guide
USPS Reports by Number

Report 094 Subdeduction Detail

This report prints for each subdeduction vendor paid during the defined pay period. Child support deductions are only included on this report when processed to a state disbursement unit by using the single direct deposit (SDD) method with electronic addenda information. All other child support deductions will be listed on Report 129.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with final payrolls; Upon Request.
Form 111
Sort Sequence
Options H0XCR Sort
Deduction Number, Vendor ID Number, Employee Name 994
Page Break Vendor ID Number
Parameters HSRPQ – WARRANT DATES
Databases Used H0H, H0C, H0V, H0B, H0M, HNZ, HID, HNP
Selection Criteria All employees on payroll with a subdeduction, excluding child support.
Produce Output? Yes
Request Screen HSRPQ; HPRPT – Set up to run automatically with each final payroll.
Posting Report? No
Additional Notes  

Report Headings

VENDOR NAME/NUMBER/ADDRESS
Displays the vendor name, identification number, and address.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
SSN H0H.EMPLOYEENO
Displays the employee's SSN.
ORG CODE H0H.ORGCODE
Displays the employee's organization code.
DOCUMENT H0H.ALPHACONS1
Displays the USAS document number assigned to the payroll.
PAYMENT DATE H0H.CHKDATE
Displays the date the funds will be made available to the vendor.
SCHEDULED DEDUCTION HNZ.DEDNTAKEN + HNZ.CURRDEDAMT
Displays the employee's scheduled deduction, which is the CURRENT DEDUCTION plus any DEDUCTIONS NOT TAKEN amounts.
CURRENT DEDUCTION HNZ.CURRDEDAMT
Displays the employee's current deduction for the particular vendor.
DEDUCTION NOT TAKEN HNZ.DEDNTAKEN
Displays the employee's deduction not taken.
VENDOR TOTAL DERIVED
Displays the vendor totals for CURRENT DEDUCTION, DEDUCTIONS NOT TAKEN, and SCHEDULED DEDUCTION.
AGENCY TOTAL DERIVED
Displays the totals for CURRENT DEDUCTION, DEDUCTIONS NOT TAKEN, and SCHEDULED DEDUCTION.

Sample Report

 
 REPORT:    94                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1     
 AGENCY:   XXX                                       XXXXXXXXXXXXXXXXXXXXXX                                   RUN DATE: XX/XX/20XX
                                                  SUB DEDUCTION DETAIL REPORT                                 RUN TIME: 15:13:35  
                                                    DEDUCTION 014 - CHLD SUP                                                      
         XXXXXXXXXXXXXXXXXXXXXXXXXXXX / XXXXXXXXX001                                                                            
         XXXXXXXXXXX XXXXXXXXXXXXXXX                                                                                            
         PO BOX XXXXXXXXXXXX 
         AUSTIN, TX XXXXX-XXXX                                                                                                  
                                                                                                                                    
                                                                                                                                    
                                                                         PAYMENT          SCHEDULED       CURRENT         DEDUCTION 
EMPLOYEE  NAME                       SSN          ORG CODE     DOCUMENT  DATE             DEDUCTION       DEDUCTION       NOT TAKEN 
                                                                                                                                    
XXXXXXXX, XXXXXXXXX X                XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX           50.00           50.00             .00 
XXXXXXXXX, XXXXXXX                   XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX           10.00           10.00             .00 
XXXXXXXXX, XXXXXXX                   XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX          225.00          204.27           20.73 
XXXXXX, XXX                          XXX-XX-XXXX  00567800000  88114FR2  12/01/20XX           20.00           20.00             .00 
XXXXXXXX, XXXXXXXXX XXX              XXX-XX-XXXX  00567800000  88114FR2  12/01/20XX          200.00          200.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00567800000  88114FR2  12/01/20XX            1.00            1.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX            2.00            2.00             .00  
XXXXXX, XXXXX X                      XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX            3.00            3.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX            4.00            4.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00567800000  88114FR2  12/01/20XX            5.00            5.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX            6.00            6.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00123000000  88114FR2  12/01/20XX            7.00            7.00             .00 
XXXXXXXXXX, XXX X                    XXX-XX-XXXX  00123400000  88114FR2  12/01/20XX          250.00          250.00             .00 
XXXXXXX, XXXX X                      XXX-XX-XXXX  00123400000  88114FR2  12/01/20XX          423.00          169.91          253.09 
XXXXXX, XXXX X                       XXX-XX-XXXX  00123400000  88114FR2  12/01/20XX           10.00           10.00             .00 
XXXXXXX, XXXXXXX X                   XXX-XX-XXXX  00567800000  88114FR2  12/01/20XX          200.00          200.00             .00 
XXXXXXXXXX, XXXXXXX X                XXX-XX-XXXX  00123400000  88114FR2  12/01/20XX          150.00          150.00             .00 
XXXX, XXXX                           XXX-XX-XXXX  00400000000  88114FR2  12/01/20XX           10.00           10.00             .00 
XXXXXX, XXXXXX X                     XXX-XX-XXXX  00542400000  88114FR2  12/01/20XX          100.00          100.00             .00 
XXXX, XXXXX X                        XXX-XX-XXXX  00565500000  88114FR2  12/01/20XX          300.00          300.00             .00 
XXXXXXXX, XXX X                      XXX-XX-XXXX  00548600000  88114FR2  12/01/20XX          250.00          250.00             .00 
XXXX, XXXXX                          XXX-XX-XXXX  00565500000  88114FR2  12/01/20XX          100.33          100.33             .00 
XXXXXX, XXXXXX X                     XXX-XX-XXXX  00564600000  88114FR2  12/01/20XX           50.00           50.00             .00 
XXXXXXXXX, XXXXX X                   XXX-XX-XXXX  00549600000  88114FR2  12/01/20XX          100.00          100.00             .00 
XXXXXX, XXXXX X                      XXX-XX-XXXX  00400000000  88114FR2  12/01/20XX           10.00           10.00             .00 
XXXXX, XXXXX                         XXX-XX-XXXX  00552900000  88114FR2  12/01/20XX          200.00          200.00             .00 

            TOTAL FOR XXXXXXXXXXXXXXXXXXXXXXXXXXXXX / XXXXXXXXX001                          2686.33         2412.51          273.82