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