Monday, November 7, 2016

Fast Formula – Benefits, part 2

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


2 comments:

  1. Can you please let me know how to get log for a benefit fast formula?

    ReplyDelete
    Replies
    1. Have you tried ess_log_write() ?
      I 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 ?

      Delete