Skip to content

USPS Reports Guide
USPS Reports by Number

Report 006 Benefits Profile

This report displays insurance, TexFlex, tobacco premium, defined contribution plans and retirement benefits for all participating employees in the agency.

Report Criteria

Category Benefits Administration
Distribution Agency
Frequency Upon request
Form 111
Sort Sequence
Options H0XCR Sort
Organization Code, Employee Name, Employee Number 909
Page Break
Options H0XCR Break
Employee 1234
Parameters HNKBA – END DATE
Databases Used H0C, HNK, HNO, HID, HMT, H0B, HAT, HN1, HMS, HNP
Selection Criteria All active employees and those with a termination date greater than the END DATE with benefit deductions set up.
Produce Output? Yes
Request Screen HSRPT
Posting Report? No

Report Headings

AS OF HNK.BAEND
Displays the end date of the request period.
ORGANIZATION CODE HNO.ORGCODE
Displays the organization code as defined by the employee’s position.
EMPLOYEE NAME HID.RPTNAME
Displays the employee’s name.
SOCIAL SECURITY NUMBER H0B.EMPLOYEENO
Displays the employee's SSN.

Insurance

PLAN DERIVED FROM HMT
Displays the type of insurance plan.
OPTION HMT.HLTHCARECD, HMT.DNTLCARECD
Displays the name of the employee’s health insurance carrier and the option for dental coverage.
LEVEL OF COVERAGE HMT.HLTLVCVGCD, HMT.DNTLLVLCD, HMT.OPTLIFECVG, HMT.DISLEVEL, HMT.DISLTLEVEL, HMT.ADDLVLCD, HMT.TBDIFLVL
Displays the level of the employee’s insurance coverage.
AMOUNT OF COVERAGE HMT.ADDCVGAMT
Displays the amount of the employee's voluntary AD & D coverage, if applicable.
EFFECTIVE DATE HMT.HLTHEFFDT, HMT.DNTLEFFDT, HMT.OPLFEFFDT, HMT.DPLFEFFDT, HMT.DISYEFFDT, HMT.DISLTEFFNT, HMT.VADDEFFDT, HMT.TBDIFEFFDT
Displays the date the employee’s insurance coverage became effective.
EMPLOYEE PAID MONTHLY AMOUNT HMT.HLTHEEAMT, HMT.DNTLEEAMT, HMT.OPLFEEAMT, HMT.DPLFEEAMT, HMT.DISYEEAMT, HMT.ADDEEAMT, HMT.TBDIFAMT
Displays the employee’s monthly deduction amount for the coverage.
STATE PAID/STO MONTHLY AMOUNT HMT.HLTHERAMT
Displays the state’s contribution for health insurance or opt-out plans.

TexFlex

CURRENT ELECTION
Displays the name of the TexFlex plan.
MONTHLY AMOUNT HMT.TFHLTHAMT, HMT.TFDEPMNAMT
Displays the monthly deduction amount.
EFFECTIVE DATE HMT.TFHLTHCRDT, HMT.TFDEPCRDT
Displays the date the current election became effective.
PREMIUM CONVERSION HMT.TFREDIRCD
Displays Yes or No to indicate whether the employee’s premium will be deducted pre-tax or post-tax. Effective September 1, 1999, all premium conversion flags should be "Y", except for disability and dependent life.
PREMIUM CONVERSION EFFECTIVE DATE HMT.PRMCNVEFDT
Displays the effective date for premium conversion coverage.

Retirement

PLAN H0B.FLAGB
Displays the name of the retirement plan to which the employee contributes.
EMPLOYEE CONTRIBUTION % HAT.SMMNCNTPCT
Displays the percentage of pay the employee is contributing to the retirement plan.
STATE CONTRIBUTION % HAT.SMMNCNTPCT
Displays the percentage of the employee’s pay the state is contributing to the retirement plan for the employee.

Defined Contributions And Optional Retirement

