PJS_FP_PROJ_F
This table contains persistent actuals data that has been fully summarized and has been loaded to Essbase, when Essbase is available.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
PJS_FP_PROJ_F_PK |
SCENARIO, PROJECT_ELEMENT_ID, PROJECT_ELEMENT_ID_FLAG, TIME_ID, RBS_ELEMENT_ID, RBS_ELEMENT_ID_FLAG, CURRENCY_TYPE, CALENDAR_TYPE, CURRENCY_CODE, PERIOD_NAME, START_DATE, END_DATE, CALENDAR_ID, UOM_CODE, TXN_ACCUM_HEADER_ID, RESOURCE_CLASS_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| SCENARIO | VARCHAR2 | 10 | Yes | Type of data in Essbase whether actuals, current baseline budget, etc. | Active | |
| 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. | Active | ||
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | ||
| PROJECT_ELEMENT_ID | NUMBER | 18 | Yes | The PROJECT_ELEMENT_ID can be either the TASK_ID or the structure level ELEMENT_ID | Active | |
| PROJECT_ELEMENT_ID_FLAG | VARCHAR2 | 1 | Yes | 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). | Active | |
| TIME_ID | NUMBER | 18 | Yes | Period time ID | Active | |
| RBS_VERSION_ID | NUMBER | 18 | Resource breakdown structure version ID | Active | ||
| RBS_ELEMENT_ID | NUMBER | 18 | Yes | Resource breakdown structure element ID | Active | |
| RBS_ELEMENT_ID_FLAG | VARCHAR2 | 1 | Yes | 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). | Active | |
| CURRENCY_TYPE | VARCHAR2 | 1 | Yes | Currency type | Active | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | Currency code | Active | |
| CALENDAR_TYPE | VARCHAR2 | 1 | Yes | Indicates whether PA or GL calendar | Active | |
| REVENUE | NUMBER | REVENUE | Active | |||
| LABOR_REVENUE | NUMBER | Revenue | Active | |||
| RAW_COST | NUMBER | Raw cost | Active | |||
| BILL_RAW_COST | NUMBER | Billable raw cost | Active | |||
| CAP_RAW_COST | NUMBER | Capitalizable raw cost | Active | |||
| EXP_RAW_COST | NUMBER | Expense raw cost | Active | |||
| LABOR_RAW_COST | NUMBER | Raw cost | Active | |||
| BILL_LABOR_RAW_COST | NUMBER | Billable raw cost | Active | |||
| EQUIPMENT_RAW_COST | NUMBER | Raw cost | Active | |||
| BRDN_COST | NUMBER | Burdened cost | Active | |||
| BILL_BRDN_COST | NUMBER | Billable burdened cost | Active | |||
| CAP_BRDN_COST | NUMBER | Capitalizable burdened cost | Active | |||
| EXP_BRDN_COST | NUMBER | Expense burdened cost | Active | |||
| LABOR_BRDN_COST | NUMBER | Burdened cost | Active | |||
| BILL_LABOR_BRDN_COST | NUMBER | Billable burdened cost | Active | |||
| EQUIPMENT_BRDN_COST | NUMBER | Burdened cost | Active | |||
| LABOR_HRS | NUMBER | Quantity | Active | |||
| BILL_LABOR_HRS | NUMBER | Quantity | Active | |||
| EQUIPMENT_HRS | NUMBER | Quantity | Active | |||
| BILL_EQUIPMENT_HRS | NUMBER | Quantity | Active | |||
| SUP_INV_COMMITTED_COST | NUMBER | Supplier invoice commitment cost | Active | |||
| PO_COMMITTED_COST | NUMBER | Purchase order commitment cost | Active | |||
| PR_COMMITTED_COST | NUMBER | Requisition commitment cost | Active | |||
| OTH_COMMITTED_COST | NUMBER | Burdened cost | Active | |||
| INVOICE_AMT | NUMBER | Invoice amount | ||||
| RETIRE_RAW_COST | NUMBER | Raw cost | Active | |||
| RETIRE_BRDN_COST | NUMBER | Burdened cost | Active | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
| PERIOD_NAME | VARCHAR2 | 30 | Yes | Name of the GL or PA period in which transaction occurred. | ||
| START_DATE | DATE | Yes | Start date of the current GL or PA period. | |||
| END_DATE | DATE | Yes | End date of the current GL or PA period. | |||
| CALENDAR_ID | NUMBER | 18 | Yes | Identifier of the calendar from Time dimension. | ||
| UOM_CODE | VARCHAR2 | 30 | Yes | The unit by which to measure amounts in a transaction. | ||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Yes | Identifier of the unique combination of resource attributes. | ||
| RESOURCE_CLASS_ID | NUMBER | 18 | Yes | Identifier of the resource class. | ||
| SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost amount. | ||||
| PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost amount. | ||||
| PR_CMT_RAW_COST | NUMBER | Purchase requisition commitment cost amount. | ||||
| OTH_CMT_RAW_COST | NUMBER | Commitment cost amount from thrid party source. | ||||
| CMT_SUP_INV_QUANTITY | NUMBER | Suplier invoice commitment quantity. | ||||
| CMT_PO_QUANTITY | NUMBER | Purchase order commitment quantity. | ||||
| CMT_PR_QUANTITY | NUMBER | Purchase requisition commitment quantity. | ||||
| CMT_OTH_QUANTITY | NUMBER | Commitment quantity from third party source. | ||||
| QUANTITY | NUMBER | The number of units of the work performed. | ||||
| BILL_QUANTITY | NUMBER | The number of units of work that are billable. | ||||
| CAP_QUANTITY | NUMBER | The number of units of work that are capitalizable. | ||||
| EXPENSE_QUANTITY | NUMBER | The number of units of work that are neither billable nor capitalizable. | ||||
| CUR_BUD_RAW_COST | NUMBER | Amount for a planning element in a current baselined budget. | ||||
| CUR_BUD_BRDN_COST | NUMBER | Burdened amount for a planning element in a current baselined budget. | ||||
| CUR_BUD_REVENUE | NUMBER | Revenue amount for a planning element in a current baselined budget. | ||||
| CUR_BUD_QUANTITY | NUMBER | Quantity for a planning element in a current baselined budget. | ||||
| ORIG_BUD_RAW_COST | NUMBER | Amount for a planning element in a original baselined budget. | ||||
| ORIG_BUD_BRDN_COST | NUMBER | Burdened amount for a planning element in a original baselined budget. | ||||
| ORIG_BUD_REVENUE | NUMBER | Revenue amount for a planning element in a original baselined budget. | ||||
| ORIG_BUD_QUANTITY | NUMBER | Quantity for a planning element in a original baselined budget. | ||||
| CUR_FCST_RAW_COST | NUMBER | Amount for a planning element in a current baselined forecast. | ||||
| CUR_FCST_BRDN_COST | NUMBER | Burdened amount for a planning element in a current baselined forecast. | ||||
| CUR_FCST_REVENUE | NUMBER | Revenue amount for a planning element in a current baselined forecast. | ||||
| CUR_FCST_QUANTITY | NUMBER | Quantity for a planning element in a current baselined forecast. | ||||
| PRI_FCST_RAW_COST | NUMBER | Amount for a planning element in a prior baselined forecast. | ||||
| PRI_FCST_BRDN_COST | NUMBER | Burdened amount for a planning element in a prior baselined forecast. | ||||
| PRI_FCST_REVENUE | NUMBER | Revenue amount for a planning element in a prior baselined forecast. | ||||
| PRI_FCST_QUANTITY | NUMBER | Quantity for a planning element in a prior baselined forecast. | ||||
| 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 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_2 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_3 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_4 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_5 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_6 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_7 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_8 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_9 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_10 | VARCHAR2 | 150 | Oracle internal use only. | |||
| TO_CMT_RAW_COST | NUMBER | Raw cost committed through transfer orders. | ||||
| TO_COMMITTED_COST | NUMBER | Burdened cost committed through transfer orders. | ||||
| CMT_TO_QUANTITY | NUMBER | Quantity committed through transfer orders. | ||||
| RCPT_CMT_RAW_COST | NUMBER | Raw cost committed through receipts. | ||||
| RCPT_COMMITTED_COST | NUMBER | Burdened cost committed through receipts. | ||||
| CMT_RCPT_QUANTITY | NUMBER | Quantity committed through receipts. | ||||
| TTL_CMT_RAW_COST | NUMBER | Total raw cost that is committed. | ||||
| TTL_COMMITTED_COST | NUMBER | Total burdened cost that is committed. | ||||
| TTL_CMT_QUANTITY | NUMBER | Total quantity that is committed. | ||||
| ADDL_ATTRIBUTE_NUM_11 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_NUM_12 | NUMBER | Oracle internal use only. | ||||
| ADDL_ATTRIBUTE_CHAR_11 | VARCHAR2 | 150 | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_CHAR_12 | VARCHAR2 | 150 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns | Status |
|---|---|---|---|---|
| PJS_FP_PROJ_F_N1 | Non Unique | FUSION_TS_TX_DATA | PROJECT_ID, PROJECT_ELEMENT_ID, TIME_ID, RBS_ELEMENT_ID | Active |
| PJS_FP_PROJ_F_N2 | Non Unique | FUSION_TS_TX_DATA | PJS_SUMMARY_ID | Active |
| PJS_FP_PROJ_F_U1 | Unique | Default | SCENARIO, PROJECT_ELEMENT_ID, PROJECT_ELEMENT_ID_FLAG, TIME_ID, RBS_ELEMENT_ID, RBS_ELEMENT_ID_FLAG, CURRENCY_TYPE, CALENDAR_TYPE, CURRENCY_CODE, PERIOD_NAME, START_DATE, END_DATE, CALENDAR_ID, UOM_CODE, TXN_ACCUM_HEADER_ID, RESOURCE_CLASS_ID |