Benefit Formula Types
Contexts
|
Formula
Type Name
|
Context Base Name
|
Context Name
|
|
Partial Month Effective Date 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
|
|
|
|
|
|
|
Partial Month Proration Method
|
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
|
|
|
|
|
|
|
Partial Month Proration Rule
|
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
|
|
|
|
|
|
|
Partial Year Coverage Restriction
|
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
|
|
|
|
|
|
|
Participation Eligibility 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
|
|
|
|
|
|
|
Participation Eligibility 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
|
|
|
|
|
|
|
Participation and Rate Eligibility
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
ADDRESS_ID
|
Address
|
|
|
ADDRESS_TYPE
|
Address Type
|
|
|
BENEFIT_RELATION_ID
|
Benefit Relation
|
|
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
|
DATE_EARNED
|
Date Earned
|
|
|
DEDUCTION_CARD_ID
|
Deduction Card
|
|
|
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
|
|
|
TAX_UNIT_ID
|
Tax Unit
|
|
|
|
|
|
|
Payment Must Be Received
|
BUSINESS_GROUP_ID
|
BUSINESS_GROUP_ID
|
|
EFFECTIVE_DATE
|
EFFECTIVE_DATE
|
|
|
HR_ASSIGNMENT_ID
|
HR Assignment
|
|
|
PERSON_ID
|
Person
|
|
|
Payment 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
|
|
|
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
|
|
|
|
|
|
|
Period to Date Amount Calculation
|
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
|
|
|
|
|
|
|
Person Change Causes Life Event
|
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
|
|
|
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
|
|
|
|
|
|
|
Person Selection
|
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
|
|
|
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
|
|
|
|
|
|
|
Postelection Edit
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
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
|
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
|
PL_ID
|
Plan
|
|
|
|
|
|
|
Preferential Rate Calculation
|
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
|
|
|
|
|
|
|
Prorate Annual Election Value
|
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
|
|
|
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
|
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Range of Scheduled Hours
|
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
|
|
|
|
|
|
|
Rate End Date
|
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
|
|
|
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_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
|
|
|
|
|
|
|
Rate Lower Limit
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
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
|
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Rate Periodization
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
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_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
|
|
|
|
|
|
|
Rate Start Date
|
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
|
|
|
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_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
|
|
|
|
|
|
|
Rate Upper Limit
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
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
|
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
|
PGM_ID
|
Program
|
|
|
PL_ID
|
Plan
|
|
|
PL_TYP_ID
|
Plan Type
|
|
|
|
|
|
|
Rate Value Calculation
|
ACTY_BASE_RT_ID
|
Activity Base Rate
|
|
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_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
|
|
|
|
|
|
|
Related Person Change Causes Life Event
|
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
|
|
|
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
|
|
|
|
|
|
|
Required Period of Enrollment
|
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
|
|
|
|
|
|
|
Rounding
|
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
|
Fast Formula – Benefits, part 6
Benefit Formula Types
Contexts
|
|
|
|
|
To Be Sent Date
|
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
|
|
|
|
|
|
|
Unsuspend Date to Use
|
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
|
|
|
LEGAL_EMPLOYER_ID
|
Legal Employer
|
|
|
LEGISLATIVE_DATA_GROUP_ID
|
Legislative Data Group
|
|
|
LER_ID
|
Life Event Reason
|
|
|
ORGANIZATION_ID
|
Organization
|
|
|
PAYROLL_ASSIGNMENT_ID
|
Payroll Assignment
|
|
|
PAYROLL_RELATIONSHIP_ID
|
Payroll Relationship
|
|
|
PAYROLL_TERM_ID
|
Payroll Term
|
|
|
PERSON_ID
|
Person
|
|
|
|
|
|
|
Variable Rate Add On Calculation
|
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
|
|
|
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
|
|
|
PER_IN_LER_ID
|
Person Life Event
|
|
|
PL_ID
|
Plan
|
Hi Tilak and Lakshmi,
ReplyDeleteDo you have any sample fast formula of "Unsuspend Date to Use" Type.
Regards
Anubhav
Hi Tilak and Laxmi,
ReplyDeleteDo you guys have an example of setting the PER_IN_LER_ID context?
Thanks in advance!
I do not have a example of setting PER_IN_LER_ID. why do you think it is different than setting any other context?
DeleteIf you want to know how to set the context, please see, https://tilak-lakshmi.blogspot.com/2016/04/fast-formulas-and-arrays.html. In this example we are setting context of assignment id.
Hope this helps.
-- tilak