Column | Description |
ACTUAL_BENEFIT | This numeric column represents the total actual benefit of a benefit plan. |
AGG_BENEFIT | This column is not used. |
AGG_BREAKEVEN | This column is not used. |
AGG_COST | This column is not used. |
AGG_END_PERIOD_ID | This column is not used. |
AGG_NPV | This column is not used. |
AGG_REVENUE | This column is not used. |
AGG_ROI | This column is not used. |
AGG_START_PERIOD_ID | This column is not used. |
AGG_TOTAL_BENEFIT | This column is not used. |
AGG_TOTAL_COST | This column is not used. |
AGG_TOTAL_REVENUE | This column is not used. |
AGG_TOTAL_UNITS | This column is not used. |
AGG_UNITS | This column is not used. |
BENEFIT | The time-sliced value of planned benefit amount. |
BENEFIT_PLAN_ID | The benefit plan ID with which this plan is associated. This refers to the internal ID of the table FIN_PLANS. |
CODE | The ID of the financial plan. |
COST | The time-scaled value of the planned cost amount. |
CREATED_BY | This column refers to the resource (CMN_SEC_USERS.ID) that created this row. |
CREATED_DATE | This column refers to the date and time this row was created. |
DESCRIPTION | The description of the financial plan. |
END_PERIOD_ID | The end time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table. |
ID | This column refers to the internal ID of the plan. |
IS_PLAN_OF_RECORD | This column indicates if the plan is the plan of record. |
LAST_UPDATED_BY | The resource that last updated this row. This refers to CMN_SEC_USERS.ID. |
LAST_UPDATED_DATE | The date and time this row was last updated. |
NAME | The name of the financial plan. |
OBJECT_CODE | The object ID for which the plan was created. |
OBJECT_ID | The object for which the plan was created. This refers to the internal ID of the object instance. |
PERIOD_TYPE_CODE | This column indicates the plan period type. It is one of the values from the lookup type "PERIOD_TYPE." |
PLAN_BY_1_CODE | This column indicates the first plan by option. Values are: - 0 = Transaction class
- 1 = Roles
- 2 = Charge codes
- 3 = Utility code 1
- 4 = Utility code 2
|
| PLAN_BY_2_CODE | This column indicates the second plan by option. Value are: - 0 = Transaction class
- 1 = Roles
- 2 = Charge codes
- 3 = Utility code 1
- 4 = Utility code 2
|
| PLAN_TYPE_CODE | This column indicates the plan type. Values can be either budget or forecast. These are the lookup values from lookup type FIN_PLAN_TYPE. |
REVENUE | The time-scaled value of the planned revenue amount. |
REVISION | The plan revision. |
START_PERIOD_ID | The starting time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table. |
STATUS_CODE | The status of the plan. Values are: - 0 = Not submitted
- 1 = Submitted
- 2 = Approved
|
SUB_PLAN_TYPE | The sub type of the plan. This indicates if the plan is a cost plan or a benefit plan. |
TOTAL_ACTUAL_BENEFIT | This numeric column represents the total actual benefit for a line item of a benefit plan. |
TOTAL_BENEFIT | The total planned benefit amount. |
TOTAL_BILLING_BENEFIT | The total benefit amount in billing currency. |
TOTAL_COST | The total planned cost amount. |
TOTAL_REVENUE | The total planned revenue amount. |
TOTAL_UNITS | The total planed units. |
UNITS | The time-scaled value of the plan units. |