Appendix 1: Contexts
Table below describes the different Benefits formula types available in Oracle Fusion V1, where they can be located in UI, and the various contexts available for each formula type. Please note that a lot of formula types which are available at the plan level would also be available at other levels like program, plan in program etc.
| FORMULA_TYPE_NAME | NAVIGATION DETAILS | CONTEXT_NAME |
|---|---|---|
| Action Type Due Date | Plan Configuration > Benefit Plan Details> Certification train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Age Calculation | Plan Configuration > Manage Derived Factors > Age tab | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Age Determination Date | Plan Configuration > Derived Factors > Age tab | BNFTS_BAL_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Automatic Enrollment Method | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Beneficiary Certification Required | Plan Configuration > Benefit Plan Details > Dependent/ Beneficiary train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Change Dependent Coverage | Plan Configuration > BenefitPlan Details > Dependent/ Beneficiary train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Compensation Calculation | Plan Configuration > Derived Factors > Compensation tab | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Compensation Determination Date | Plan Configuration > Derived Factors > Compensation tab | BNFTS_BAL_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PAYROLL_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Compensation Object Selection | Evaluation and Reporting > Processes> Evaluate Life Event Participation > Comp object selection parameter | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Coverage Amount Calculation | Plan Configuration > Benefit Plan coverage | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Coverage Lower Limit | Plan Configuration > Benefit Plan Coverage | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Default Enrollment | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Default to Assign Pending Action | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Dependent Certification Required | Plan Configuration > Benefit Plan Details > Dependent / beneficiary train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Dependent Coverage End Date | Plan Configuration > Benefit Plan Details > Dependent / beneficiary train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Dependent Eligibility | Plan Configuration > Benefit Plan Details > Dependent / beneficiary train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Element Type and Input Value Determination | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Eligibility Access Calculation Rule | Plan Configuration > Eligibility Profiles | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment Certification Required | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| ENRT_CTFN_TYP_CD | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment Coverage Start Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment End | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment Opportunity | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment Period End Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Enrollment Period Start Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Evaluate Life Event | Plan Configuration > Benefit Life Events | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| Extra Input | Plan Configuration > Manage Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Family Member Determination | Plan Configuration > Benefit Plan Details > Eligibility train stop | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Hours Worked Calculation | Plan Configuration > Derived Factors > Hours worked tab | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Hours Worked Determination Date | Plan Configuration > Derived Factors > Hours worked tab | BNFTS_BAL_ID |
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PAYROLL_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Length of Service Calculation | Plan Configuration > Derived Factors > Length of Service tab | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Length of Service Date to Use | Plan Configuration > Derived Factors > Length of Service tab | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Length of Service Determination Date | Plan Configuration > Derived Factors > Length of Service tab | BNFTS_BAL_ID |
| BUSINESS_GROUP_ID (ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Life Event Reason Timeliness | Plan Configuration > Benefit Life Events | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| PERSON_ID | ||
| Maximum Coverage Amount Calculation | Plan Configuration > Benefit Plan Coverage | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Maximum Period of Enrollment | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Maximum Period of Enrollment Determination Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Maximum Waiting Period Date to Use | Plan Configuration > Benefit Plan Details > Eligibility train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Minimum Coverage Amount Calculation | Plan Configuration > Benefit Plan Coverage | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Partial Month Effective Date Determination | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Partial Month Proration Method | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Partial Month Proration Rule | Plan Configuration > Manage Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Participation Eligibility End Date | Plan Configuration > Benefit Plan Details > Eligibility train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Participation Eligibility Start | Plan Configuration > Benefit Plan Details > Eligibility train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Participation and Rate Eligibility | Plan Configuration > Eligibility Profiles | BUSINESS_GROUP_ID (ENTERPRISE_ID) |
| DATE_EARNED | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PAYROLL_ASSIGNMENT_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Payment Schedule | Plan Configuration > Benefit Rates | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Person Change Causes Life Event | Plan Configuration > Benefit Life Events | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| Person Selection | Evaluation and Reporting > Submit any process > Person selection parameter | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Postelection Edit | Plan Configuration > Benefit Plans > Enrollment train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| Prorate Annual Election Value | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Range of Scheduled Hours | Range of Scheduled Hours Profiles | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate End Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate Lower Limit | Plan Configuration > Benefit Rates | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate Periodization | Plan Configuration > Benefit Rates | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate Start Date | Plan Configuration > Benefit Plan Details > Enrollment train stop | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate Upper Limit | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Rate Value Calculation | Plan Configuration > Benefit Rates | ACTY_BASE_RT_ID |
| BUSINESS_GROUP_ID ( ENTERPRISE_ID) | ||
| EFFECTIVE_DATE | ||
| ELIG_PER_ELCTBL_CHC_ID | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Related Person Change Causes Life Event | Plan Configuration > Benefit Life Events | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| Required Period of Enrollment | Plan Configuration > Benefit Plan Details > Enrollment train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Waiting Period Value and UOM | Plan Configuration > Benefit Plan Details > Additional Details train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID | ||
| Waive Certification Required | Plan Configuration > Benefit Plan Details > Certification train stop | BUSINESS_GROUP_ID ( ENTERPRISE_ID) |
| EFFECTIVE_DATE | ||
| HR_ASSIGNMENT_ID | ||
| LER_ID | ||
| OPT_ID | ||
| ORGANIZATION_ID | ||
| PERSON_ID | ||
| PGM_ID | ||
| PL_ID | ||
| PL_TYP_ID |