Skip to content

USPS Reports Guide
USPS Reports by Number

Report 096 Employee Union Deductions

This report produces a list of all membership dues deducted during a requested time frame.

A file containing this information is also created for all agencies and is given to the Texas State Employees Union (TSEU). A copy of the report should still be sent to the unions each month.

Do NOT set up on HPRPT; it will cause an error.

Report Criteria

Category Payroll Administration
Distribution Agency, TSEU
Frequency Monthly, normally the 19th
Form 996
Sort Sequence
Options H0XCR Sort
Subdeduction Number, Employee Number 996
Page Break Subdeduction Number (Vendor)
Parameters HNKU8 – BEGIN WARRANT DATE, END WARRANT DATE
Databases Used H0C, HNK, H0B, HNZ, HID, HNP, HNJ
Selection Criteria All employees with an employee union deduction where the HNZ.CHKDATE is between the HNKU8 warrant dates.
Produce Output? Yes – Report and Disk.
Request Screen Not requestable by the agencies. Requested by USPS personnel each month.
Posting Report? No
Additional Notes  

Report Headings

EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
EMPLOYEE NUMBER HNZ.EMPLOYEENO
Displays the employee's SSN.
CURRENT DEDUCTION HNZ.CURRDEDAMT
Displays the amount that was deducted from the employee's pay.
DEDUCTION NOT TAKEN HNZ.DEDNTAKEN
Displays the amount not taken from the employee's pay due to insufficient funds.
SCHEDULED DEDUCTION HNZ.DEDNTAKEN + HNZ.CURRDEDAMT
Displays the amount that was scheduled to be deducted from the employee's pay.
WARRANT DATE HNZ.CHKDATE
Displays the payment date of when the deduction was or was not taken.
AGENCY TOTAL DERIVED
Displays the totals for CURRENT DEDUCTION, DEDUCTION NOT TAKEN, and SCHEDULED DEDUCTION.

Sample Report

 REPORT:   96                              UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                    PAGE:  1
 AGENCY:   XXX                                    XXXX XXXXX XXXXXXXXXXX XXXXX                        RUN DATE: XX/XX/20XX
                                          MEMBERSHIP DUES-FLORIDA CARTOONS CREDIT UNTION              RUN TIME: 2:00:00
                                                 FROM 04/01/20XX TO 04/30/20XX                                           


            EMPLOYEE NAME                                  EMPLOYEE       CURRENT       DEDUCTION       SCHEDULED       WARRANT
                                                            NUMBER        DEDUCTION     NOT TAKEN       DEDUCTION       DATE

 
            XXXXX, XXXX                                   XXXXXXXXX         4.00           .00             4.00        04/01/20XX
            XXXXX, XXX X                                  XXXXXXXXX         3.00           .00             3.00        04/01/20XX
                                                  AGENCY TOTAL              7.00