PLAN HN1.PLANID
Displays the name of the defined contribution or optional retirement plan.
TYPE DERIVED
Displays the type of defined contribution or optional retirement plan.
VENDOR NO./NAME HMS.ERSVENID
Displays the number and name of the vendor for the employee’s plan.
EFFECTIVE DATE HN1.HISTORYD
Displays the effective date of the employee’s contribution to the specified plan.
PRODUCT H1TZZ (TABLE 879)
Displays the number and name of the product the employee selected, if applicable.
% HN1.PCTFAELEC, HN1.PCTMFELEC, HN1.PCTSCELEC, HN1.PCTSAELEC, HN1.PCTCDELEC, HN1.PCTFGFELEC, HN1.PCTVAELEC, HN1.PCTMMELEC, HN1.PCTWLELEC, HN1.PCTGVELEC, HN1.PCTTLELEC
Displays the percentage of pay the employee is contributing to the product each pay period.
PAY PERIOD AMOUNT HN1.AMTFAELEC, HN1.AMTMFELEC, HN1.AMTSCELEC, HN1.AMTSAELEC, HN1.AMTCDELEC, HN1.AMTGFELEC, HN1.AMTVAELEC, HN1.AMTMMELEC, HN1.AMTWLELEC, HN1.AMTGVELEC, HN1.AMTTLELEC
Displays the amount the employee is contributing to the product each pay period.

Total

% HN1.TOTPCTELEC, HN1.PTPCTELEC
Displays the total percentage of pay the employee is contributing.
PAY PERIOD AMOUNT HN1.TOTAMTELEC
Displays the total amount the employee is contributing.

Sample Report

    
    REPORT:     6                             UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM                             PAGE:   1     
    AGENCY:   XXX                                      XXXXXXXXXXXXXXXXXXXXXXXXX                                 RUN DATE: XX/XX/20XX
                                                           BENEFITS PROFILE                                      RUN TIME: 10:14:54  
                                                           AS OF XX/XX/20XX                                                          
  ORGANIZATION CODE: 51200512900                                                                                                     
  EMPLOYEE NAME: XXX, XXXX                                                                                                       
  SOCIAL SECURITY NUMBER: XXX-XX-XXXX                                                                                                
                                                                                                                                     
  INSURANCE:                                                                                                                         
                                            LEVEL               AMOUNT        EFFECTIVE    EMPLOYEE PAID    STATE PAID / STO         
  PLAN            OPTION                 OF COVERAGE          OF COVERAGE        DATE      MONTHLY AMOUNT    MONTHLY AMOUNT          
  --------------  ---------------     -----------------   ------------------  ----------  ---------------  --------------------------
  HEALTH          HS IN AREA          EMPLOYEE FAMILY                         09/01/20XX        $418.64     $856.94/   $0.00  
  HEALTH SAVINGS                                                              09/01/20XX          $0.00       $0.00/   
  DENTAL          DENTAL HMO          EMPLOYEE FAMILY                         09/01/20XX         $28.98                              
  TOBACCO PREM                        EMPLOYEE FAMILY                         09/01/20XX         $90.00                              
  OPTIONAL LIFE                       NONE                                    09/01/20XX          $0.00                              
  DEPENDENT LIFE                      YES                                     09/01/20XX          $1.38 
  VISION                              LEVEL                                   09/01/20XX          $0.00                   
  DIS - SHORT-TERM                    NONE                                    09/01/20XX          $0.00                              
  DIS - LONG-TERM                     NONE                                    09/01/20XX          $0.00                              
  VOLUNTARY AD&D                      NONE                                    09/01/20XX          $0.00                              
  TEXFLEX:                                                                                                                           
                                    MONTHLY        EFFECTIVE     PREMIUM         PREMIUM CONVERSION                                  
  CURRENT ELECTION                   AMOUNT          DATE        CONVERSION        EFFECTIVE DATE                                    
  ----------------------------     ----------      ---------     ----------      ------------------                                  
  FSA HEALTH CARE                        0.00     09/01/20XX        YES              09/01/20XX                                      
  FSA DAY CARE                           0.00     09/01/20XX          
  LFSA                                                               
  RETIREMENT:                                                                                                                        
  PLAN                                            EMPLOYEE CONTRIBUTION %        STATE CONTRIBUTION %                                
  -----------------------------------------       -----------------------        --------------------                                
  EMPLOYEES RETIREMENT SYSTEM                              9.500%                         9.500%                                     
  DEFINED CONTRIBUTIONS AND OPTIONAL RETIREMENT:                                                                                     
                                        ------------------- PRODUCT DATA -----------------      -------- TOTAL -------               

                    VENDOR       EFFECTIVE                                            PAY PERIOD                  PAY PERIOD                
  PLAN	 TYPE    NO.    NAME       DATE               PRODUCT                %          AMOUNT           %          AMOUNT                  
  ----   ----  ---------------  ---------     ----------------------       ------     -----------      ------     -----------               
  401    401k  8888 STATE ST    09/01/20XX                                                              1.00