Benefit Formula Types
Contexts:
|
Formula
Type Name
|
Context
Base Name
|
Context
Name
|
|
Coverage Amount Limit
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BNFTS_BAL_ID
|
Benefit Balance
|
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
Coverage Lower Limit
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BNFTS_BAL_ID
|
Benefit Balance
|
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
ELIG_PER_ELCTBL_CHC_ID
|
Electable Choice
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Coverage Non-discriminatory
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
|
|
|
|
Coverage Sequence Limit
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Coverage Upper Limit
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BNFTS_BAL_ID
|
Benefit Balance
|
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
ELIG_PER_ELCTBL_CHC_ID
|
Electable Choice
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Deduction Schedule
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
|
|
|
|
Default Enrollment
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
ELIG_PER_ID
|
Eligible Person
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Default to Assign Pending Action
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Dependent Certification Required
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
ELIG_PER_ELCTBL_CHC_ID
|
Electable Choice
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Dependent Coverage End Date
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_ID
|
Payroll
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Dependent Coverage Start Date
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_ID
|
Payroll
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Dependent Eligibility
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Election Value Range Rule
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
Element Type and Input Value Determination
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
ELIG_PER_ELCTBL_CHC_ID
|
Electable Choice
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
HR_RELATIONSHIP_ID
|
HR Relationship
|
|
|
HR_TERM_ID
|
HR Term
|
|
|
JOB_ID
|
Job
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
OPT_ID
|
Option
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
No comments:
Post a Comment