USPS Reports Guide –
USPS Reports by Number –
Report 129 Child Support/Spousal Maintenance Sub-Deductions
This report displays all employees with child support and spousal maintenance deductions on the current payroll.
Report Criteria
Category | Payroll Administration | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Distribution | Agency | ||||||||||
Frequency | Runs with payroll. | ||||||||||
Form | 111 | ||||||||||
Sort Sequence |
|
||||||||||
Page Break |
|
||||||||||
Parameters | |||||||||||
Databases Used | H0B, H0C, H0H, H0M, H0V, HID, HNP, HNZ | ||||||||||
Selection Criteria | All employees with a child support or spousal maintenance deduction (HNZ.Currdedamt or HNZ.Dedntaken not equal to 0) on the current payroll. | ||||||||||
Produce Output? | Yes | ||||||||||
Request Screen | HPRPT – Set up to run automatically with each payroll. | ||||||||||
Posting Report? | No | ||||||||||
Additional Notes | ** EDIT/REPORT RUN ** will display in the top left corner 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. |
Report Headings
- DOCUMENT NUMBER 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 employee.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- SSN HNH.EMPLOYEENO
- Displays the employee's SSN.
- DEDUCT TYPE DERIVED
- Displays the deduction number and type.
- SUB-DED NUMBER HNZ.SUBNUM
- Displays the sub-deduction number.
- CASE ID HNZ.CASENO
- Displays the court case number assigned to the child support order.
- VENDOR NM/CAUSE NO HNZ.VENDORNAME/HNZ.CAUSENO
- Displays the name of the child support vendor or for summary single direct deposit vendors, displays the abbreviated two-character vendor name (for TxSDU displays “Tx”) followed by the cause number.
- MED SPT HNZ.MEDIND
- Displays Y (yes) or N (no) and indicates that employer-provided health insurance is available to the employee. The TxSDU requires this information.
- CURRENT DEDUCTION HNZ.CURRDEDAMT
- Displays the amount of the child support deduction taken.
- DEDUCTION NOT TAKEN HNZ.DEDNTAKEN
- Displays the amount of the child support deduction that was scheduled to be taken; but was not.
- SCHEDULED DEDUCTION DERIVED FROM HNZ (CURRDEDAMT + DEDNTAKEN)
- Displays the amount of the child support deduction that was scheduled to be taken.
- SUBTOTAL BY ORG CODE DERIVED
- Displays the total amount of CURRENT DEDUCTION, DEDUCTION NOT TAKEN, and SCHEDULED DEDUCTION for each organization code if the organization code break is being used.
- GRAND TOTAL BY DOCUMENT DERIVED
- Displays the total amount of CURRENT DEDUCTION, DEDUCTION NOT TAKEN, and SCHEDULED DEDUCTION for the agency.
Sample Report
REPORT: 129 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1 AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX CHILD SUPPORT/SPOUSAL MAINTENANCE SUB-DEDUCTIONS RUN TIME: 08:12:55 ** EDIT/REPORT RUN ** DOCUMENT NUMBER 88106FR1, PAYMENT DATE 12/01/20XX EMPLOYEE SSN DEDUCT SUB-DED CASE ID VENDOR NM/CAUSE MED CURRENT DEDUCTION SCHEDULED NAME TYPE NUMBER NO SPT DEDUCTION NOT TAKEN DEDUCTION XXXXXXXX, XXXXX XXX-XX-XXXX 14/CS 001 11111111111111111111 TX/999999999999999 Y 100.00 .00 100.00 XXXXXXXX, XXXXXX XXX-XX-XXXX 14/CS 002 ABCD-11 TX/FM-XX-XXXXXX 200.00 .00 200.00 GRAND TOTAL BY DOCUMENT: 300.00 .00 300.00