This table requires activation of Benefits functional area. Table stores details of benefit rate setup data
Module: Benefits
EFFECTIVE_END_DATE, RATE_ID, EFFECTIVE_START_DATE
| 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.