USPS Reports Guide –
USPS Reports by Number –
Report 175 Defined Contribution Transmittal Letter
This report generates a letter to the vendor listing individuals participating in the Tax Sheltered Annuity (403(b)) Program and the Deferred Compensation (457) Program. This letter (report) should accompany the warrant to the vendor so the vendor can credit the employee's deduction to the applicable product(s). The report will no longer print for Vendor ID 9999 as of Feb. 1, 2012.
Report Criteria
| Category | Benefits Administration |
|---|---|
| Distribution | Agency |
| Frequency | Runs with final payrolls. |
| Form | 111 |
| Sort Sequence | Vendor Number, Employee Name, Employee Number, Plan ID (internal sort) |
| Page Break | Vendor Number |
| Parameters | HNKBA – CURR PAYROLL MONTH |
| Databases Used | HNK, H0C, HMS, HID, HN1, H0B |
| Selection Criteria | All employees with a current defined contribution (HN1.CURAMT) deduction (403(b), 457) not equal to zero. |
| Produce Output? | Yes |
| Request Screen | HSRPT; HPRPT – Set up to run automatically with each final payroll. |
| Posting Report? | No |
| Additional Notes |
Report Headings
- DEDUCTIONS FROM/TO DERIVED FROM HNK.FLAG69
- Displays the beginning and ending dates of the reporting period.
- TO HMS.VNDRFULLNM, HMS.ERSVENID, HMS.VNDRADDR1-4
- Displays the vendor's name, identification number and address.
- EMPLOYEE SSN HN1.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- PLAN ID HN1.PLANID
- Displays the plan ID.
403 Tax Sheltered Annuity 457 Deferred Compensation Plan - PROD TYPE HN1.PLTYPE
- Displays the product code selected by the employee.
FA Fixed annuity MF Mutual funds SA Savings account CD Certificate of deposit GF Group fixed annuity VA Variable annuity MM Money market TL Term life WL Whole life GV Group variable annuity SC Share certificate - CURRENT DEDUCTION HN1.CURAMTFA, HN1.CURAMTMF, HN1.CURAMTMM, HN1.CURAMTSA, HN1.CURAMTCD, HN1.CURAMTGF, HN1.CURAMTVA, HN1.CURAMTTL, HN1.CURAMTWL, HN1.CURAMTGA, HN1.CURAMTSC, HN1.CURTOTAMT
- Displays the employee's current deduction for the product type indicated.
- MTD DEDUCTION HN1.MTDAMTFA, HN1.MTDAMTMF, HN1.MTDAMTMM, HN1.MTDAMTSA, HN1.MTDAMTCD, HN1.MTDAMTGF, HN1.MTDAMTVA, HN1.MTDAMTTL, HN1.MTDAMTWL, HN1.MTDAMTGV, HN1.MTDTOTAMT, HN1.MTDAMTSC
- Displays the employee's month-to-date total for the product type indicated.
- TOTAL DERIVED
- Displays the agency's vendor total for the payroll.
Sample Report
REPORT: 175 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX TEXAS LEGISLATIVE COUNCIL RUN DATE: XX/XX/20XX
DEFINED CONTRIBUTION TRANSMITTAL LETTER RUN TIME: 23:20:07
DEDUCTIONS FROM 01/01/20XX TO 01/31/20XX
TO:M XXXXX XXXXXX XXXX XXXX XXXXX 0035
ACCT XXX-XXX-XXX
XXX XXXXXXXX XX.
XXXXXX, XXX XXXXXX
EMPLOYEE PLAN PROD CURRENT MTD
SSN EMPLOYEE NAME ID TYPE DEDUCTION DEDUCTION
----------- --------------------------- ---- ---- ----------- -----------
XXX-XX-XXXX XXXXXXXXX, XXXXXXXX 403 FA 500.00 500.00
XXX-XX-XXXX XXXXXX XXXXXX X 403 FA 100.00 100.00
XXX-XX-XXXX XXXXX,XXXXXXX 403 FA 200.00 200.00
XXX-XX-XXXX XXXXX, XXXXXXXXX 403 FA 500.00 500.00
XXX-XX-XXXX XXXXXXX, XXXXXXXXXXX 403 FA 1865.00 1865.00
XXX-XX-XXXX XXXX, XXXXXXXX 403 FA 1667.00 1667.00
XXX-XX-XXXX XXXXX, XXXXXX XXXXXX 403 FA 300.00 300.00
XXX-XX-XXXX XXXXX, XXXXXXX 403 FA 360.00 360.00
XXX-XX-XXXX XXXXXXX, XXXXXXXX 403 FA 25.00 25.00