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

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    

Copyright © 2019, 2025, Oracle and/or its affiliates.