DW_BEN_RATE_CURRENT_D (Preview)

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

Details

Module: Benefits

Key Columns

RATE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
RATE_ID NUMBER 38 0 True Rate Identifier
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