DW_BEN_PLAN_OPTION_CURRENT_D (Preview)

This table requires activation of Benefits functional area. Benefit plan option details current view

Details

Module: Benefits

Key Columns

OPTION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPTION_ID NUMBER 38 0 True Option Identifier    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier    
NAME VARCHAR2 256     Option Name    
SHORT_NAME VARCHAR2 32     Option Short Name    
SHORT_CODE VARCHAR2 32     Option Short Code    
GLOBAL_FLAG VARCHAR2 32     Option Global Flag    
WAIVE_OPTION_FLAG VARCHAR2 32     Waive Option Flag    
BNFT_EXTRCT_OPTION_NAME VARCHAR2 256     Benefit Extract Option Name    

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