Module: Common
Type: SCD2 Dimension
RATE_SCHEDULE_SK
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| RATE_SCHEDULE_SK | VARCHAR2 | 39 | True | Rate Schedule | |||
| SOURCE_RECORD_ID | VARCHAR2 | 39 | Source Record Id | ||||
| ALLOW_EST_SW | VARCHAR2 | 1 | Allow Estimates | ||||
| ALLOW_PRO_SW | VARCHAR2 | 1 | Allow RVs Proration | ||||
| EFFECTIVE_FROM | TIMESTAMP | 0 | 6 | Effective Date From | |||
| EFFECTIVE_TO | TIMESTAMP | 0 | 6 | Effective Date To | |||
| IS_CURRENT | VARCHAR2 | 1 | Is Current | ||||
| IS_DELETED | VARCHAR2 | 1 | Is Deleted | ||||
| NO_PRO_REF_FLG | VARCHAR2 | 4 | RV Selection Date | ||||
| RATE_SCHEDULE_CD | VARCHAR2 | 8 | Rate Schedule | ||||
| RS_TYPE_FLG | VARCHAR2 | 4 | Rate Schedule Type | ||||
| RS_VERSION_FLG | VARCHAR2 | 4 | Rate Engine | ||||
| W$_INSERT_DT | TIMESTAMP | 0 | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 0 | 6 |