Delivered Benefit Arrays

This table lists the delivered benefit arrays:

Array Name	Description
BEN AR BEN PRG DEF	Retrieves plan data from the benefit's BEN DEFN_OPTN and BEN_DEFN_COST tables.
BEN AR BEN PROG	Retrieves the benefit program in which the employee is enrolled from the benefit's BEN_PROG_PARTIC table.
BEN AR BN FORM DEF	Retrieves benefit formula definition data from the BN_FORM_DEF table.
BEN AR BN FORMULA	Retrieves benefit formula data from the BN_FORMULA table.
BEN AR CALC RULE	Retrieves the calculation rule data from the benefit's CALC_RULES_TBL table.
BEN AR COV GRP	Retrieves the coverage group's maximum amount from the benefit's COVG_GROUP_TBL table.
BEN AR DEP BIRTH	Retrieves the employee's dependent birth date information from the benefit's DEP_BEN table.
BEN AR DEP SEX SMK	Retrieves the employee's dependent gender and smoker status information from the benefit's DEP_BEN_EFF table.
BEN AR HLTH PLANS	Retrieves the employee's medical plan data from the benefit's HEALTH_BENEFIT table.
BEN AR LIFE PARM	Retrieves life insurance parameters from the benefit's LIFE_ADD_TBL table.
BEN AR LIFE PLANS	Retrieves the employee's life insurance data from the benefit's LIF_ADD_BENEF table.
BEN AR LIMIT	Retrieves limit data from the benefit's LIMIT_TBL table.
BEN AR PRIMARY JOB	Retrieves the employee's primary job data from the benefit's PRIMARY_JOB table.
BEN AR RATE DATA	Retrieves benefit rate data from the BN RATE DATA table using three keys.
BEN AR RATE DAT2	Retrieves benefit rate data from the BN RATE DATA table using two keys.
BEN AR RATE TBL	Retrieves benefit rate data from the BN_RATE_TBL table.
BEN AR SAV MGMT	Retrieves the employee's 402G extension amount from the benefit's SAVINGS_MGT_EE table.
BEN AR SAV PLANS	Retrieves the employee's savings plan enrollments from the benefit's SAVINGS_PLAN table.
BEN AR SAV PLN PRM	Retrieves the 401k pretax percentage limit from the benefit's SAVINGS_PLN TBL table.
BEN AR SPS LIF DEP	Retrieves spouse's ID from the benefit's LIF_ADD_BENEF table.