DW_BEN_PROGRAM_D (Preview)

This table requires activation of Benefits functional area. Benefit program details

Details

Module: Benefits

Key Columns

EFFECTIVE_END_DATE, PROGRAM_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
PROGRAM_ID NUMBER 38 0 True Program 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 Program Name
PROGRAM_GRP_CD VARCHAR2 32 Program Group
PROGRAM_STAT_CD VARCHAR2 32 Program Status
PROGRAM_TYP_CD VARCHAR2 32 Program Type
GLOBAL_FLAG VARCHAR2 32 Global Flag
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 32 Allows Unrestricted Enrollment
COMMUNICATED_RT_FREQ VARCHAR2 32 Communicated Rate Frequency
DEFINED_RT_FREQ VARCHAR2 32 Defined Rate Frequency
RATE_LEVEL VARCHAR2 256 Rate Level
PROGRAM_UOM VARCHAR2 32 Program Currency
PERD_OF_ENRT_LVL_CD VARCHAR2 32 Enrollment Period Level
DPNT_DSGN_LVL_CD VARCHAR2 32 Dependent Designation Level