FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
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
Options HØXCR Sort HØXCR Break
None
130, 131
1000
Organization Code
129, 132
0000
Parameters  
Databases Used HØB, HØC, HØH, HØM, HØV, 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 HØH.ALPHACONS1
Displays the USAS document number assigned to the payroll.
PAYMENT DATE HØH.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

Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy