Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 194 Prepaid Tuition Detail Report

This report lists each employee who has a prepaid tuition deduction, the amount that was deducted, and the account number associated with the payment. It totals the deductions for all participating employees, which should equal the amount of the warrant issued with the payroll. Send both this report and the warrant to the Comptroller of Public Accounts – Texas Tomorrow Fund Division.

Report Criteria

Category Payroll Administration
Distribution Agency
Frequency Runs with payroll.
Form 111
Sort Sequence
Options H0XCR Sort
Document Number, Employee Name 883
Page Break  
Parameters
  • HNKPA – START DATE, END DATE
  • HSRPQ – WARRANT DATES
Databases Used H0C, H0H, H0M, H0B, HID, HNY, HNK
Selection Criteria All employees with a prepaid tuition deduction taken on the payroll.
Produce Output? Yes
Request Screen HSRPT; HPRPT – Set up to run automatically with each payroll.
Posting Report? No
Additional Notes ** EDIT/REPORT RUN ** will display in the top left corner of the report 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.
EMPLOYEE SSN H0H.EMPLOYEENO
Displays the last four digits of 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 you have 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 deducted from the second payment of the month. If an employee is paid monthly, the prepaid tuition deduction is deducted every pay period.

ACCOUNT NUMBER HNY.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.
EMPLOYEE TOTAL DERIVED
Displays the total amount deducted from the employee's pay for the pay period, if multiple deductions are taken.
DOCUMENT TOTAL DERIVED
Displays the total amount deducted from all employees' pay for the document.
AGENCY TOTAL DERIVED
Displays the total amount deducted from all employees' pay for the agency.

Sample Report

    REPORT:   194                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
    AGENCY:   XXX                                      XXXXXXXXXXXXXXXXXXXXXXXXX                                 RUN DATE: XX/XX/20XX
                                                    PREPAID TUITION DETAIL REPORT                                RUN TIME: 22:21:21 
                                                       DOCUMENT NUMBER 84084FR1                                              
       
       EMPLOYEE                                                             PAY PERIOD           ACCOUNT             AMOUNT         
         SSN            EMPLOYEE NAME                                         MO/YR               NUMBER            DEDUCTED        
                                                                                                                                    
                                                                                                                                    
      XXX-XX-XXXX       XXXXXXX, XXXXXXXX X                                   08/04             XXXXXXXXXX            115.53        
      XXX-XX-XXXX       XXXXXXX, XXX X                                        08/04             XXXXXXXXXX            179.00        
                                                                              08/04             XXXXXXXXXX            140.00        
                                                   EMPLOYEE TOTAL                                                            319.00 
      XXX-XX-XXXX       XXXXX, XXXXX X                                        08/04             XXXXXXXXXX             98.27        
      XXX-XX-XXXX       XXXXXX, XXXXXXX X                                     08/04             XXXXXXXXXX            173.00        
                                                                                                                                    
                                                   DOCUMENT TOTAL                                                            705.80 
                                                                                                                                    
                                                   AGENCY TOTAL                                                              705.80