USPS Reports Guide –
USPS Reports by Number –
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 H0ZUC.
Report Criteria
Category | Benefits Administration | ||||
---|---|---|---|---|---|
Distribution | Agency | ||||
Frequency | Nightly | ||||
Form | 917 | ||||
Sort Sequence |
|
||||
Page Break | |||||
Parameters | |||||
Databases Used | H0C, 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 H0ZUC. | ||||
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).
401 Tex$aver 401L Loan Repayment 403 Tax Sheltered Annuity 457 Deferred Compensation Plan ORP Optional Retirement Plan - SM HN1.SM
- Displays a value indicating the source of money for the deduction.
E1 Employee pretax E2 Employee posttax E3 State of Texas EL 401(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.
00 Do not take this deduction 01 Deduct on the first pay period of the month 02 Deduct on the second pay period of the month for employees paid semi-monthly 09 Deduct 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