USPS Reports Guide –
USPS Reports by Number –
Report 038 Annual Retirement Fee Deductions
This report generates the annual retirement fees to be deducted from retirement plan participants, based on the plan assigned. This report will run with agencies' month-end clears and will populate the H0ZUC screen with the new plan year's fee. Eligible retirement plans are ERS, LRS, JR1 and JR2. TRS does not currently charge an annual fee. The ERS and LRS fees are memo deductions only.
Report Criteria
| Category | Benefits Administration | ||||
|---|---|---|---|---|---|
| Distribution | Agency | ||||
| Frequency | Annually | ||||
| Form | 938 | ||||
| Sort Sequence |
|
||||
| Page Break | Plan ID – Detail Section | ||||
| Parameters | HNKBA – END DATE
Note: This does not generate the report. The screen only controls level of detail reported. |
||||
| Databases Used | HNK, H0B, HUA, H1K, H0Z, HMP | ||||
| Selection Criteria | All active employees who are not in the 90-day wait will have the frequency, amount, goal amount and start date (09/01) populated on H0ZUC when your agency's August month-end clears are processed. | ||||
| Produce Output? | Yes | ||||
| Request Screen | Request | ||||
| Posting Report? | Yes – Updates H0ZUC. | ||||
| Additional Notes | Report 038 only includes employees that had a 9/1 retirement fee generated. If the employee was (or is) in a 90-day waiting period and will complete the 90-day wait on 9/1 or later of the new fiscal year, the employee will not be listed on the report. |
Report Headings
- PLAN ID H0B.FLAGB
- Displays the retirement plan code.
ERS Employees Retirement System ESO Elected State Official JR1 Judicial Retirement Plan 1 JR2 Judicial Retirement Plan 2 LRS Employees Retirement System – Legislature TRS Teacher Retirement System - EMPLOYEE SSN H0H.EMPLOYEENO
- Displays employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays employee's name.
- SOURCE OF MONEY HAT.SM
- Displays a value indicating the source of money.
E1 Employee pretax E2 Employee post tax E3 State of Texas paid - FEE DED NUMBER HAT.SMDEDNUM
- Displays the deduction number.
04 Employee paid retirement fee 24 State retirement fee - FEE AMOUNT DERIVED
- Displays the amount of fee.
- GOAL AMOUNT DERIVED
- Displays the total amount of generated deductions for each plan ID.
Sample Report
REPORT: 38 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: XX/XX/20XX
ANNUAL RETIREMENT FEE DEDUCTIONS - DETAIL RUN TIME: 10:23:16
PLAN ID SSN EMPLOYEE SOURCE FEE DED FEE GOAL
NAME OF MONEY NUMBER AMOUNT AMOUNT
------- ----------- ------------------------------- -------- ------- ------ ------
ERS XXX-XX-XXXX XXXXXX, XXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXX, XXXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXXXXX, XXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXXX, XXXX X E3 24 $3.00 $6.00
XXX-XX-XXXX XXXXX, XXXXXXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXX, XXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXX, XXXXX X E3 24 $3.00 $6.00
XXX-XX-XXXX XXXXXXXXXXX, XXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXX, XXXXXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXXXXX, XXXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXX, XXXXXXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXX, XXXX E3 24 $3.00 $3.00
XXX-XX-XXXX XXXXXXXXXXXXXXX, XXXXX E3 24 $3.00 $6.00
ERS TOTAL $39.00