DW_BEN_PARTICIPANT_ENROLLMENT_MONTHLY_SNAPSHOT_F (Preview)

This table requires activation of Benefits functional area. This monthly snapshot 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

CALENDAR_DATE, 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    
CALENDAR_DATE DATE     True Calendar Date    
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    
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
LAST_DAY_CAL_MONTH_FLAG VARCHAR2 32     Last Day of the month Indicator