Skip to content
Breadcrumbs

USPS Reports Guide –
USPS Reports by Number –
Report 174 D.C.P. Contribution/Loan Activity

This report displays employees currently participating in a defined contribution plan (DCP) during the reporting month. DCP includes ORP, 403(b), 457 and Roth 457. 401(k) and Roth 401(k) are not included in this report.

Report Criteria

Category Benefits Administration
Distribution Agency
Frequency Monthly
Form 111
Sort Sequence
Options H0XCR Sort
Plan ID, Product Type (Loan or Deferral) 861
Page Break  
Parameters HNKBA – START DATE, END DATE
Databases Used H0B, H0C, H0M, HID, HMS, HN1, HNK
Selection Criteria All employees with a deferred compensation deduction [ORP, 403(b), 457, Roth 457] during the reporting period.
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

FROM/TO HNK.BASTDT/HNK.BAEDT
Displays the beginning and ending dates of the reporting period.
PLAN ID HN1.PLANID
Displays the plan ID.
ORPOptional Retirement Plan
403Tax Sheltered Annuity
457Deferred Compensation Plan
EMPLOYEE SSN HN1.EMPLOYEENO
Displays the employee's SSN.
EMPLOYEE NAME HID.RPTNAME
Displays the employee's name.
VEND ID HN1.ERSVENID
Displays the vendor identification number.
VENDOR NAME HMS.VNDRFULLNM
Displays the vendor name.
PROD TYPE HN1.PLTYPE
Displays the product code selected by the employee.
ROTHRoth Deferral
FAFixed annuity
MFMutual funds
SASavings account
CDCertificate of deposit
GFGroup fixed annuity
VAVariable annuity
MMMoney market
TLTerm life
WLWhole life
GVGroup variable annuity
SCShare certificate
LOANLoan Deferral
MTD DEDUCTION HN1.MTDAMTFA, HN1.MTDAMTMF, HN1.MTDAMTMM, HN1.MTDAMTSA, HN1.MTDAMTCD, HN1.MTDAMTGF, HN1.MTDAMTVA, HN1.MTDAMTTL, HN1.MTDAMTSC, HN1.MTDAMTWL, HN1.MTDAMTGV, HN1.MTDTOTAMT
Displays the month-to-date total for each product.
QTD DEDUCTION HN1.QTDAMTFA, HN1.QTDAMTMF, HN1.QTDAMTMM, HN1.QTDAMTSA, HN1.QTDAMTCD, HN1.QTDAMTGF, HN1.QTDAMTVA, HN1.QTDAMTTL, HN1.QTDAMTWL, HN1.QTDAMTGV, HN1.QTDTOTAMT, HN1.QTDAMTSC
Displays the quarter-to-date total for each product.
YTD DEDUCTION HN1.YTDAMTFA, HN1.YTDAMTMF, HN1.YTDAMTMM, HN1.YTDAMTSA, HN1.YTDAMTCD, HN1.YTDAMTGF, HN1.YTDAMTVA, HN1.YTDAMTTL, HN1.YTDAMTWL, HN1.YTDAMTGV, HN1.YTDAMTSC, HN1.YTDTOTAMT
Displays the year-to-date total for each product.
VENDOR ID TOTAL DERIVED
Displays the employee's month-to-date, quarter-to-date, and year-to-date totals by vendor ID.
PLAN ID TOTAL DERIVED
Displays the employee's month-to-date, quarter-to-date and year-to-date totals by plan ID. If an individual participates in more than one defined contribution plan, a separate total is displayed for each plan.
AGENCY TOTAL DERIVED
Displays the agency month-to-date, quarter-to-date and year-to-date totals for all defined contribution deductions.

Sample Report

  REPORT:   174                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:     1    
  AGENCY:   XXX                                     XXXXXX XXXXXXXXX XXXXXXXXX                                 RUN DATE: XX/XX/20XX
                                                   DCP CONTRIBUTION/LOAN ACTIVITY                              RUN TIME: 21:55:12 
                                                                                                                                  
                                                   FROM 01/01/20XX TO 01/31/20XX                                                  
==================================================================================================================================
  PLAN                                            VEND                                 PROD       MTD         QTD         YTD     
   ID   EMPLOYEE SSN         EMPLOYEE NAME         ID         VENDOR NAME              TYPE    DEDUCTION   DEDUCTION   DEDUCTION  
  ----  ------------  --------------------------  ----  ------------------------       ----    ---------   ---------   ---------  
                                                                                                                                  
  457    XXX-XX-XXXX  XXXXXX, XXXXXXXXX           9999  STATE STREET BANK AND TRUST     MF        100.00      200.00      200.00  
         XXX-XX-XXXX  XXXXXX, XXXXXXXXX                                                 FA         20.00       40.00       40.00  
         XXX-XX-XXXX  XXXXXX, XXXXXXXXX                                                 FA        200.00      400.00      400.00  
                                                                                              ----------  ----------  ----------  
                        *** VENDOR ID TOTAL *                                                     320.00      640.00      640.00  
                                                                                              ----------  ----------  ----------  
  457                   *** PLAN ID TOTAL ***                                                     320.00      640.00      640.00  
                                                                                              ----------  ----------  ----------  
                        *** AGENCY TOTAL ***                                                      320.00      640.00      640.00  
                                                                                              ==========  ==========  ==========