PJO_AGGR_PLANS_GT
Global temporary table that is used to aggregate planning data from the base planning transaction tables for use in online summarization.
Details
-
Schema: FUSION
-
Object owner: PJO
-
Object type: TABLE
-
Tablespace: Default
Columns
| Name | Datatype | Length | Precision | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | 18 | Identifier of the project. | |
| PROJECT_ORG_ID | NUMBER | 18 | Identifier of the business unit. | |
| PROJECT_ORGANIZATION_ID | NUMBER | 18 | Identifier of the business unit. | |
| PROJECT_UNIT_ID | NUMBER | 18 | Identifier of the project unit. | |
| PROJECT_ELEMENT_ID | NUMBER | 18 | Identifier of the task. | |
| RBS_VERSION_ID | NUMBER | 18 | Identifier of the resource breakdown structure version. | |
| RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the resource breakdown structure element. | |
| PLAN_VERSION_ID | NUMBER | 18 | Identifier of the financial plan version. | |
| PLAN_TYPE_ID | NUMBER | 18 | Identifier of the financial plan type. | |
| PLAN_TYPE_CODE | VARCHAR2 | 2 | Code identifying the financial plan type. | |
| PERIOD_NAME | VARCHAR2 | 30 | Name of the period. | |
| PERIOD_TYPE_ID | NUMBER | 18 | Identifier of the period type. | |
| CALENDAR_TYPE | VARCHAR2 | 1 | Type of calendar associated with the financial plan version; either accounting calendar or project accounting calendar. | |
| RBS_AGGR_LEVEL | VARCHAR2 | 1 | Resource breakdown structure aggregation level. | |
| WBS_ROLLUP_FLAG | VARCHAR2 | 1 | Indicates whether values have rolled up from subtasks or assignments or belong directly to this task. | |
| CURRENCY_CODE | VARCHAR2 | 30 | Code identifying the currency. | |
| START_DATE | DATE | Start date of the period from which planning amounts are present. | ||
| END_DATE | DATE | End date of the period to which planning amounts are present. | ||
| ACT_START_DATE | DATE | Start date of the period if actual amounts are present. | ||
| ACT_END_DATE | DATE | End date of the period if actual amounts are present. | ||
| LINE_ID | NUMBER | 18 | Identifier of the line; primary key. | |
| RECORD_TYPE | VARCHAR2 | 1 | Record type. | |
| QUANTITY | NUMBER | Total labor and equipment effort. | ||
| LABOR_HRS | NUMBER | Effort for labor resources. | ||
| EQUIP_HRS | NUMBER | Effort for equipment resource. | ||
| ACT_QUANTITY | NUMBER | Actual effort in hours. | ||
| ACT_LABOR_HRS | NUMBER | Actual labor effort in hours. | ||
| ACT_EQUIP_HRS | NUMBER | Actual equipment effort in hours. | ||
| ACT_BILL_LABOR_HRS | NUMBER | Actual billable labor effort in hours. | ||
| ACT_BILL_EQUIP_HRS | NUMBER | Actual billable equipment effort in hours. | ||
| ETC_QUANTITY | NUMBER | Estimate-to-complete effort in hours. | ||
| ETC_LABOR_HRS | NUMBER | Estimate-to-complete labor effort in hours. | ||
| ETC_EQUIP_HRS | NUMBER | Estimate-to-complete equipment effort in hours. | ||
| CMT_SUP_INV_QUANTITY | NUMBER | Effort in hours associated with supplier invoices. | ||
| CMT_PO_QUANTITY | NUMBER | Effort in hours associated with purchase orders. | ||
| CMT_PR_QUANTITY | NUMBER | Effort in hours associated with purchase requisitions. | ||
| CMT_OTH_QUANTITY | NUMBER | Effort in hours associated with external commitments. | ||
| PC_RAW_COST | NUMBER | Raw cost in project currency. | ||
| PC_BRDN_COST | NUMBER | Burdened cost in project currency. | ||
| PC_REVENUE | NUMBER | Revenue in project currency. | ||
| PC_LABOR_RAW_COST | NUMBER | Raw cost in project currency associated with labor resources. | ||
| PC_LABOR_BRDN_COST | NUMBER | Burdened cost in project currency associated with labor resources. | ||
| PC_EQUIPMENT_RAW_COST | NUMBER | Raw cost in project currency associated with equipment resources. | ||
| PC_EQUIPMENT_BRDN_COST | NUMBER | Burdened cost in project currency associated with equipment resources. | ||
| PC_ACT_RAW_COST | NUMBER | Actual raw cost in project currency. | ||
| PC_ACT_BRDN_COST | NUMBER | Actual burdened cost in project currency. | ||
| PC_ACT_REVENUE | NUMBER | Actual revenue in project currency. | ||
| PC_ACT_LABOR_RAW_COST | NUMBER | Actual raw cost in project currency associated with labor resources. | ||
| PC_ACT_LABOR_BRDN_COST | NUMBER | Actual burdened cost in project currency associated with labor resources. | ||
| PC_ACT_EQUIP_RAW_COST | NUMBER | Actual raw cost in project currency associated with equipment resources. | ||
| PC_ACT_EQUIP_BRDN_COST | NUMBER | Actual burdened cost in project currency associated with equipment resources. | ||
| PC_ACT_BILL_RAW_COST | NUMBER | Actual billable raw cost in project currency. | ||
| PC_ACT_BILL_BRDN_COST | NUMBER | Actual billable burdened cost in project currency. | ||
| PC_ETC_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency. | ||
| PC_ETC_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project currency. | ||
| PC_ETC_REVENUE | NUMBER | Estimate-to-complete revenue in project currency. | ||
| PC_ETC_LABOR_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency for labor resources. | ||
| PC_ETC_LABOR_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project currency for labor resources. | ||
| PC_ETC_EQUIP_RAW_COST | NUMBER | Estimate-to-complete raw cost in project currency for equipment resources. | ||
| PC_ETC_EQUIP_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project currency for equipment resources. | ||
| PC_SUP_INV_CMT_RAW_COST | NUMBER | Raw cost in project currency associated with supplier invoices. | ||
| PC_SUP_INV_CMT_BRDN_COST | NUMBER | Burdened cost in project currency associated with supplier invoices. | ||
| PC_PO_CMT_RAW_COST | NUMBER | Raw cost in project currency associated with purchase orders. | ||
| PC_PO_CMT_BRDN_COST | NUMBER | Burdened cost in project currency associated with purchase orders. | ||
| PC_PR_CMT_RAW_COST | NUMBER | Raw cost in project currency associated with purchase requisitions. | ||
| PC_PR_CMT_BRDN_COST | NUMBER | Burdened cost in project currency associated with purchase requisitions. | ||
| PC_OTH_CMT_RAW_COST | NUMBER | Raw cost in project currency associated with external commitments. | ||
| PC_OTH_CMT_BRDN_COST | NUMBER | Burdened cost in project currency associated with external commitments. | ||
| PFC_RAW_COST | NUMBER | Raw cost in project ledger currency. | ||
| PFC_BRDN_COST | NUMBER | Burdened cost in project ledger currency. | ||
| PFC_REVENUE | NUMBER | Revenue in project ledger currency. | ||
| PFC_LABOR_RAW_COST | NUMBER | Raw cost in project ledger currency for labor resources. | ||
| PFC_LABOR_BRDN_COST | NUMBER | Burdened cost in project ledger currency for labor resources. | ||
| PFC_EQUIPMENT_RAW_COST | NUMBER | Raw cost in project ledger currency for equipment resources. | ||
| PFC_EQUIPMENT_BRDN_COST | NUMBER | Burdened cost in project ledger currency for equipment resources. | ||
| PFC_ACT_RAW_COST | NUMBER | Actual raw cost in project ledger currency. | ||
| PFC_ACT_BRDN_COST | NUMBER | Actual burdened cost in project ledger currency. | ||
| PFC_ACT_REVENUE | NUMBER | Actual revenue in project ledger currency. | ||
| PFC_ACT_LABOR_RAW_COST | NUMBER | Actual raw cost in project ledger currency for labor resources. | ||
| PFC_ACT_LABOR_BRDN_COST | NUMBER | Actual burdened cost in project ledger currency for labor resources. | ||
| PFC_ACT_EQUIP_RAW_COST | NUMBER | Actual raw cost in project ledger currency for equipment resources. | ||
| PFC_ACT_EQUIP_BRDN_COST | NUMBER | Actual burdened cost in project ledger currency for equipment resources. | ||
| PFC_ACT_BILL_RAW_COST | NUMBER | Actual billable raw cost in project ledger currency. | ||
| PFC_ACT_BILL_BRDN_COST | NUMBER | Actual billable labor cost in project ledger currency. | ||
| PFC_ETC_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency. | ||
| PFC_ETC_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency. | ||
| PFC_ETC_REVENUE | NUMBER | Estimate-to-complete revenue in project ledger currency. | ||
| PFC_ETC_LABOR_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency for labor resources. | ||
| PFC_ETC_LABOR_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency for labor resources. | ||
| PFC_ETC_EQUIP_RAW_COST | NUMBER | Estimate-to-complete raw cost in project ledger currency for equipment resources. | ||
| PFC_ETC_EQUIP_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in project ledger currency for equipment resources. | ||
| PFC_SUP_INV_CMT_RAW_COST | NUMBER | Raw cost in project ledger currency associated with supplier invoices. | ||
| PFC_SUP_INV_CMT_BRDN_COST | NUMBER | Burdened cost in project ledger currency associated with supplier invoices. | ||
| PFC_PO_CMT_RAW_COST | NUMBER | Raw cost in project ledger currency associated with purchase orders. | ||
| PFC_PO_CMT_BRDN_COST | NUMBER | Burdened cost in project ledger currency associated with purchase orders. | ||
| PFC_PR_CMT_RAW_COST | NUMBER | Raw cost in project ledger currency associated with purchase requisitions. | ||
| PFC_PR_CMT_BRDN_COST | NUMBER | Burdened cost in project ledger currency associated with purchase requisitions. | ||
| PFC_OTH_CMT_RAW_COST | NUMBER | Raw cost in project ledger currency associated with external commitments. | ||
| PFC_OTH_CMT_BRDN_COST | NUMBER | Burdened cost in project ledger currency associated with external commitments. | ||
| TC_RAW_COST | NUMBER | Raw cost in transaction currency. | ||
| TC_BRDN_COST | NUMBER | Burdened cost in transaction currency. | ||
| TC_REVENUE | NUMBER | Revenue in transaction currency. | ||
| TC_LABOR_RAW_COST | NUMBER | Raw cost in transaction currency associated with labor resources. | ||
| TC_LABOR_BRDN_COST | NUMBER | Burdened cost in transaction currency associated with labor resources. | ||
| TC_EQUIPMENT_RAW_COST | NUMBER | Raw cost in project ledger currency associated with equipment resources. | ||
| TC_EQUIPMENT_BRDN_COST | NUMBER | Burdened cost in project ledger currency associated with equipment resources. | ||
| TC_ACT_RAW_COST | NUMBER | Actual raw cost in transaction currency. | ||
| TC_ACT_BRDN_COST | NUMBER | Actual burdened cost in transaction currency. | ||
| TC_ACT_REVENUE | NUMBER | Actual revenue in transaction currency. | ||
| TC_ACT_LABOR_RAW_COST | NUMBER | Actual raw cost in transaction currency associated with labor resources. | ||
| TC_ACT_LABOR_BRDN_COST | NUMBER | Actual burdened cost in transaction currency associated with labor resources. | ||
| TC_ACT_EQUIP_RAW_COST | NUMBER | Actual raw cost in transaction currency associated with equipment resources. | ||
| TC_ACT_EQUIP_BRDN_COST | NUMBER | Actual burdened cost in transaction currency associated with equipment resources. | ||
| TC_ACT_BILL_RAW_COST | NUMBER | Actual billable raw cost in transaction currency. | ||
| TC_ACT_BILL_BRDN_COST | NUMBER | Actual billable burdened cost in transaction currency. | ||
| TC_ETC_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency. | ||
| TC_ETC_BRDN_COST | NUMBER | Estimate-to-complete burdened cost in transaction currency. | ||
| TC_ETC_REVENUE | NUMBER | Estimate-to-complete revenue in transaction currency. | ||
| TC_ETC_LABOR_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with labor resources. | ||
| TC_ETC_LABOR_BRDN_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with labor resources. | ||
| TC_ETC_EQUIP_RAW_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with equipment resources. | ||
| TC_ETC_EQUIP_BRDN_COST | NUMBER | Estimate-to-complete cost in transaction currency associated with equipment resources. | ||
| TC_SUP_INV_CMT_RAW_COST | NUMBER | Raw cost associated with supplier invoices in transaction currency. | ||
| TC_SUP_INV_CMT_BRDN_COST | NUMBER | Burdened cost associated with supplier invoices in transaction currency. | ||
| TC_PO_CMT_RAW_COST | NUMBER | Raw cost associated with purchase orders in transaction currency. | ||
| TC_PO_CMT_BRDN_COST | NUMBER | Burdened cost associated with purchase orders in transaction currency. | ||
| TC_PR_CMT_RAW_COST | NUMBER | Raw cost associated with purchase requisitions in transaction currency. | ||
| TC_PR_CMT_BRDN_COST | NUMBER | Burdened cost associated with purchase requisitions in transaction currency. | ||
| TC_OTH_CMT_RAW_COST | NUMBER | Raw cost associated with external commitments in transaction currency. | ||
| TC_OTH_CMT_BRDN_COST | NUMBER | Burdened cost associated with external commitments in transaction currency. | ||
| CMT_TO_QUANTITY | NUMBER | Effort in hours associated with transfer orders. | ||
| TC_TO_CMT_RAW_COST | NUMBER | Raw cost associated with transfer orders in transaction currency. | ||
| TC_TO_CMT_BRDN_COST | NUMBER | Burdened cost associated with transfer orders in transaction currency. | ||
| PC_TO_CMT_RAW_COST | NUMBER | Raw cost associated with transfer orders in project currency. | ||
| PC_TO_CMT_BRDN_COST | NUMBER | Burdened cost associated with transfer orders in project currency. | ||
| PFC_TO_CMT_RAW_COST | NUMBER | Raw cost associated with transfer orders in project ledger currency. | ||
| PFC_TO_CMT_BRDN_COST | NUMBER | Burdened cost associated with transfer orders in project ledger currency. | ||
| CMT_RCPT_QUANTITY | NUMBER | Effort in hours associated with receipts. | ||
| TC_RCPT_CMT_RAW_COST | NUMBER | Raw cost associated with receipts in transaction currency. | ||
| TC_RCPT_CMT_BRDN_COST | NUMBER | Burdened cost associated with receipts in transaction currency. | ||
| PC_RCPT_CMT_RAW_COST | NUMBER | Raw cost associated with receipts in project currency. | ||
| PC_RCPT_CMT_BRDN_COST | NUMBER | Burdened cost associated with receipts in project currency. | ||
| PFC_RCPT_CMT_RAW_COST | NUMBER | Raw cost associated with receipts in project ledger currency. | ||
| PFC_RCPT_CMT_BRDN_COST | NUMBER | Burdened cost associated with receipts in project ledger currency. | ||
| PFC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project ledger currency. | ||
| PC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in project currency. | ||
| TC_ACT_INVOICED | NUMBER | The actual invoiced amount of the project in transaction currency. |