BEN Tables (498)

BEN - Advanced Benefits — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
BEN_ABR_EXTRA_INFO	65	Activity base rate extra information
BEN_ABR_INFO_TYPES	15	Activity base rate extra information types
BEN_ACRS_PTIP_CVG_F	45	Coverages across plan types in programs.
BEN_ACRS_PTIP_CVG_F_EFC	7	This is a copy of the BEN_ACRS_PTIP_CVF_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ACTL_PREM_F	73	The premium for plan and option in plan.
BEN_ACTL_PREM_F_EFC	8	This is a copy of the BEN_ACTL_PREM_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ACTL_PREM_VRBL_RT_F	44	Variable rates that can be applied to plan or option in plans premium.
BEN_ACTL_PREM_VRBL_RT_RL_F	45	Variable rates rules that can be applied to plan or option in plans premium.
BEN_ACTN_TYP	42	Action required to complete enrollment.
BEN_ACTN_TYP_TL	11	MLS translation of action required to complete enrollment.
BEN_ACTY_BASE_RT_CTFN_F	45	Certifications required for Rates.
BEN_ACTY_BASE_RT_F	142	Values to use for activities in plans or options.
BEN_ACTY_BASE_RT_F_EFC	16	This is a copy of the BEN_ACTY_BASE_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ACTY_RT_DED_SCHED_F	45	Deduction schedule for activity rate.
BEN_ACTY_RT_PTD_LMT_F	43	Period to date limits for activity rates.
BEN_ACTY_RT_PYMT_SCHED_F	44	Activity rate payment schedule.
BEN_ACTY_VRBL_RT_F	44	Variable rates for activity rates.
BEN_AGE_FCTR	51	Age factor.
BEN_AGE_RT_F	45	Rates applied to age ranges.
BEN_APLCN_TO_BNFT_POOL_F	43	Show which rates are reducing the credits in a benefit pool.
BEN_APLD_DPNT_CVG_ELIG_PRFL_F	47	Which dependent eligibility profiles are being used by compensation objects.
BEN_ASNT_SET_RT_F	45	Rate applied to an assignment set.
BEN_BATCH_ACTIONS	5
BEN_BATCH_ACTN_ITEM_INFO	15	Action item information created during batch run.
BEN_BATCH_BNFT_CERT_INFO	18	Benefit certification information created during batch run.
BEN_BATCH_COMMU_INFO	14	Communication information created during batch run.
BEN_BATCH_DPNT_INFO	18	Dependent information created during batch run.
BEN_BATCH_ELCTBL_CHC_INFO	22	Electable choice information created during batch run.
BEN_BATCH_ELIG_INFO	15	Eligibility information created during batch run.
BEN_BATCH_LER_INFO	25	Life event information created during batch run.
BEN_BATCH_PARAMETER	12	Parameters of Batch run.
BEN_BATCH_PROC_INFO	19	Batch process information.
BEN_BATCH_RANGES	11	Ranges of Person actions in batch run.
BEN_BATCH_RATE_INFO	28	Rate information created during batch run.
BEN_BENEFIT_ACTIONS	108	Run parameters for benefits batch processes.
BEN_BENFTS_GRP	41	Grouping item that can be applied to participants to enable them to be eligible for the same benefits.
BEN_BENFTS_GRP_RT_F	45	Rate for a benefits group.
BEN_BNFTS_BAL_F	46	Balance for a participant for a third paty vendor.
BEN_BNFTS_BAL_F_EFC	5	This is a copy of the BEN_BNFTS_BAL_F table which is populated by the EFC (Euro as a Functional Currency) process.
BEN_BNFT_POOL_RLOVR_RQMT_F	62	Which benefit polls can be rolled over into which compensation objects.
BEN_BNFT_POOL_RLOVR_RQMT_F_EFC	9	This is a copy of the BEN_BNFT_POOL_RLOVR_RQMT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_BNFT_PRVDD_LDGR_F	63	Benefit pool ledger for a participant
BEN_BNFT_PRVDD_LDGR_F_EFC	21	This is a copy of the BEN_BNFT_PRVDD_LDGR_F table which is popul;ated by the EFC(Euro as Functional Currency) process.
BEN_BNFT_PRVDD_LDGR_F_RBV	65
BEN_BNFT_PRVDR_POOL_F	74	The Benefit Pool.
BEN_BNFT_PRVDR_POOL_F_EFC	7	This is a copy of the BEN_BNFT_PRVDR_POOL_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_BNFT_RSTRN_CTFN_F	45	Certifications that are required to meet level restrictions for a compensation object.
BEN_BNFT_VRBL_RT_F	44	Variable rate for a benefit.
BEN_BNFT_VRBL_RT_RL_F	44	Variable rate rule for a benefit.
BEN_BRGNG_UNIT_RT_F	45	Rate for a bargaining unit.
BEN_CALC_CONDITIONS	7
BEN_CALC_DEFINITIONS	8
BEN_CALC_EQUATIONS	13
BEN_CBR_PER_IN_LER	44	Life event which may make participant eligible for COBRA (US)
BEN_CBR_PER_IN_LER_RBV	46	Cobra person Life Event RBV.
BEN_CBR_QUALD_BNF	49	Participants who have experienced COBRA (US) life event.
BEN_CBR_QUALD_BNF_RBV	50	Cobra Qualified Beneficiaries RBV.
BEN_CBR_QUALD_BNF_RT_F	46	Rate for a COBRA qualifed benficiary.
BEN_CLPSE_LF_EVT_F	67	Life event to use if a number of life events occur on the same date.
BEN_CMBN_AGE_LOS_FCTR	45	Combination age and length of service factor.
BEN_CMBN_AGE_LOS_RT_F	45	Rate to use for combintion age and length of service factor.
BEN_CMBN_PLIP_F	43	Combination of plans in programs that may provide credits to enrolling participants.
BEN_CMBN_PTIP_F	43	Combination of plan types in programs that may provide credits to enrolling participants.
BEN_CMBN_PTIP_OPT_F	45	Combination of plan types in programs by option that may provide credits to enrolling participants.
BEN_CM_DLVRY_MED_TYP	43	Communication delivery medium type.
BEN_CM_DLVRY_MTHD_TYP	43	Communication delivery method type.
BEN_CM_TRGR	10	Communication trigger.
BEN_CM_TYP_F	57	Communication type
BEN_CM_TYP_F_TL	12	MLS for Communication types.
BEN_CM_TYP_TRGR_F	44	Type of communication trigger,
BEN_CM_TYP_USG_F	51	Usages of communication type.
BEN_CNTNG_PRTN_ELIG_PRFL_F	46	Continuing participation eligibility profile table.
BEN_CNTNG_PRTN_PRFL_RT_F	46	Rate for continuing participation.
BEN_CNTNU_PRTN_CTFN_TYP_F	46	Continuing participation certification type table.
BEN_COMPTNCY_RT_F	46	Rate attributable to a competency.
BEN_COMP_ASSET	41	Compensation asset , which funds one or more benefits.
BEN_COMP_LVL_ACTY_RT_F	44	Rate applied to compensation levels.
BEN_COMP_LVL_FCTR	60	Compensation level factor.
BEN_COMP_LVL_FCTR_EFC	5	This is a copy of the BEN_COMP_LVL_FCTR_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_COMP_LVL_RT_F	45	Compensatin level rate.
BEN_COMP_OBJ_CACHE	16	Compensation object cache, by run date.
BEN_COMP_OBJ_CACHE_ROW	23	Contents of compensation object cache.
BEN_CONTROL	7	Not Used.
BEN_COPY_ENTITY_RESULTS	313	Copy Entity Results transaction table for plan design wizard
BEN_CRT_ORDR	57	Court order.
BEN_CRT_ORDR_CVRD_PER	41	Participant covered by court order.
BEN_CRT_ORDR_EFC	4	This is a copy of the BEN_CRT_ORDR_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_CSR_ACTIVITIES	14	Service center representative activities table, defines behaviour of Service Center Form.
BEN_CSS_RLTD_PER_PER_IN_LER_F	44	Life event causes related person to have a life event.
BEN_CUSTOM_REGION_ITEMS	15	Custom Region Items
BEN_CVG_AMT_CALC_MTHD_F	69	Calculation method for coverage.
BEN_CVG_AMT_CALC_MTHD_F_EFC	13	This is a copy of the BEN_CVG_AMT_CALC_MTHD_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_CVRD_DPNT_CTFN_PRVDD_F	50	Certification provided for covered dependents.
BEN_CWB_AUDIT	26
BEN_CWB_GROUP_HRCHY	9	Group Hierarchy
BEN_CWB_HRCHY	9	Used to maintain the manager to employee relationships withing compensation workbench.
BEN_CWB_MATRIX	16	Compensation workbench matrix.
BEN_CWB_MATRIX_DTL	14	Compensation workbench matrix detail.
BEN_CWB_MGR_HRCHY	9	Manager Hierarchy
BEN_CWB_MGR_HRCHY_RBV	11	CWB Manager Hierarchy RBV.
BEN_CWB_PERSON_GROUPS	43	CWB Person Groups
BEN_CWB_PERSON_INFO	206	CWB Person Information
BEN_CWB_PERSON_RATES	57	CWB Person Rates
BEN_CWB_PERSON_TASKS	14	CWB Person Tasks
BEN_CWB_PL_DSGN	104	CWB Plan Design
BEN_CWB_REPORT_PARAMS	5	Report parameters.
BEN_CWB_RPT_DETAIL	165	BEN_CWB_RPT_DETAIL contains information about the persons processed in the compensation workbench post process run. It also contains informa
BEN_CWB_STOCK_OPTN_DTLS	62	The table stores the data obtained from an external source which is to be displayed in the modified History Page
BEN_CWB_SUMMARY	44	CWB Person Group Summary
BEN_CWB_WKSHT_GRP	45	Worksheet Group
BEN_DED_SCHED_PY_FREQ	42	Pay frequency for deduction schedule.
BEN_DPNT_CVG_ELIGY_PRFL_F	56	Dependent coverage eligibility profile.
BEN_DPNT_CVG_RQD_RLSHP_F	47	Required reletionship for covered dependents.
BEN_DPNT_CVRD_ANTHR_OIPL_CVG_F	46	Dependent covered in another option in plan.
BEN_DPNT_CVRD_ANTHR_PL_CVG_F	46	Dependent covered in another plan.
BEN_DPNT_CVRD_OTHR_PGM_RT_F	47	Rate applicable for dependent covered in another program.
BEN_DPNT_CVRD_OTHR_PL_RT_F	46	Rate applicable for dependent covered in another plan.
BEN_DPNT_CVRD_OTHR_PTIP_RT_F	47	Rate applicable for dependent covered in another plan type in a program.
BEN_DPNT_CVRD_PLIP_RT_F	46	Rate applicable for dependent covered in another plan in the program.
BEN_DPNT_OTHR_PTIP_RT_F	45	Rate applicable for dependent in another plan type in program.
BEN_DRVBL_FCTR_UOM	46
BEN_DSBLD_RT_F	45	Rates for Disability.
BEN_DSGNTR_ENRLD_CVG_F	43	Designator enrolled in plan.
BEN_DSGN_RQMT_F	51	Requirements to designate.
BEN_DSGN_RQMT_RLSHP_TYP	41	Required relationship type to designate.
BEN_EE_STAT_RT_F	45	Rate for employee status,
BEN_EFC_EXCLUSIONS	15
BEN_ELCTBL_CHC_CTFN	49	Certifications needed for an electable choice.
BEN_ELCTBL_CHC_CTFN_RBV	49
BEN_ELIGY_CRITERIA	67	To hold the information about the new criteria defined by user (with a criteria_type = 'USER'), what is the valid list of values for the cri
BEN_ELIGY_CRIT_VALUES_F	60	Hold the Criteria Values and is child of BEN eligibility profile table
BEN_ELIGY_PRFL_F	111	Profile that defines the eligibility for a compensaton object.
BEN_ELIGY_PRFL_RL_F	47	Rule attached to profile that defines the eligibility for a compensaton object.
BEN_ELIG_AGE_CVG_F	48	Age requirements to cover dependents in a compensation object.
BEN_ELIG_AGE_PRTE_F	47	Identifies the age factors for inclusion/exclusion in compensation object
BEN_ELIG_ANTHR_PL_PRTE_F	45	Identifies the plan for inclusion/exclusion in compensation object.
BEN_ELIG_ASNT_SET_PRTE_F	47	Identifies the assignment sets for inclusion/exclusion in compensation object
BEN_ELIG_BENFTS_GRP_PRTE_F	47	Identifies the benefit groups for inclusion/exclusion in compensation object
BEN_ELIG_BRGNG_UNIT_PRTE_F	47	Identifies the bargaining units for inclusion/exclusion in compensation object
BEN_ELIG_CBR_QUALD_BNF_F	48	Identifies the COBRA qualified beneficiaries for inclusion/exclusion in compensation object
BEN_ELIG_CMBN_AGE_LOS_PRTE_F	48	Identifies the age and length of service combinations for inclusion/exclusion in compensation object
BEN_ELIG_COMPTNCY_PRTE_F	48	Identifies the competency for inclusion/exclusion in compensation object.
BEN_ELIG_COMP_LVL_PRTE_F	47	Identifies the compensation level for inclusion/exclusion in compensation object
BEN_ELIG_CVRD_DPNT_F	54	Eligible covered dependent.
BEN_ELIG_CVRD_DPNT_F_RBV	56
BEN_ELIG_DPNT	56	Eligible dependent.
BEN_ELIG_DPNT_CVRD_OTHR_OIPL_F	45	Dependent eligible if covered by another option in plan.
BEN_ELIG_DPNT_CVRD_OTHR_PGM_F	47	Dependent eligible if covered by another program.
BEN_ELIG_DPNT_CVRD_OTHR_PL_F	46	Dependent eligible if covered by another plan.
BEN_ELIG_DPNT_CVRD_OTHR_PTIP_F	47	Dependent eligible if covered by another plan type in a program.
BEN_ELIG_DPNT_CVRD_PLIP_F	46	Dependent eligible if covered by another plan in a program.
BEN_ELIG_DPNT_OTHR_PTIP_F	45	Dependent eligible if covered by another plan type in a program.
BEN_ELIG_DPNT_RBV	58
BEN_ELIG_DSBLD_PRTE_F	47	Identifies the disablity for inclusion/exclusion in compensation object.
BEN_ELIG_DSBLD_STAT_CVG_F	47	Identifies the disablity status for required to cover dependents in a compensation object.
BEN_ELIG_DSBLD_STAT_PRTE_F	45	Identifies the disablity status for inclusion/exclusion in compensation object
BEN_ELIG_DSBLTY_CTG_PRTE_F	47
BEN_ELIG_DSBLTY_DGR_PRTE_F	47
BEN_ELIG_DSBLTY_RSN_PRTE_F	47
BEN_ELIG_EE_STAT_PRTE_F	47	Identifies the employee status for inclusion/exclusion in compensation object
BEN_ELIG_ENRLD_ANTHR_OIPL_F	46	Participant eligible/ineligible if covered by another option in plan.
BEN_ELIG_ENRLD_ANTHR_PGM_F	46	Participant eligible/ineligible if covered by another program.
BEN_ELIG_ENRLD_ANTHR_PLIP_F	46	Participant eligible/ineligible if covered by another plan in program.
BEN_ELIG_ENRLD_ANTHR_PL_F	46	Participant eligible/ineligible if covered by another plan.
BEN_ELIG_ENRLD_ANTHR_PTIP_F	47	Participant eligible/ineligible if covered by another plan type in program.
BEN_ELIG_FL_TM_PT_TM_PRTE_F	47	Identifies the full time/part time status for inclusion/exclusion in compensation object
BEN_ELIG_GNDR_PRTE_F	47
BEN_ELIG_GRD_PRTE_F	47	Identifies the grade for inclusion/exclusion in compensation object
BEN_ELIG_HLTH_CVG_PRTE_F	46	Identifies the health coverage for inclusion/exclusion in compensation object.
BEN_ELIG_HRLY_SLRD_PRTE_F	47	Identifies the hourly or salaried value for inclusion/exclusion in compensation object
BEN_ELIG_HRS_WKD_PRTE_F	47	Identifies the hours worked for inclusion/exclusion in compensation object
BEN_ELIG_JOB_PRTE_F	47	Identifies the participants job required for inclusion/exclusion in compensation object
BEN_ELIG_LBR_MMBR_PRTE_F	47	Identifies the participants labor union status required for inclusion/exclusion in compensation object
BEN_ELIG_LGL_ENTY_PRTE_F	47	Identifies the participants legal entity required for inclusion/exclusion in compensation object
BEN_ELIG_LOA_RSN_PRTE_F	48	Identifies the participants leave of absence required for inclusion/exclusion in compensation object
BEN_ELIG_LOS_PRTE_F	47	Identifies the participants length of service required for inclusion/exclusion in compensation object
BEN_ELIG_LVG_RSN_PRTE_F	47	Identifies the participants leaving reason required for inclusion/exclusion in compensation object
BEN_ELIG_MLTRY_STAT_CVG_F	47	Identifies the dependents military status required for inclusion/exclusion in compensation object
BEN_ELIG_MLTRY_STAT_PRTE_F	7	Identifies the participants military status required for inclusion/exclusion in compensation object
BEN_ELIG_MRTL_STAT_CVG_F	47	Identifies the dependents marital status required for inclusion/exclusion in compensation object
BEN_ELIG_MRTL_STS_PRTE_F	46
BEN_ELIG_NO_OTHR_CVG_PRTE_F	43	Identifies the participants other coverages allowed for inclusion/exclusion in compensation object
BEN_ELIG_OBJ_ELIG_PROFL_F	34	Holds the eligibility profiles that are attached to a particular Object
BEN_ELIG_OBJ_F	13	Stores the Eligibility Object Definition
BEN_ELIG_OPTD_MDCR_PRTE_F	44	Whether the participant opted for medicare status requiredfor inclusion/exclusion in compensation object
BEN_ELIG_ORG_UNIT_PRTE_F	47	Identifies the participants organization unit required for inclusion/exclusion in compensation object
BEN_ELIG_OTHR_PTIP_PRTE_F	46	Identifies eligibilty in other plan types required for inclusion/exclusion in compensation object
BEN_ELIG_PCT_FL_TM_PRTE_F	47	Identifies the percentage of full/part time required for inclusion/exclusion in compensation object
BEN_ELIG_PERF_RTNG_PRTE_F	48	Identifies the health coverage for inclusion/exclusion in compensation object.
BEN_ELIG_PER_ELCTBL_CHC	97	Choices that partipant may elect.
BEN_ELIG_PER_ELCTBL_CHC_RBV	97
BEN_ELIG_PER_F	107	Participant is eligible.
BEN_ELIG_PER_F_EFC	8	This is a copy of the BEN_ELIG_PER_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ELIG_PER_F_RBV	109
BEN_ELIG_PER_OPT_F	94	Participants eligibility/ineligibility for an option in a plan.
BEN_ELIG_PER_OPT_F_EFC	8	This is a copy of the BEN_ELIG_PER_OPT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ELIG_PER_OPT_F_RBV	96
BEN_ELIG_PER_TYP_PRTE_F	48	Identifies the participants person type required for inclusion/exclusion in compensation object
BEN_ELIG_PER_WV_PL_TYP_F	46	Identifies the persons who have waived participation in a plan type.
BEN_ELIG_PPL_GRP_PRTE_F	47	Identifies the participants person type required for inclusion/exclusion in compensation object
BEN_ELIG_PRBTN_PERD_PRTE_F	48
BEN_ELIG_PRTT_ANTHR_PGM_F	45	Identifies which programs participation is required in for inclusion/exclusion in compensation object
BEN_ELIG_PRTT_ANTHR_PL_PRTE_F	45	Identifies which plans participation is required in for inclusion/exclusion in compensation object
BEN_ELIG_PSTL_CD_R_RNG_CVG_F	45	Postal or zip code range required to cover dependents in a compensation object.
BEN_ELIG_PSTL_CD_R_RNG_PRTE_F	47	Indentifies the postal code or range of codes required for inclusion/exclusion in compensation object.
BEN_ELIG_PSTN_PRTE_F	47
BEN_ELIG_PYRL_PRTE_F	47	Identifies the payroll required for inclusion/exclusion in compensation object
BEN_ELIG_PY_BSS_PRTE_F	47	Identifies the pay basis required for inclusion/exclusion in compensation object
BEN_ELIG_QUAL_TITL_PRTE_F	48
BEN_ELIG_QUA_IN_GR_PRTE_F	47	Identifies the quartile in grade for inclusion/exclusion in compensation object.
BEN_ELIG_RSLT_F	14	Stores Y/N result of Eligibility Evaluation
BEN_ELIG_SCHEDD_HRS_PRTE_F	54	Identifies the scheduled hours required for inclusion/exclusion in compensation object
BEN_ELIG_SCRE_WTG_F	17	Stores computed score for each eligibility criteria
BEN_ELIG_SP_CLNG_PRG_PRTE_F	47
BEN_ELIG_STDNT_STAT_CVG_F	47	Student status required to cover dependents in a compensation object.
BEN_ELIG_SUPPL_ROLE_PRTE_F	48
BEN_ELIG_SVC_AREA_PRTE_F	47	Identifies the service area required for inclusion/exclusion in compensation object
BEN_ELIG_TBCO_USE_PRTE_F	47	Identifies the tobacco usage for inclusion/exclusion in compensation object.
BEN_ELIG_TO_PRTE_RSN_F	67	The life event reason which may cause immediate inclusion/exclusion from a compensation object.
BEN_ELIG_TTL_CVG_VOL_PRTE_F	50	Identifies the total coverage for inclusion/exclusion in compensation object.
BEN_ELIG_TTL_PRTT_PRTE_F	50	Identifies the total participation for inclusion/exclusion in compensation object.
BEN_ELIG_WK_LOC_PRTE_F	47	Identifies the work location required for inclusion/exclusion in compensation object
BEN_ELP_EXTRA_INFO	65	Eligibility Extra Information.
BEN_ELP_INFO_TYPES	15	Eligibility Informaton Types.
BEN_ENRLD_ANTHR_OIPL_RT_F	46	Rate attributable if participant enrolls in associated plan.
BEN_ENRLD_ANTHR_PGM_RT_F	46	Rate attributable if participant enrolls in associated program.
BEN_ENRLD_ANTHR_PLIP_RT_F	46	Rate attributable if participant enrolls in associated plan in program.
BEN_ENRLD_ANTHR_PL_RT_F	46	Rate attributable if participant enrolls in associated plan.
BEN_ENRLD_ANTHR_PTIP_RT_F	47	Rate attributable if participant enrolls in associated plan type in a program.
BEN_ENRT_BNFT	64	Enrollment Benefit.
BEN_ENRT_BNFT_EFC	10	This is a copy of the BEN_ENRT_BNFT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ENRT_BNFT_RBV	66
BEN_ENRT_CTFN_F	47	Enrollment certification
BEN_ENRT_ENRLD_ANTHR_OIPL_F	46	Options in plans a participant will be enrolled in if they elect associated option
BEN_ENRT_ENRLD_ANTHR_PL_F	46	Plans a participant will be enrolled in if they elect associated plan.
BEN_ENRT_PERD	83	Enrollment Period
BEN_ENRT_PERD_FOR_PL_F	52	Enrollment Period for plan.
BEN_ENRT_PREM	48	Enrollment premium.
BEN_ENRT_PREM_EFC	4	This is a copy of the BEN_ENRT_PREM_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ENRT_PREM_RBV	50
BEN_ENRT_RT	94	Enrollment Rate.
BEN_ENRT_RT_CTFN	46	Certification required for enrollment rate.
BEN_ENRT_RT_EFC	20	This is a copy of the BEN_ENRT_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_ENRT_RT_RBV	94
BEN_EXTRA_INPUT_VALUES	44	Extra input values associated with a standard rate.
BEN_EXT_CHG_EVT_LOG	35	Extract change event log.
BEN_EXT_CRIT_CMBN	15	Extract criteria combination.
BEN_EXT_CRIT_PRFL	43	Extract criteria profile.
BEN_EXT_CRIT_TYP	13	Extract Criteria type.
BEN_EXT_CRIT_VAL	14	Extract Criteria value.
BEN_EXT_DATA_ELMT	57	Extract data element.
BEN_EXT_DATA_ELMT_DECD	14	Extract data element decoded.
BEN_EXT_DATA_ELMT_IN_RCD	19	Extract data element in record.
BEN_EXT_DFN	63	Extract definition.
BEN_EXT_FILE	46	Extract file.
BEN_EXT_FLD	18	Extract field.
BEN_EXT_FLD_TL	10	MLS translated Extract field.
BEN_EXT_INCL_CHG	14	Extract ichanges inclusion criteria.
BEN_EXT_INCL_DATA_ELMT	12	<>
BEN_EXT_RCD	45	Extract record.
BEN_EXT_RCD_IN_FILE	22	Extract record in file.
BEN_EXT_RSLT	26	Extract result.
BEN_EXT_RSLT_DTL	324	Extract result detail
BEN_EXT_RSLT_ERR	17	Errors encountered during an extract.
BEN_EXT_WHERE_CLAUSE	19	Where clause for extract.
BEN_FL_TM_PT_TM_RT_F	45	Rates applicable to full time/part time assignment,
BEN_GD_OR_SVC_TYP	42	Type of service or goods.
BEN_GNDR_RT_F	45	Rate applicable to gender.
BEN_GRADE_RT_F	45	Rate applicable to grade.
BEN_HRLY_SLRD_RT_F	45	Rate applicable to Hourly or Salaried workers.
BEN_HRS_WKD_IN_PERD_FCTR	56	Hours worked in a period factor.
BEN_HRS_WKD_IN_PERD_RT_F	45	Rate applicable to hours worked.
BEN_ICD_CHC_RATES	60
BEN_ICD_SS_CONFIG	8
BEN_ICD_TRANSACTION	126
BEN_JOB_RT_F	45	Rate Applicable to Job
BEN_LBR_MMBR_RT_F	45	Rate applicable to labor union membership.
BEN_LEE_RSN_F	67	Life event enrollment reason.
BEN_LEE_RSN_RL_F	44	Life event enrollment reason rule.
BEN_LER_BNFT_RSTRN_CTFN_F	45	Certifications required as a result of life event enrollment.
BEN_LER_BNFT_RSTRN_F	63	Restrictions imposed as a result of life event enrollment.
BEN_LER_BNFT_RSTRN_F_EFC	11	This is a copy of the BEN_LER_BNFT_RSTRN_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_LER_CHG_DPNT_CVG_CTFN_F	47	Certifications that are required for a participant to enroll/denroll dependents.
BEN_LER_CHG_DPNT_CVG_F	54	Valid life events that allow a participant to enroll/denroll dependents.
BEN_LER_CHG_OIPL_ENRT_F	52	Determines option in plan enrollment for a life event.
BEN_LER_CHG_OIPL_ENRT_RL_F	44	Rule used to determine option in plan enrollment for a life event.
BEN_LER_CHG_PGM_ENRT_F	51	Determines program enrollment for a life event.
BEN_LER_CHG_PLIP_ENRT_F	53	Determines plan in program enrollment for a life event.
BEN_LER_CHG_PLIP_ENRT_RL_F	44	Rule used to determine plan in program enrollment for a life event.
BEN_LER_CHG_PL_NIP_ENRT_F	53	Determine plan not in a program enrollment for a life event.
BEN_LER_CHG_PL_NIP_RL_F	44	Rule used to determine plan not in a program enrollment for a life event.
BEN_LER_CHG_PTIP_ENRT_F	52	Determine plan type in program enrollment for a life event.
BEN_LER_ENRT_CTFN_F	45	Life event enrollment certification.
BEN_LER_EXTRA_INFO	65	Life Event Reasons Extra Information.
BEN_LER_F	62	Life event reason
BEN_LER_F_TL	12	Mls Translated Life event reason.
BEN_LER_INFO_TYPES	15	Life Event Reasons Information Types.
BEN_LER_PER_INFO_CS_LER_F	45	Data changes required to trigger life event detection for a participant.
BEN_LER_RLTD_PER_CS_LER_F	45	Data changes required to trigger life event detection related person.
BEN_LER_RQRS_ENRT_CTFN_F	49	Idenities those certifications required if a person experiences a life event.
BEN_LE_CLSN_N_RSTR	185	Life event collision or restrictions.
BEN_LE_CLSN_N_RSTR_EFC	13	This is a copy of the BEN_LE_CLSN_N_RSTR table which is populated by the EFC(Euro as Functional Currency) process.
BEN_LGL_ENTY_RT_F	45	Rate for legal entity.
BEN_LOA_RSN_RT_F	47	Rate for leave of Absence reason.
BEN_LOS_FCTR	55	Leave of service factor.
BEN_LOS_RT_F	45	Length of service rate.
BEN_LVG_RSN_RT_F	45	Rate attributable to a leaving reason.
BEN_MTCHG_RT_F	56	Matching rate
BEN_MTCHG_RT_F_EFC	9	This is a copy of the BEN_MTCHG_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_NO_OTHR_CVG_RT_F	43	Rate attributable if no other coverage exists.
BEN_OIPLIP_F	45	Option in plan in program.
BEN_OIPL_F	79	Option in plan
BEN_ONLINE_WARNINGS	2	Online warnings.
BEN_OPTD_MDCR_RT_F	44	Rate attributable if participant has opted for medicare.
BEN_OPTIP_F	48	Option in plan type in program
BEN_OPT_EXTRA_INFO	65	Options Extra Information.
BEN_OPT_F	55	Option.
BEN_OPT_INFO_TYPES	15	Options Information Types.
BEN_ORG_UNIT_PRDCT_F	43	Profucts provided by an organization.
BEN_ORG_UNIT_RT_F	45	Rate applicable to work organization.
BEN_OTHR_PTIP_RT_F	46	Rate attributable if participant in another plan type.
BEN_PAIRD_RT_F	56	Paired rate.
BEN_PAIRD_RT_F_EFC	8	This is a copy of the BEN_PAIRD_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PCT_FL_TM_FCTR	48	Percentage of full time factor.
BEN_PCT_FL_TM_RT_F	45	Rate appled to percentage of full time.
BEN_PERD_TO_PROC	43	<>
BEN_PERF_RTNG_RT_F	46	Rate attributable to performance rating.
BEN_PERSON_ACTIONS	8	Identifies persons being processed by benefits batch process.
BEN_PERSON_ACTION_ITEMS	18
BEN_PER_BNFTS_BAL_F	44	Benefits balance for a person.
BEN_PER_BNFTS_BAL_F_EFC	6	This is a copy of the BEN_PER_BNFTS_BAL_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PER_CM_F	54	Communications creates to person as result of communications trigger firing.
BEN_PER_CM_F_RBV	56
BEN_PER_CM_PRVDD_F	58	Communications that must be provided for a life event.
BEN_PER_CM_TRGR_F	47	Data that fires communication trigger.
BEN_PER_CM_USG_F	47	Communication usages for a person,
BEN_PER_DLVRY_MTHD_F	44	Preferred delivery method for a person.
BEN_PER_INFO_CHG_CS_LER_F	49	Table and column level data for administering life event triggers
BEN_PER_IN_LER	62	Person having a life event.
BEN_PER_IN_LER_RBV	58	Shadow table for ben_per_in_ler
BEN_PER_IN_LGL_ENTY_F	45	Person is a member of a legal entity.
BEN_PER_IN_ORG_ROLE_F	42	Person has a specified role in an organization.
BEN_PER_IN_ORG_UNIT_F	43	Person belongs to an organization.
BEN_PER_PIN_F	45	Pin numbers for a person.
BEN_PER_TYP_RT_F	46	Rates applicable to person types.
BEN_PGM_DPNT_CVG_CTFN_F	48	Certifications required for a participant to enroll/denroll dependents from a program
BEN_PGM_EXTRA_INFO	65	Program Extra Information.
BEN_PGM_F	116	The benefit program.
BEN_PGM_F_EFC	5	This is a copy of the BEN_PGM_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PGM_INFO_TYPES	16	Program Information Types.
BEN_PIL_ELCTBL_CHC_POPL	83	The electable choice a person may have for a program or plan due to a life event.
BEN_PIL_EPE_POPL_RBV	75
BEN_PIN	39	List of numbers available to be used as an indentificaion method .
BEN_PLIP_F	100	Incedence of a plan in a program.
BEN_PLIP_F_EFC	10	This is a copy of the BEN_PLIP_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PL_BNF_CTFN_F	49	Certifcations required by designate beneficiary on a plan.
BEN_PL_BNF_CTFN_PRVDD_F	50	Certifcations provided by person to designate beneficiary on a plan.
BEN_PL_BNF_F	57	Entity designated as plan beneficiary.
BEN_PL_BNF_F_EFC	6	This is a copy of the BEN_PL_BNF_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PL_DPNT_CVG_CTFN_F	52	Certifications required for a participant to enroll/denroll dependents from a plan.
BEN_PL_EXTRACT_IDENTIFIER_F	22	The ANSI 834 extract delivered by Oracle allows customers to send their enrollment changes to their Plan providers. Some plan providers allo
BEN_PL_EXTRA_INFO	65	Plan Extra Information.
BEN_PL_F	202	Plan
BEN_PL_FRFS_VAL_F	53	Plan Forfeiture Values
BEN_PL_F_EFC	15	This is a copy of the BEN_PL_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PL_GD_OR_SVC_F	48	Goods or services that may be reimbursable by a plan
BEN_PL_GD_R_SVC_CTFN_F	48	Cersifications required to reimburse goods or services for a plan.
BEN_PL_INFO_TYPES	16	Plan Information Types.
BEN_PL_PCP	50	Primary care practitioner for a plan.
BEN_PL_PCP_TYP	44	Type of Primary care practitioner.
BEN_PL_REGN_F	50	Legislative regulations plan must adhere to.
BEN_PL_REGY_BOD_F	48	Regulatory body that oversees plan.
BEN_PL_REGY_PRP_F	43	Purpose of the Plan regulatory body.
BEN_PL_R_OIPL_ASSET_F	49	Assets held by plan on option in plan.
BEN_PL_R_OIPL_ASSET_F_EFC	6	This is a copy of the BEN_PL_R_OIPL_ASSET_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PL_R_OIPL_PREM_BY_MO_F	53	Total premium owed to plan or option in plan sponsor per month
BEN_PL_R_OIPL_PREM_BY_MO_F_EFC	6	This is a copy of the BEN_PL_R_OIPL_PREM_BY_MO_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PL_TYP_F	56	Plan type.
BEN_PL_TYP_OPT_TYP_F	46	Plan type, option type.
BEN_POE_RT_F	50	Period of enrollment rate.
BEN_POPL_ACTN_TYP_F	48	Time allowed to respond to action type.
BEN_POPL_ENRT_TYP_CYCL_F	44	Enrollment cycle allowed for program or plan.
BEN_POPL_ORG_F	47	Program or plan organization.
BEN_POPL_ORG_ROLE_F	44	Program or plan organization role.
BEN_POPL_RPTG_GRP_F	45	Program or plan reporting group.
BEN_POPL_YR_PERD	45	Program or plan yer period.
BEN_POP_UP_MESSAGES	19	Pop-up messages, user defined.
BEN_PPL_GRP_RT_F	45	Rates applicable to a people group.
BEN_PREM_CSTG_BY_SGMT_F	45	Costing segment for transfer to GL.
BEN_PRMRY_CARE_PRVDR_F	50	Primary car provider details.
BEN_PRTL_MO_RT_PRTN_VAL_F	53	Pro-ration values for partial month enrollments.
BEN_PRTN_ELIGY_RL_F	46	Rule which enforces eligibility of participant.
BEN_PRTN_ELIG_F	62	Eligibility criteria for a compensation object.
BEN_PRTN_ELIG_PRFL_F	46	Profiles which build up eligibility criteria.
BEN_PRTT_ANTHR_PL_RT_F	45	Rate attributable to participation in another plan.
BEN_PRTT_ASSOCD_INSTN_F	44	Reimbursement and other processing instructions.
BEN_PRTT_CLM_GD_OR_SVC_TYP	42	Participants claim for goods or service types.
BEN_PRTT_ENRT_ACTN_F	53	Participants outstanding enrollment actions.
BEN_PRTT_ENRT_CTFN_PRVDD_F	52	Certifications provided for enrollment.
BEN_PRTT_ENRT_RSLT_F	77	Compensation objects that participant is enrolled in.
BEN_PRTT_ENRT_RSLT_F_EFC	8	This is a copy of the BEN_PRTT_ENRT_RSLT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PRTT_ENRT_RSLT_F_RBV	79
BEN_PRTT_PREM_BY_MO_F	57	Premium owed to plan carrier on a monthly basis per participant.
BEN_PRTT_PREM_BY_MO_F_EFC	9	Pre-conversion premium owed to plan carrier on a monthly basis.
BEN_PRTT_PREM_F	50	Premium calculated for enrollment in compencsation object for participant.
BEN_PRTT_PREM_F_EFC	6	This is a copy of the BEN_PRTT_PREM_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PRTT_REIMBMT_RECON	44	Out of scope
BEN_PRTT_REIMBMT_RQST_F	78	Participants re-imbursement request.
BEN_PRTT_REIMBMT_RQST_F_EFC	10	This is a copy of the BEN_PRTT_REIMBMT_RQST_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PRTT_RMT_APRVD_FR_PYMT_F	50	Prtt Rmt Aprvd Fr Pymt
BEN_PRTT_RMT_RQST_CTFN_PRVDD_F	48	Reimbursement request certifcations provided.
BEN_PRTT_RT_VAL	70	Rate for participant enrolled in compensation object.
BEN_PRTT_RT_VAL_CTFN_PRVDD	48	Certification provided for participation.
BEN_PRTT_RT_VAL_EFC	7	This is a copy of the BEN_PRTT_RT_VAL table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PRTT_RT_VAL_RBV	68
BEN_PRTT_VSTG_F	49	Percentages vested by participant in compensation object.
BEN_PSTL_ZIP_RNG_F	43	Range of postal codes.
BEN_PSTL_ZIP_RT_F	45	Rates applicable to a postal code.
BEN_PSTN_RT_F	45	Rates applicable to a position.
BEN_PTD_BAL_TYP_F	45	Balance period to date.
BEN_PTD_BAL_TYP_F_EFC	7	This is a copy of the BEN_PTD_BAL_TYP_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PTD_LMT_F	49	Cumulative period to date limits contibuted or distributed.
BEN_PTD_LMT_F_EFC	7	This is a copy of the BEN_PTD_LMT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PTIP_DPNT_CVG_CTFN_F	48	Certifications required for a participant to enroll/denroll dependents from a plan type in program.
BEN_PTIP_F	109	Plan type in program table
BEN_PTIP_F_EFC	6	This is a copy of the BEN_PTIP_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_PTNL_LER_FOR_PER	27	Participant potential life event.
BEN_PTNL_LER_FOR_PER_RBV	28	Plan Information Types.
BEN_PYMT_CHECK_DET	43	Cobra Payment Check Details
BEN_PYMT_SCHED_PY_FREQ	42	Frequency of payment scheduls.
BEN_PYRL_RT_F	45	Rates applicable to a payroll.
BEN_PY_BSS_RT_F	45	Rates applicable to a pay basis.
BEN_QUAL_TITL_RT_F	46	Rate attributable to qualified title.
BEN_QUA_IN_GR_RT_F	45	Rate attributable to quartile in grade.
BEN_REGN_F	44	Regulations.
BEN_REGN_FOR_REGY_BODY_F	44	Regulations overseen by regulatory bodies.
BEN_REGN_F_TL	12	MLS translation of regulatory bodies.
BEN_REPORTING	27	Batch reporting table.
BEN_RLTD_PER_CHG_CS_LER_F	49	Related person life evant causes participant life event.
BEN_ROLLUP_RBV_SUMMARY	11
BEN_ROLL_REIMB_RQST	42	Rollover reimbursement table.
BEN_ROUND_CODE_VALUES_EFC	7	Contains Rounding code values prior to conversion which are modified by the EFC (Euro as Functional Currency) Process.
BEN_RPTG_GRP	45	Reporting group.
BEN_RPTG_GRP_TL	10	MLS translation of Reporting Groups.
BEN_SCHEDD_ENRT_RL_F	44	Sheduled enrollment rule.
BEN_SCHEDD_HRS_RT_F	52	Rates applicable to a scheduled hours.
BEN_STARTUP_ACTN_TYP	9	Seeded action types.
BEN_STARTUP_ACTN_TYP_TL	11	MLS translated seeded action types.
BEN_STARTUP_CM_TYP	13	Seeded communication types.
BEN_STARTUP_CM_TYP_TL	10	MLS translated seeded communication types.
BEN_STARTUP_LERS	8	Seeded life event reasons.
BEN_STARTUP_LERS_TL	10	MLS translated seeded life event reasons.
BEN_STARTUP_REGN	9	Seeded Regulations
BEN_STARTUP_REGN_TL	10	MLS translated seeded Regulations
BEN_SVC_AREA_F	43	Service area.
BEN_SVC_AREA_PSTL_ZIP_RNG_F	43	Service area's postal code ranges.
BEN_SVC_AREA_RT_F	45	Rates applicable to a service area.
BEN_TBCO_USE_RT_F	45	Rates applicable to the use of tobacco.
BEN_TCS_ALL_OBJECTS_IN_CAT	13	BEN_TCS_ALL_OBJECTS_IN_CAT identifies the relations ship between compensation category, sub-category and also between compensation category
BEN_TCS_ASG_STMT	13	BEN_TCS_ASG_STMT identifies the statements for an assignment for a person and for a period.
BEN_TCS_CAT	18	BEN_TCS_CAT identifies a compensation category.
BEN_TCS_CAT_ITEM_HRCHY	8	BEN_TCS_CAT_ITEM_HRCHY identifies the hierarchical relationship between the compensation items and the comepensation categories.
BEN_TCS_CAT_LINK	11	BEN_TCS_CAT_LINK identifies the links in the links container.
BEN_TCS_CAT_SUBCAT_HRCHY	6	This is a hierarchy table for navigating the sub-categories with in a category
BEN_TCS_COL_IN_CAT	13	BEN_TCS_COL_IN_CAT identifies the columns to be displayed in the category.
BEN_TCS_ITEM	15	BEN_TCS_ITEM identifies the compensation item
BEN_TCS_PER_ITEM	15	BEN_TCS_PER_ITEM identifies the compensation item for a person
BEN_TCS_PER_ITEM_VALUE	17	BEN_TCS_PER_ITEM_VALUE identifies the values for a compensation item
BEN_TCS_PER_STMT_PERD	12	BEN_TCS_PER_STMT_PERD identifies the statement for a period for a person.
BEN_TCS_REPORT_DETAILS	18	BEN_TCS_REPORT_DETAILS identifies the Statment Generation request's details
BEN_TCS_ROW_IN_CAT	12	BEN_TCS_ROW_IN_CAT identifies the rows in the compensation category.
BEN_TCS_STMT	20	BEN_TCS_STMT identifies a compensation structure. Statement is composed of compensation categories and compensation items.
BEN_TCS_STMT_CAT	12	BEN_TCS_STMT_CAT identifies all the compensation categories present with in a statement.
BEN_TCS_STMT_PERD	14	BEN_TCS_STMT_PERD identifies an employee statement for a given period.
BEN_TCS_STMT_TASK	11	BEN_TCS_STMT_TASK identifies the task for a statement.
BEN_TRANSACTION	43
BEN_TTL_CVG_VOL_RT_F	50	Total coverage volume for all the participants covered.
BEN_TTL_CVG_VOL_RT_F_EFC	8	This is a copy of the BEN_TTL_CVG_VOL_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_TTL_PRTT_RT_F	50	Maximum and minimum allowed enrolled participants in a compensation object.
BEN_VALD_RLSHP_FOR_REIMB_F	43	Valid relationship types for partipant to claim reimbursement for contacts expenses incurred.
BEN_VRBL_MTCHG_RT_F	55	Rate that is applied based on matching contribution of participant.
BEN_VRBL_MTCHG_RT_F_EFC	9	This is a copy of the BEN_VRBL_MTCHG_RT_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_VRBL_RT_ELIG_PRFL_F	44	Intersection table of Variable rate Profile and Eligibility Profile tables.
BEN_VRBL_RT_PRFL_F	136	Variable rate profile.
BEN_VRBL_RT_PRFL_F_EFC	17	This is a copy of the BEN_VRBL_RT_PRFL_F table which is populated by the EFC(Euro as Functional Currency) process.
BEN_VRBL_RT_PRFL_RL_F	45	Variable rate profile rule.
BEN_VRBL_RT_RL_F	46	Variable rate rule.
BEN_VSTG_AGE_RQMT	46	Age ranges used for vesting values for a rate.
BEN_VSTG_FOR_ACTY_RT_F	48	Vesting schedules for rate.
BEN_VSTG_LOS_RQMT	47	Length of service ranges used for vesting values for a rate.
BEN_VSTG_SCHED_F	46	The periods in which a participant vests.
BEN_WK_LOC_RT_F	45	Rate applicable to work location.
BEN_WTHN_YR_PERD	45	Within year period.
BEN_WV_PRTN_RSN_CTFN_PL_F	47	Certifications required if a person waives plan coverage.
BEN_WV_PRTN_RSN_CTFN_PTIP_F	48	Certifications required if a person waives plan type in program coverage.
BEN_WV_PRTN_RSN_PL_F	44	Valid reasons in which a person may waive plan coverage.
BEN_WV_PRTN_RSN_PTIP_F	44	Valid reasons in which a person may waive plan type in program coverage.
BEN_YR_PERD	46	Start and End periods.