FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
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
Options HØXCR Sort
Document Number, Employee Name, Period End Date
889
Page Break VENDOR NAME/TEXAS IDENTIFICATION NUMBER (TIN)
Parameters HNKPA – START DATE, END DATE, HSRPQ – WARRANT DATES
Databases Used HØC, HØH, HØM, HØB, 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 HØH.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
PAY PERIOD MO/YR DERIVED HØH.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 HØH.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 HØM.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      
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