PJS_FP_SUM_FIN3_B
This table contains non-persistent actuals data mapped to RBS and prepared for Essbase. It is used during bulk summarization for exposing data to Essbase.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Comments | Status |
|---|---|---|---|---|---|
| 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. | ||
| 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) | ||
| 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 | 3 | Currency code | ||
| 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 | |||
| SUP_INV_COMMITTED_COST | NUMBER | Supplier invoice commitment cost | |||
| PO_COMMITTED_COST | NUMBER | Purchase order commitment cost | |||
| PR_COMMITTED_COST | NUMBER | Requisition commitment cost | |||
| OTH_COMMITTED_COST | NUMBER | Commitment cost that is not Purchace Order, Requisition or Supplier Invoice | |||
| INVOICE_AMT | NUMBER | Invoice amount | |||
| RETIRE_RAW_COST | NUMBER | Raw cost | Active | ||
| RETIRE_BRDN_COST | NUMBER | Burdened cost | Active |