USPS Reports Guide –
USPS Reports by Number –
Report 157 College Savings Plan Detail
This report lists each employee who has a deduction for the 529 College Savings Plan and/or the Texas Tuition Promise Fund. The report includes the amount that was deducted and the account number associated with the payment and totals the deduction by vendor. The total deductions per vendor should equal the amount of the warrant issued for each vendor. Send the appropriate page(s) of this report with the warrant to the vendor(s) using the address listed on the report.
Report Criteria
| Category | Payroll Administration | ||||
|---|---|---|---|---|---|
| Distribution | Agency | ||||
| Frequency | Runs with payrolls | ||||
| Form | 111 | ||||
| Sort Sequence |
|
||||
| Page Break | VENDOR NAME/TEXAS IDENTIFICATION NUMBER (TIN) | ||||
| Parameters | HNKPA – START DATE, END DATE, HSRPQ – WARRANT DATES | ||||
| Databases Used | H0C, H0H, H0M, H0B, HID, HNZ | ||||
| Selection Criteria | All employees with a tuition plan deduction taken on the payroll. | ||||
| Produce Output? | Yes | ||||
| Request Screen | HSRPQ; HPRPT – Set up to run automatically with each payroll. | ||||
| Posting Report? | No | ||||
| Additional Notes |
Report Headings
- VENDOR NAME/TEXAS IDENTIFICATION NUMBER (TIN)
- Displays the vendor name, TIN and address to mail the report and warrant associated with the deductions.
- EMPLOYEE SSN H0H.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- PAY PERIOD MO/YR DERIVED H0H.PERIODEND
- Displays the requested pay period. If there is more than one prepaid
tuition deduction, each one is displayed on a separate line of the report.
Note: If an employee is paid semimonthly, the prepaid tuition deduction is taken from the second payment of the month. If an employee is paid monthly, the deduction is taken every pay period.
- DOCUMENT NUMBER H0H.ALPHACONS1
- Displays the USAS document number assigned to the payroll.
- ACCOUNT NUMBER HNZ.CASENO
- Displays the account number of the employee's benefactor for the prepaid tuition deduction.
- AMOUNT DEDUCTED H0M.DEDAMT(59)
- Displays the prepaid tuition deduction for the corresponding pay period and account number.
- TOTAL (FOR VENDOR)
- Displays the total deduction per vendor and should equal the amount of the warrant for each vendor.
Sample Report
REPORT: 157 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: xxx xxxxxxxxxx xx xxxxxx xxxxxxxxxx RUN DATE: XX/XX/20XX
COLLEGE SAVINGS PLAN DETAIL RUN TIME: 14:06:16
VENDOR NAME / TEXAS IDENTIFICATION NUMBER (TIN)
ADDRESS
CITY, STATE ZIP CODE
EMPLOYEE PAY PERIOD DOCUMENT ACCOUNT AMOUNT
SSN EMPLOYEE NAME MO/YR NUMBER NUMBER DEDUCTED
XXX-XX-XXX9 XXXXXXXXXX, XXXX X 03/09 xxxxxxxx XXXXXXXXXX 83.13
XXX-XX-XXX6 XXXXXXX, XXXXXXXX XXX 03/09 xxxxxxxx XXXXXXXXXX 126.00
XXX-XX-XXX7 XXXX, XXXXXX XXXX 03/09 xxxxxxxx XXXXXXXXXX 105.77
XXX-XX-XXX4 XXXXXX, XXXXXX XXXXX 03/09 xxxxxxxx XXXXXXXXXX 42.00
03/09 xxxxxxxx XXXXXXXXXX 45.00
XXX-XX-XXX6 XXXXXXXX-XXXXXX, XXXX X 03/09 xxxxxxxx XXXXXXXXXX 156.78
XXX-XX-XXX0 XXXXXX, XXXXXX XXXX 03/09 xxxxxxxx XXXXXXXXXX 179.00
XXX-XX-XXX4 XXXXX-XXXXX, XXXXXX 03/09 xxxxxxxx XXXXXXXXXX 53.63
XXX-XX-XXX2 XXXXXXX, XXXXXXX X 03/09 xxxxxxxx XXXXXXXXXX 167.00
03/09 xxxxxxxx XXXXXXXXXX 165.00
XXX-XX-XXX6 XXXXXXXX, XXXXXXXXX 03/09 xxxxxxxx XXXXXXXXXX 103.00
03/09 xxxxxxxx XXXXXXXXXX 90.00
XXX-XX-XXX6 XXXXXX, XX XXXX 03/09 xxxxxxxx XXXXXXXXXX 95.75
03/09 xxxxxxxx XXXXXXXXXX 98.00
03/09 xxxxxxxx XXXXXXXXXX 136.00
XXX-XX-XXX8 XXXXXX, XXXXX X 03/09 xxxxxxxx XXXXXXXXXX 90.00
XXX-XX-XXX3 XXXXXX, XXXXXXX XXXXXXXXX 03/09 xxxxxxxx XXXXXXXXXX 105.77
XXX-XX-XXX0 XXXXXX, XXXXXX X 03/09 xxxxxxxx XXXXXXXXXX 92.00
XXX-XX-XXX9 XXXXXX, XXXX 03/09 xxxxxxxx XXXXXXXXXX 148.00
XXX-XX-XXX2 XXXXXXX, XXXXXX X 03/09 xxxxxxxx XXXXXXXXXX 176.00
XXX-XX-XXX9 XXXXXXX, XXXXXXX XXXXXX 03/09 xxxxxxxx XXXXXXXXXX 77.00
XXX-XX-XXX3 XXXXXXX, XXXXXXXX X 03/09 xxxxxxxx XXXXXXXXXX 20.60
XXX-XX-XXX4 XXXXXXX, XXXXXXX 03/09 xxxxxxxx XXXXXXXXXX 152.00
XXX-XX-XXX6 XXXXXXX, XXXXXXX XXXX 03/09 xxxxxxxx XXXXXXXXXX 124.00
XXX-XX-XXX8 XXXXX, XXXXX XXXXXXX 03/09 xxxxxxxx XXXXXXXXXX 79.54
03/09 xxxxxxxx XXXXXXXXXX 73.83
TOTALS FOR VENDOR NAME / TEXAS IDENTIFICATION NUMBER(TIN) 2,784.80