PJS_FP_SUM_FIN1_B
This table contains non-persistent summary data aggregated by period. It is used during bulk summarization for mapping data by resource attribute to TXN_ACCUM_HEADER_IDs.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
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. | Active | |
| PLANNED_BRDN_COST | NUMBER | PLANNED_BRDN_COST | |||
| TXN_ACCUM_HEADER_ID | NUMBER | 18 | Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping | Active | |
| RECORD_TYPE | VARCHAR2 | 4 | Internal data source identifier | Active | |
| PROJECT_ID | NUMBER | 18 | Contains the PROJECT_ID, not the Project Number (SEGMENT1) | Active | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Business Unit ID | Active | |
| TASK_ID | NUMBER | 18 | Task ID | Active | |
| PLAN_VERSION_ID | NUMBER | 18 | Plan Version ID | Active | |
| PLAN_CLASS_CODE | VARCHAR2 | 1 | Indicates whether the plan is a budget or forecast plan | Active | |
| PLAN_CURRENT_FLAG | VARCHAR2 | 1 | Inernal flag | Active | |
| RESOURCE_CLASS_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| PERSON_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| ORGANIZATION_ID | NUMBER | 18 | Indicates the identifier of the business unit associated to the row. | Active | |
| JOB_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| VENDOR_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| EXPENDITURE_TYPE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| EVENT_TYPE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| REVENUE_CATEGORY | VARCHAR2 | 30 | Revenue category | Active | |
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| BOM_LABOR_RESOURCE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| BOM_EQUIPMENT_RESOURCE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| ITEM_CATEGORY_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| ROLE_ID | NUMBER | 18 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| PERSON_TYPE | VARCHAR2 | 30 | Resource attribute used to identify TXN_ACCUM_HEADER_ID | Active | |
| CALENDAR_ID | NUMBER | 18 | Time dimension calendar ID | Active | |
| CALENDAR_TYPE | VARCHAR2 | 1 | Indicates whether PA or GL calendar | Active | |
| PERIOD_NAME | VARCHAR2 | 30 | Period name | Active | |
| START_DATE | DATE | Start date | Active | ||
| END_DATE | DATE | End date | Active | ||
| CURRENCY_TYPE | VARCHAR2 | 1 | Currency type | Active | |
| CURRENCY_CODE | VARCHAR2 | 15 | Currency code | Active | |
| 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 | ||
| EXPENSE_RAW_COST | NUMBER | Expense 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 | ||
| EXPENSE_BRDN_COST | NUMBER | Expense burdened cost | Active | ||
| UBR | NUMBER | Unbilled receivable | Active | ||
| UER | NUMBER | Unearned revenue | Active | ||
| QUANTITY | NUMBER | QUANTITY | Active | ||
| CMT_SUP_INV_QUANTITY | NUMBER | Commitment supplier invoice quantity | |||
| CMT_PO_QUANTITY | NUMBER | Commitment purchase order quantity | |||
| CMT_PR_QUANTITY | NUMBER | Requisition commitment quantity | |||
| CMT_OTH_QUANTITY | NUMBER | Commitment other quantity | |||
| BILL_QUANTITY | NUMBER | Quantity | Active | ||
| CAP_QUANTITY | NUMBER | Quantity | Active | ||
| EXPENSE_QUANTITY | NUMBER | Quantity | Active | ||
| LABOR_HRS | NUMBER | Quantity | Active | ||
| BILL_LABOR_HRS | NUMBER | Quantity | Active | ||
| CAP_LABOR_HRS | NUMBER | Quantity | Active | ||
| EXPENSE_LABOR_HRS | NUMBER | Quantity | Active | ||
| SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | Active | ||
| PRJ_SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | |||
| FUN_SUP_INV_CMT_RAW_COST | NUMBER | Supplier invoice commitment cost | |||
| PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | Active | ||
| PRJ_PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | |||
| FUN_PO_CMT_RAW_COST | NUMBER | Purchase order commitment cost | |||
| PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | Active | ||
| PRJ_PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | |||
| FUN_PR_CMT_RAW_COST | NUMBER | Requisition commitment cost | |||
| OTH_CMT_RAW_COST | NUMBER | Commitment cost | Active | ||
| PRJ_OTH_CMT_RAW_COST | NUMBER | Commitment cost | |||
| FUN_OTH_CMT_RAW_COST | NUMBER | Commitment cost | |||
| SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | Active | ||
| PRJ_SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | |||
| FUN_SUP_INV_CMT_BRDN_COST | NUMBER | Supplier invoice commitment cost | |||
| PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | Active | ||
| PRJ_PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | |||
| FUN_PO_CMT_BRDN_COST | NUMBER | Purchase order commitment cost | |||
| PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | Active | ||
| PRJ_PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | |||
| FUN_PR_CMT_BRDN_COST | NUMBER | Requisition commitment cost | |||
| OTH_CMT_BRDN_COST | NUMBER | Commitment cost | Active | ||
| PRJ_OTH_CMT_BRDN_COST | NUMBER | Commitment cost | |||
| FUN_OTH_CMT_BRDN_COST | NUMBER | Commitment cost | |||
| INVOICE_AMT | NUMBER | Invoice amount | |||
| CUSTOM1 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM2 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM3 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM4 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM5 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM6 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM7 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM8 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM9 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM10 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM11 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM12 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM13 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM14 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| CUSTOM15 | NUMBER | Placeholder column used to store measures extracted with the custom PL/SQL API. | Active | ||
| PRJ_RAW_COST | NUMBER | Project raw cost | Active | ||
| PRJ_BRDN_COST | NUMBER | Project burdened cost | Active | ||
| PRJ_REVENUE | NUMBER | Project revenue | Active | ||
| FUN_RAW_COST | NUMBER | Project functional raw cost | Active | ||
| FUN_BRDN_COST | NUMBER | Project functional burdened cost | Active | ||
| FUN_REVENUE | NUMBER | Project functional revenue | Active | ||
| UOM_CODE | VARCHAR2 | 30 | Unit of measure code | Active | |
| AWARD_PERIOD_ID | NUMBER | 18 | AWARD_PERIOD_ID | ||
| CONTRACT_ID | NUMBER | 18 | Unique identifier of the award. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | Identifier of the award funding source. |