DW_BEN_PARTICIPANT_ENROLLMENT_EF (Preview)

This table requires activation of Benefits functional area. This EF identifies the plans or option in plans in which a participant is enrolled, either through explicit election or due to system default/automatic enrollments.

Details

Module: Benefits

Key Columns

PRTT_ENRT_RSLT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PRTT_ENRT_RSLT_ID NUMBER 38 0 True Relationship Identifier
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
ENRT_CVG_STRT_DT DATE Enrollment Coverage Start Date
ENRT_CVG_THRU_DT DATE Enrollment Coverage Through Date
PERSON_ID NUMBER 38 0 Person Identifier
BENEFIT_RELATION_ID NUMBER 38 0 Benefit Relation Identifier
ASSIGNMENT_ID NUMBER 38 0 Assignment Identifier
LER_ID NUMBER 38 0 Life event Identifier DW_BEN_LIFE_EVENT_D LER_ID
PERSON_HABIT_ID NUMBER 38 0 Person Habit Identifier DW_BEN_HABITS_D PERSON_ID
PTNL_LER_ID NUMBER 38 0 Potential Life Event Identifier
EVLTD_LER_ID NUMBER 38 0 Evaluated Event Identifier
PROGRAM_ID NUMBER 38 0 Program Identifer DW_BEN_PROGRAM_D PROGRAM_ID
PLAN_TYPE_ID NUMBER 38 0 Plan Type Identifier DW_BEN_PLAN_TYPE_D PLAN_TYPE_ID
PLAN_ID NUMBER 38 0 Plan Identifier DW_BEN_PLAN_D PLAN_ID
OPTION_ID NUMBER 38 0 Option Identifier DW_BEN_PLAN_OPTION_D OPTION_ID
BNFT_AMT NUMBER Coverage Amount
UOM VARCHAR2 32 Unit of measure
ENRT_MTHD_CD VARCHAR2 32 Enrollment Method
PRTT_ENRT_RSLT_STAT_CD VARCHAR2 32 Enrollment Status Code
BNFT_NON_MNTRY_UOM VARCHAR2 32 Non-monetary Unit of Measure
BNFT_TYP_CD VARCHAR2 32 Benefit Type
ENRT_OVRID_RSN_CD VARCHAR2 32 Enrollment Overriding Reason Code
BNFT_ORDR_NUM NUMBER 38 0 Benefit Order Number
ORGNL_ENRT_DT DATE Original Enrollment Date
ELECTION_DATE DATE Election Date
ENRT_OVRID_THRU_DT DATE Enrollment Overridden Through Date
PRVS_CVG_STRT_DT DATE Previous Coverage Start Date
PRVS_CVG_THRU_DT DATE Previous Coverage Through Date
ERLST_DE_ENRT_DT DATE Earliest De-enrollment Date
ENDED_CVG_THRU_DT DATE Ended Coverage Through Date
SSPNDD_FLAG VARCHAR2 32 Suspended Flag
INTERIM_FLAG VARCHAR2 32 Interim Flag
ENRT_OVRIDN_FLAG VARCHAR2 32 Enrollment Overriding Flag
SVNGS_PLN_FLAG VARCHAR2 32 Savings Plan Flag
MISC_PLN_FLAG VARCHAR2 32 Miscellaneous Plan Flag
PRVS_SSPNDD_FLAG VARCHAR2 32 Previous Suspended Flag
PRTT_IS_CVRD_FLAG VARCHAR2 32 Participant Is Covered Flag
NO_LNGR_ELIG_FLAG VARCHAR2 32 No Longer Eligible Flag
ANCHOR_DATE DATE Enrollment Coverage Start Date
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency Code
GLOBAL_CURRENCY_EXCH_RATE NUMBER Global currency conversion rate.
ASSIGNMENT_NUMBER VARCHAR2 32 Assignment Number
PRIMARY_FLAG VARCHAR2 32 Represents overall Primary assignment
ASSIGNMENT_STATUS_TYPE_ID NUMBER 38 0 Assignment Status Type Identifier DW_ASSIGNMENT_STATUS_D_TL ASSIGNMENT_STATUS_TYPE_ID
ASSIGNMENT_CATEGORY VARCHAR2 32 User defined category. For example Full-Time Permanent or Part-Time Permanent DW_ASSIGNMENT_CATEGORY_D_TL ASSIGNMENT_CATEGORY
PERMANENT_TEMPORARY_FLAG VARCHAR2 32 Permanent Temporary Flag
HOURLY_SALARIED_CODE VARCHAR2 32 Paid hourly or salaried code
FULL_PART_TIME_FLAG VARCHAR2 32 Full Part Time Flag
SYSTEM_PERSON_TYPE VARCHAR2 32 Person Type in System
PERSON_TYPE_ID NUMBER 38 0 Person Type DW_PERSON_TYPE_D_TL PERSON_TYPE_ID
LEGAL_EMPLOYER_ID NUMBER 38 0 Legal Employer DW_LEGAL_EMPLOYER_D LEGAL_EMPLOYER_ID
BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier DW_BUSINESS_UNIT_D BUSINESS_UNIT_ID
LEGISLATION_CODE VARCHAR2 256 Legislation of Assignment DW_LEGISLATION_D_TL LEGISLATION_CODE
JOB_ID NUMBER 38 0 Job Identifier DW_JOB_D JOB_ID
GRADE_ID NUMBER 38 0 Grade Identifier DW_PAY_GRADE_D GRADE_ID
BARGAINING_UNIT_CODE VARCHAR2 32 Bargaining Unit Code
POSITION_ID NUMBER 38 0 Position Identifier DW_POSITION_D POSITION_ID
LOCATION_ID NUMBER 38 0 Location Identifier DW_WORKER_LOCATION_D LOCATION_ID
DEPARTMENT_ID NUMBER 38 0 Department Identifier DW_DEPARTMENT_D DEPARTMENT_ID