Monday, November 7, 2016

Fast Formula – Benefits, part 4


Benefit Formula Types Contexts

Formula Type Name
Context Base Name
Context Base Name
Eligibility Access Calculation Rule
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
PGM_ID
Program
PL_ID
Plan
PL_TYP_ID
Plan Type



Enrollment Certification Required
BUSINESS_GROUP_ID
BUSINESS_GROUP_ID
DATE_EARNED
Date Earned
EFFECTIVE_DATE
EFFECTIVE_DATE
ELIG_PER_ELCTBL_CHC_ID
Electable Choice
ENRT_CTFN_TYP_CD
Certification type
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



Enrollment 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



Enrollment End
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



Enrollment Opportunity
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



Enrollment Period 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



Enrollment Period 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



Evaluate 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
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_RELATIONSHIP_ID
Payroll Relationship
PAYROLL_TERM_ID
Payroll Term
PERSON_ID
Person



Excess Credits Treatment
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
LEGAL_ENTITY_ID
Benefit Relation
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



Extra Input
ACTY_BASE_RT_ID
Activity Base Rate
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



Family Member Determination
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



Handling of Non-winning events
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
LER_ID
Life Event Reason
Hours Worked 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_RELATIONSHIP_ID
Payroll Relationship
PAYROLL_TERM_ID
Payroll Term
PERSON_ID
Person
PGM_ID
Program
PL_ID
Plan
PL_TYP_ID
Plan Type



Hours Worked Determination Date
BENEFIT_RELATION_ID
Benefit Relation
BNFTS_BAL_ID
Benefit Balance
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
LER_ID
Life Event Reason
OPT_ID
Option
ORGANIZATION_ID
Organization
PAYROLL_ACTION_ID
Payroll Action
PAYROLL_ID
Payroll
PERSON_ID
Person
PGM_ID
Program
PL_ID
Plan
PL_TYP_ID
Plan Type



Inspection 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



Length of Service 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



Length of Service 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
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



Length of Service Determination Date
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



Life Event Occurred Date
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
LER_ID
Life Event Reason



Life Event Reason Timeliness
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_RELATIONSHIP_ID
Payroll Relationship
PAYROLL_TERM_ID
Payroll Term
PERSON_ID
Person



Mandatory Determination
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



Matching 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



Maximum Coverage Amount Calculation
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



Maximum 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
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



Maximum Period of Enrollment Determination 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
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



Maximum Period of Enrollment Value and UOM
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



Maximum Waiting Period Date to Use
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



Maximum Waiting Period to Participate
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



Minimum Coverage Amount Calculation
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

No comments:

Post a Comment