DW_BEN_PROGRAM_CURRENT_D (Preview)
This table requires activation of Benefits functional area. Benefit program details current view
Details
Module: Benefits
Key Columns
PROGRAM_ID
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| PROGRAM_ID | NUMBER | 38 | 0 | True | Program Identifier | ||
| 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 |