This report displays employees who have a defined contribution plan (DCP) balance for the reporting month. DCP includes 401(k), Roth 401(k), 457, Roth 457 and 403(b).
Report Criteria
| Category |
Benefits Administration |
| Distribution |
Agency |
| Frequency |
Monthly |
| Form |
111 |
| Sort Sequence |
| Options |
H0XCR Sort |
| Plan ID, Termination Date, Employee Name |
856 |
|
| Page Break |
Plan ID, Employee Status |
| Parameters |
HNKBA – START DATE, END DATE |
| Databases Used |
HNK, H0C, HID, H0B, HN1, HMS |
| Selection Criteria |
All employees with a month-to-date defined contribution balance (401(k), Roth 401(k), 457, Roth 457 and 403(b)) greater than zero. |
| Produce Output? |
Yes |
| Request Screen |
HPRPT – Set up to run automatically with Month-End Reports. |
| Posting Report? |
No |
| Additional Notes |
Call your USPS representative when ready to run Month-End Reports. |
Report Headings
- DEDUCTIONS FROM/TO HNK.BASTDT/HNK.BAEDT
- Displays the beginning and ending dates of the reporting period.
- PLAN ID HN1.PLANID
- Displays the plan ID.
| 401 | Tex$aver |
|---|
| 403 | Tax Sheltered Annuity |
|---|
| 457 | Deferred Compensation Plan |
|---|
- EMPLOYEE STATUS DERIVED FROM H0B.TERMDATE
- Displays the status of the employee. If a termination date is present, the status will display Terminated, otherwise it will be active.
- EMPLOYEE SSN HN1.EMPLOYEENO
- Displays the employee's SSN.
- EMPLOYEE NAME HID.RPTNAME
- Displays the employee's name.
- TERM DATE H0B.TERMDATE
- Displays the employee's termination date, if applicable.
- PLAN TYPE DERIVED
- Displays the plan type.
| Type |
Description |
| 401K |
Texa$aver |
| 401R |
Roth Texa$aver |
| 403 |
Tax Sheltered Annuity |
| 457 |
Deferred Compensation Plan |
| 457R |
Roth Deferred Compensation Plan |
- VEND ID HN1.ERSVENID
- Displays the vendor identification number.
- VENDOR NAME HMS.VNDRFULLNM
- Displays the vendor name.
- START DATE HN1.HISTORYDT
- Displays the beginning date of the employee's defined contribution deduction.
- STOP DATE HN1.DEDENDDT
- Displays the ending date of the employee's defined contribution deduction.
- PROD TYPE HN1.PLTYPE
- Displays the product code selected by the employee.
| Blank field | Not applicable to vendor |
|---|
| 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 |
|---|
- M-T-D 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. The report displays a separate total for each vendor and/or product type.
- Y-T-D HN1.YTDAMTFA, HN1.YTDAMTMF, HN1.YTDAMTMM, HN1.YTDAMTSA, HN1.YTDAMTCD, HN1.YTDAMTGF, HN1.YTDAMTVA, HN1.YTDAMTTL, HN1.YTDAMTWL, HN1.YTDAMTGV, HN1.YTDTOTAMT, HN1.YTDAMTSC
- Displays the employee's year-to-date total for the product. The report displays a separate total for each vendor and/or product type.
- EMPLOYEE TOTAL DERIVED
- Displays the employee totals for the Plan ID month-to-date and year-to-date.
- PLAN/STATUS TOTAL DERIVED
- Displays the month-to-date and year-to-date totals by status (active/terminated) by plan for all employees.
Sample Report
REPORT: 171 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX RUN DATE: 03/09/2012
EMPLOYEES WITH D.C.P. BALANCES RUN TIME: 16:31:22
DEDUCTIONS FROM 02/01/2012 TO 02/29/2012
PLAN ID: 401 EMPLOYEE STATUS: ACTIVE
PLAN VEND START DATE PROD
EMPLOYEE SSN EMPLOYEE NAME TERM DATE TYPE ID VEND NAME STOP DATE TYPE M-T-D Y-T-D
------------ ---------------------------- ---------- ---- ---- --------------- ---------- ---- ---------- ----------
XXX-XX-XXX1 EMPLOYEE ONE 401K 8888 STATE STREET BA 01/01/2009 64.01 192.03
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 64.01 192.03
XXX-XX-XXX2 EMPLOYEE TWO 401K 8888 STATE STREET BA 04/01/2009 1298.12 3894.36
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 1298.12 3894.36
XXX-XX-XXX3 EMPLOYEE THREE 401K 8888 STATE STREET BA 04/01/2010 61.41 184.23
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 61.41 184.23
XXX-XX-XXX4 EMPLOYEE FOUR 401K 8888 STATE STREET BA 05/01/2008 78.85 236.55
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 78.85 236.55
XXX-XX-XXX5 EMPLOYEE FIVE 401K 8888 STATE STREET BA 02/01/2010 627.27 1881.81
00/00/0000
XXX-XX-XXX5 EMPLOYEE FIVE 401R 8888 STATE STREET BA 02/01/2012 258.42 258.42
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 885.69 2140.23
XXX-XX-XXX6 EMPLOYEE SIX 401K 8888 STATE STREET BA 08/01/2009 414.02 1242.06
00/00/0000
---------- ----------
*** EMPLOYEE TOTAL *** 414.02 1242.06
---------- ---------
*** PLAN/STATUS TOTAL *** 2802.10 7889.46
========== =========