Benefit Formula Types
Contexts:
Formula Type Base Name
|
Contxt Base Name
|
Context Name
|
Action Type Due Date
|
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
|
|
Age Calculation
|
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
|
|
Age Determination Date
|
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_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
|
|
Automatic Enrollment Method
|
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
|
|
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
|
|
Beneficiary Certification Required
|
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
|
|
Benefits Extract Custom Data Rule
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
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
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
PGM_ID
|
Program
|
|
PL_ID
|
Plan
|
|
PL_TYP_ID
|
Plan Type
|
|
Break In Service
|
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
|
|
Break In Service Value
|
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
|
|
Certification Allow Reimbursement
|
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
|
|
Change Dependent Coverage
|
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
|
|
Collapse Configuration
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
LC_DATE_FROM
|
Life Event Collapse - Date From
|
|
LC_DATE_TO
|
Life Event Collapse - Date To
|
|
Compensation Calculation
|
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_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
|
|
Compensation Determination Date
|
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_ACTION_ID
|
Payroll Action
|
|
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
|
|
Compensation Object Selection
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
LER_ID
|
Life Event Reason
|
|
OPT_ID
|
Option
|
|
ORGANIZATION_ID
|
Organization
|
|
PERSON_ID
|
Person
|
|
PGM_ID
|
Program
|
|
PL_ID
|
Plan
|
|
PL_TYP_ID
|
Plan Type
|
|
Contribution 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 Amount Calculation
|
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
|
Can you please let me know how to get log for a benefit fast formula?
ReplyDeleteHave you tried ess_log_write() ?
DeleteI believe most of the BEN formulas are executed from ESS process. If so the ess_log_write() will work for you.
If not, pls let me know how your formula gets executed ?