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