DW_BEN_LIFE_EVENT_D (Preview)

This table requires activation of Benefits functional area. Benefit life events details

Details

Module: Benefits

Key Columns

EFFECTIVE_END_DATE, LER_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LER_ID NUMBER 38 0 True Life event Identifier
EFFECTIVE_START_DATE DATE True Indicates the date at the beginning of the date range within which the row is effective
EFFECTIVE_END_DATE DATE True Indicates the date at the end of the date range within which the row is effective
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique Source Record Identifier
NAME VARCHAR2 256 Name of the life event reason.
OVRRIDG_LE_FLAG VARCHAR2 32 Overriding Life Event Y or N.
TYP_CD VARCHAR2 32 Life event reason type.