PJS_FP_SUM_PLAN1_1
This table contains non-persistent plan data mapped to RBS and prepared for Essbase. It is used during online summarization for exposing data to Essbase.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| WORKER_ID | NUMBER | 18 | A WORKER_ID is unique for each instance of summarization and is used to identify the data for that intance. | |
| SCENARIO | VARCHAR2 | 10 | Type of data in Essbase whether actuals, current baseline budget, etc. | |
| RECORD_TYPE | VARCHAR2 | 4 | Internal data source identifier | |
| PJS_SUMMARY_ID | NUMBER | 18 | The PJS_SUMMARY_ID is used by the transaction system to map a summarization event to a set of data to be summarized. | |
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | |
| PLAN_VERSION_ID | NUMBER | 18 | Plan Version ID | |
| PLAN_VERSION_ID_FLAG | VARCHAR2 | 1 | This flag indicates whether the PLAN_VERSION_ID is an interior node, or a self node (both of which have the same PLAN_VERSION_ID). | |
| PROJECT_ELEMENT_ID | NUMBER | 18 | The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID | |
| PROJECT_ELEMENT_ID_FLAG | VARCHAR2 | 1 | This flag indicates whether the PROJECT_ELEMENT_ID is an interior node, or a self node (both of which have the same PROJECT_ELEMENT_ID). | |
| TIME_ID | NUMBER | 18 | Period time ID | |
| RBS_VERSION_ID | NUMBER | 18 | Resource breakdown structure version ID | |
| RBS_ELEMENT_ID | NUMBER | 18 | Resource breakdown structure element ID | |
| RBS_ELEMENT_ID_FLAG | VARCHAR2 | 1 | This flag indicates whether the RBS_ELEMENT_ID is an interior node, or a self node (both of which have the same RBS_ELEMENT_ID). | |
| CALENDAR_TYPE | VARCHAR2 | 1 | Indicates whether PA or GL calendar | |
| CURRENCY_TYPE | VARCHAR2 | 1 | Currency type | |
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | |
| PLAN_TYPE_ID | NUMBER | 18 | Plan type ID | |
| PLAN_CLASS_CODE | VARCHAR2 | 1 | Indicates whether the plan is a budget or forecast plan | |
| REVENUE | NUMBER | REVENUE | ||
| LABOR_REVENUE | NUMBER | Revenue | ||
| RAW_COST | NUMBER | Raw cost | ||
| BILL_RAW_COST | NUMBER | Billable raw cost | ||
| CAP_RAW_COST | NUMBER | Capitalizable raw cost | ||
| EXP_RAW_COST | NUMBER | Expense raw cost | ||
| LABOR_RAW_COST | NUMBER | Raw cost | ||
| BILL_LABOR_RAW_COST | NUMBER | Billable raw cost | ||
| EQUIPMENT_RAW_COST | NUMBER | Raw cost | ||
| BRDN_COST | NUMBER | Burdened cost | ||
| BILL_BRDN_COST | NUMBER | Billable burdened cost | ||
| CAP_BRDN_COST | NUMBER | Capitalizable burdened cost | ||
| EXP_BRDN_COST | NUMBER | Expense burdened cost | ||
| LABOR_BRDN_COST | NUMBER | Burdened cost | ||
| BILL_LABOR_BRDN_COST | NUMBER | Billable burdened cost | ||
| EQUIPMENT_BRDN_COST | NUMBER | Burdened cost | ||
| LABOR_HRS | NUMBER | Quantity | ||
| BILL_LABOR_HRS | NUMBER | Quantity | ||
| EQUIPMENT_HRS | NUMBER | Quantity | ||
| BILL_EQUIPMENT_HRS | NUMBER | Quantity | ||
| PERIOD_NAME | VARCHAR2 | 30 | Name of the GL or PA period in which transaction occurred. | |
| START_DATE | DATE | Start date of the current GL or PA period. | ||
| END_DATE | DATE | End date of the current GL or PA period. | ||
| CALENDAR_ID | NUMBER | 18 | Identifier of the calendar from Time dimension. | |
| UOM_CODE | VARCHAR2 | 30 | The unit by which to measure amounts in a transaction. | |
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Identifier of the unique combination of resource attributes. | |
| RESOURCE_CLASS_ID | NUMBER | 18 | Identifier of the resource class. | |
| QUANTITY | NUMBER | The number of units of the work performed. | ||
| ADDL_ATTRIBUTE_NUM_1 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_2 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_3 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_4 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_5 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_6 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_7 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_8 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_9 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_NUM_10 | NUMBER | Oracle internal use only. | ||
| ADDL_ATTRIBUTE_CHAR_1 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_2 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_3 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_4 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_5 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_6 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_7 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_8 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_9 | VARCHAR2 | 30 | Oracle internal use only. | |
| ADDL_ATTRIBUTE_CHAR_10 | VARCHAR2 | 30 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_FP_SUM_PLAN1_1_N1 | Non Unique | Default | WORKER_ID, PROJECT_ID, PLAN_CLASS_CODE |