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