DW_BEN_RATE_D (Preview)

This table requires activation of Benefits functional area. Table stores details of benefit rate setup data

Details

Module: Benefits

Key Columns

EFFECTIVE_END_DATE, RATE_ID, EFFECTIVE_START_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_ID NUMBER 38 0 True Rate Identifier    
EFFECTIVE_START_DATE DATE     True Effective Start Date    
EFFECTIVE_END_DATE DATE     True Effective End Date    
SOURCE_RECORD_ID VARCHAR2 128     This column is for Oracle Internal use only. Unique Source Record Identifier    
RATE_NAME VARCHAR2 256     Rate name    
STATUS VARCHAR2 32     Staus    
RATE_DISPLAY_CD VARCHAR2 32     Rate Display Code    
RECURRING_CD VARCHAR2 32     Recrring code    
TX_TYP_CD VARCHAR2 32     Tax Type    
ACTY_TYP_CD VARCHAR2 32     Activity Type    
RATE_MULTIPLY_CD VARCHAR2 32     Multiply Code    
RATE_USAGE_CD VARCHAR2 32     Rate Usage Code    
NON_MNTRY_UOM VARCHAR2 32     Rate Non Monetary UOM    
VAL NUMBER       Rate Value    
ELEMENT_TYPE_ID NUMBER 38 0   Element Type ID    
PROGRAM_ID NUMBER 38 0   Program Identifier    
PLAN_ID NUMBER 38 0   Plan Identifier    
OPTION_ID NUMBER 38 0   Option Identifer    

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