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 |
|
||||
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