FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USPS Reports Guide
Report 017 Generated Defined Contribution Deductions

This report displays additions and changes to contribution elections for defined contribution 401(k), Roth 401(k), 401(k) loan, 403(b), 457, Roth 457, 457 loan and ORP participants and produces deduction (225) transactions used to set up a payroll deduction on HØZUC.

Report Criteria

Category Benefits Administration
Distribution Agency
Frequency Nightly
Form 917
Sort Sequence
Options HØXCR Sort
Employee Name
874
Page Break  
Parameters  
Databases Used HØC, HID, HAT, HN1
Selection Criteria All employees with defined contribution changes on HN1U1, HN1UA, HN1R1, HN1R7, HN1LN, HN1LO and HN1U6 since the report was last run.
Produce Output? Yes
Request Screen HPRPT – Automatically runs in maintenance cycle.
Posting Report? Yes – Updates HØZUC.
Additional Notes Changes made to a future month, prior to Month-End Clears, are pended until the clears are processed.

Report Headings

EMPLOYEE NAME HID.RPTNAME
Displays the employee’s name.
EMP SSN HCM.EMPLOYEENO
Displays the employee’s SSN.
DCP HN1.PLANID
Displays a value indicating the employee’s defined contribution plan (DCP).
401Tex$aver
401LLoan Repayment
403Tax Sheltered Annuity
457Deferred Compensation Plan
ORPOptional Retirement Plan
SM HN1.SM
Displays a value indicating the source of money for the deduction.
E1Employee pretax
E2Employee posttax
E3State of Texas
EL401(k) and/or loan repayment
DED NO DERIVED
Displays the deduction number associated with the DCP.
AMOUNT DERIVED
Displays the amount of the employee’s salary deferred for the 457 DCP and Roth 457 DCP.
PERCENT HN1.PTPCTELEC
Displays the percentage of the employee’s salary deferred for the 401(k) DCP or Roth 401(k) DCP.
START DATE HN1.HISTORYDT
Displays the effective date for the DCP deduction.
UTILITY H1TZZ (TABLE 237) AND HN1
Displays the processing and taxing codes for the deduction.
DED FREQ HN1.PTDEDNO
Displays the frequency of the deduction.
00Do not take this deduction
01Deduct on the first pay period of the month
02Deduct on the second pay period of the month for employees paid semi-monthly
09Deduct on every pay period

Note: Deduction frequencies are defaulted from Decode Table 989 based on the employees pay frequency from the last personnel action entered.

Sample Report

 REPORT:    17                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
 AGENCY:   XXX                                   XXXXXXXXXXXXXXXXXXXXXXXXXXXXX                                RUN DATE: XX/XX/20XX
                                           GENERATED DEFINED CONTRIBUTION DEDUCTIONS                          RUN TIME: 19:22:48 
                                                                                                                                 
                                             AS OF 09/27/20XX -  PAYROLL MONTH SEPTEMBER                                         
                                                                                                                                 
    EMPLOYEE NAME                 EMP SSN       DCP    SM   DED NO    AMOUNT     PERCENT   START DATE    UTILITY   DED FREQ      
                                                                                                                                   
  XXXXXXXXX, XXXXXX X            999-99-9999    401    E1     053       0.00      16.000   09/13/20XX    6001000      09         
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