Groups
RATE_PLAN_CHANGE
| Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | CHANGE_DATE | DATE | 7 | Y | ||
| 3 | SUBSCRIPTION_ID | NUMBER | 22 | Y | ||
| 4 | CURRENT_RATE_PLAN_ID | NUMBER | 22 | Y | ||
| 5 | NEW_RATE_PLAN_ID | NUMBER | 22 | Y | ||
| 6 | BOOKED_ON_DATE | DATE | 7 | Y | ||
| 7 | BOOKED_BY | VARCHAR2 | 20 | Y | ||
| 8 | NEW_PRODUCT_ID | NUMBER | 22 | Y | ||
| 9 | NPFLOW_ID | NUMBER | 22 | Y | ||
| 10 | STATUS_ID | NUMBER | 22 | Y | ||
| 11 | RATE_PLAN_CHANGE_MODULE_ID | NUMBER | 22 | Y | ||
| 12 | IS_SILENT | CHAR | 1 | Y | ||
| 13 | START_PROCESS_DATE | DATE | 7 | Y | ||
| 14 | EFFECTUATION_DATE | DATE | 7 | Y |