Groups
PLAN_ELEMENTS
| Col # | Column Name | Data Type | Field Length | Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | Primary key | |
| 2 | DESCRIPTION | VARCHAR2 | 120 | Y | ||
| 3 | SUB_NUMBER | VARCHAR2 | 20 | Y | ||
| 4 | PARENT_ID | NUMBER | 22 | Y | ||
| 5 | DAY_CHARGE_ID | NUMBER | 22 | Y | ||
| 6 | ELEMENT_TYPE_ID | NUMBER | 22 | Y | ||
| 7 | FULL_NUMBER | VARCHAR2 | 50 | Y | ||
| 8 | FEE_CYCLE_ID | NUMBER | 22 | Y | ||
| 9 | FINANCE_CODE | NUMBER | 22 | Y | ||
| 10 | FEE_CODE | VARCHAR2 | 120 | Y | ||
| 11 | RATING_METHOD | VARCHAR2 | 400 | Y | ||
| 12 | FEE_PROFILE_TYPE_ID | NUMBER | 22 | Y | ||
| 13 | RATING_METHOD_PROFILE_TYPE_ID | NUMBER | 22 | Y | With 9.9 - Support for rating method profile type |