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
| 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 |