PJS_PERF_SUMMARY_FACT
Stores aggregated cost, revenue, invoice, budget, forecast, commitment, and plan information to support profitability and variance analysis.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJS_PERF_SUMMARY_FACT_PK |
SUMMARY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| SUMMARY_ID | NUMBER | 18 | Yes | The unique identifier of the record. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| PROJECT_ID | NUMBER | 18 | The unique identifier of the project. | ||
| TASK_ID | NUMBER | 18 | The unique identifier of the project task. | ||
| CONTRACT_ID | NUMBER | 18 | The unique identifier of the project contract. | ||
| CONTRACT_LINE_ID | NUMBER | 18 | The unique identifier of the project contract line. | ||
| CONTRACT_PROJECT_LINKAGE_ID | NUMBER | 18 | The unique identifier of the project contract linkage. | ||
| AWARD_ID | NUMBER | 18 | The unique identifier of an award. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | The unique identifier of a funding source. | ||
| AWARD_PERIOD_ID | NUMBER | 18 | The unique identifier of the award period. | ||
| GL_PERIOD_NAME | VARCHAR2 | 15 | The name of the receiver ledger period. | ||
| GL_PERIOD_SET_NAME | VARCHAR2 | 15 | The name of the receiver ledger calendar. | ||
| GL_PERIOD_TYPE | VARCHAR2 | 15 | The type of the receiver ledger period. For example: Year, Month, and Quarter. | ||
| PA_PERIOD_NAME | VARCHAR2 | 15 | The name of the project accounting period. | ||
| PA_PERIOD_SET_NAME | VARCHAR2 | 15 | The name of the project accounting calendar. | ||
| PA_PERIOD_TYPE | VARCHAR2 | 15 | The type of the project accounting period. For example: Year, Month, and Quarter. | ||
| EXPENDITURE_ORGANIZATION_ID | NUMBER | 18 | The unique identifier of the project cost organization. | ||
| PERSON_ID | NUMBER | 18 | The unique identifier of a person associated with the project. | ||
| JOB_ID | NUMBER | 18 | The unique identifier of a person's job. | ||
| VENDOR_ID | NUMBER | 18 | The unique identifier of a supplier. | ||
| EXPENDITURE_TYPE_ID | NUMBER | 18 | The unique identifier of a cost type. | ||
| EXPENDITURE_CATEGORY_ID | NUMBER | 18 | The unique identifier of a cost category. | ||
| RESOURCE_CLASS_ID | NUMBER | 18 | The unique identifier of a resource classification. | ||
| NON_LABOR_RESOURCE_ID | NUMBER | 18 | The unique identifier of a nonlabor resource. | ||
| REVENUE_CATEGORY | VARCHAR2 | 30 | The unique code associated with a revenue category. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | The unique identifier of an inventory item. | ||
| INVENTORY_ITEM_ORGANIZATION_ID | NUMBER | 18 | The unique identifier of the organization associated with an inventory item. | ||
| INVENTORY_ITEM_CATEGORY_ID | NUMBER | 18 | The unique identifier of an inventory item category. | ||
| PROJECT_ROLE_ID | NUMBER | 18 | The unique identifier of a project role. | ||
| PERSON_TYPE | VARCHAR2 | 30 | The unique code associated with a person type. | ||
| EVENT_TYPE_ID | NUMBER | 18 | The unique identifier of a billing event. | ||
| CURRENCY_CODE_TC | VARCHAR2 | 15 | The unique code associated with a transaction currency. | ||
| CURRENCY_CODE_PC | VARCHAR2 | 15 | The unique code associated with a project currency. | ||
| CURRENCY_CODE_PFC | VARCHAR2 | 15 | The unique code associated with a project functional currency. | ||
| CURRENCY_CODE_CC | VARCHAR2 | 15 | The unique code associated with a contract currency. | ||
| UOM_CODE | VARCHAR2 | 30 | The unique code associated with a unit of measure. | ||
| RECVR_BUSINESS_UNIT_ID | NUMBER | 18 | The unique identifier of a receiver business unit. | ||
| RECVR_LEDGER_ID | NUMBER | 18 | The unique identifier of a receiver ledger. | ||
| CMT_APPROVED_FLAG | VARCHAR2 | 1 | Flag that indicates whether a commitment is approved. | ||
| RECORD_TYPE | VARCHAR2 | 30 | The unique code that identifies the type of data in the record. | ||
| RAW_COST_TC | NUMBER | The raw cost associated with a transaction in the transaction currency. | |||
| RAW_COST_PC | NUMBER | The raw cost associated with a transaction in the project currency. | |||
| RAW_COST_PFC | NUMBER | The raw cost associated with a transaction in the project functional currency. | |||
| BILLABLE_RAW_COST_TC | NUMBER | The billable raw cost associated with a transaction in the transaction currency. | |||
| BILLABLE_RAW_COST_PC | NUMBER | The billable raw cost associated with a transaction in the project currency. | |||
| BILLABLE_RAW_COST_PFC | NUMBER | The billable raw cost associated with a transaction in the project functional currency. | |||
| CAP_RAW_COST_TC | NUMBER | The capitalizable raw cost of a transaction in the transaction currency. | |||
| CAP_RAW_COST_PC | NUMBER | The capitalizable raw cost of a transaction in the project currency. | |||
| CAP_RAW_COST_PFC | NUMBER | The capitalizable raw cost of a transaction in the project functional currency. | |||
| EXPENSE_RAW_COST_TC | NUMBER | The expensed raw cost associated with a transaction in the transaction currency. | |||
| EXPENSE_RAW_COST_PC | NUMBER | The expensed raw cost associated with a transaction in the project currency. | |||
| EXPENSE_RAW_COST_PFC | NUMBER | The expensed raw cost associated with a project transaction in the project functional currency. | |||
| BRDND_COST_TC | NUMBER | The burdened cost of a transaction in the transaction currency. | |||
| BRDND_COST_PC | NUMBER | The burdened cost of a transaction in the project currency. | |||
| BRDND_COST_PFC | NUMBER | The burdened cost of a transaction in the project functional currency. | |||
| BILLABLE_BRDND_COST_TC | NUMBER | The billable burdened cost of a transaction in the transaction currency. | |||
| BILLABLE_BRDND_COST_PC | NUMBER | The billable burdened cost of a transaction in the project currency. | |||
| BILLABLE_BRDND_COST_PFC | NUMBER | The billable burdened cost of a transaction in the project functional currency. | |||
| CAP_BRDND_COST_TC | NUMBER | The capitalizable burdened cost of a transaction in the transaction currency. | |||
| CAP_BRDND_COST_PC | NUMBER | The capitalizable burdened cost of a transaction in the project currency. | |||
| CAP_BRDND_COST_PFC | NUMBER | The capitalizable burdened cost of a transaction in the project functional currency. | |||
| EXPENSE_BRDND_COST_TC | NUMBER | The expensed burdened cost of a transaction in the transaction currency. | |||
| EXPENSE_BRDND_COST_PC | NUMBER | The expensed burdened cost of a transaction in the project currency. | |||
| EXPENSE_BRDND_COST_PFC | NUMBER | The expensed burdened cost of a transaction in the project functional currency. | |||
| REVENUE_TC | NUMBER | The revenue associated with a transaction in the transaction currency. | |||
| REVENUE_PC | NUMBER | The revenue associated with a transaction in the project currency. | |||
| REVENUE_PFC | NUMBER | The revenue associated with a transaction in the project functional currency. | |||
| REVENUE_CC | NUMBER | The revenue associated with a transaction in the contract currency. | |||
| QUANTITY | NUMBER | The quantity associated with a project cost transaction. | |||
| BILLABLE_QUANTITY | NUMBER | The billable quantity associated with a project cost transaction. | |||
| CAP_QUANTITY | NUMBER | The capitalizable quantity associated with a project cost transaction. | |||
| EXPENSE_QUANTITY | NUMBER | The expensed quantity associated with a project cost transaction. | |||
| INVOICE_AMT_TC | NUMBER | The invoiced amount associated with a transaction in the transaction currency. | |||
| INVOICE_AMT_PC | NUMBER | The invoiced amount associated with a transaction in the project currency. | |||
| INVOICE_AMT_PFC | NUMBER | The invoiced amount associated with a transaction in the project functional currency. | |||
| INVOICE_AMT_CC | NUMBER | The invoiced amount associated with a transaction in the contract currency. | |||
| PREPAYMENT_REQUEST_INVOICE_TC | NUMBER | The prepayment request amount associated with a transaction in the transaction currency. | |||
| PREPAYMENT_REQUEST_INVOICE_PC | NUMBER | The prepayment request amount associated with a transaction in the project currency. | |||
| PREPAYMENT_REQUEST_INVOICE_PFC | NUMBER | The prepayment request amount associated with a transaction in the project functional currency. | |||
| PREPAYMENT_REQUEST_INVOICE_CC | NUMBER | The prepayment request amount associated with a transaction in the contract currency. | |||
| PREPAYMENT_APPLIED_INVOICE_TC | NUMBER | The prepayment applied amount associated with a transaction in the transaction currency. | |||
| PREPAYMENT_APPLIED_INVOICE_PC | NUMBER | The prepayment applied amount associated with a transaction in the project currency. | |||
| PREPAYMENT_APPLIED_INVOICE_PFC | NUMBER | The prepayment applied amount associated with a transaction in the project functional currency. | |||
| PREPAYMENT_APPLIED_INVOICE_CC | NUMBER | The prepayment applied amount associated with a transaction in the contract currency. | |||
| SUP_INV_CMT_RAW_COST_TC | NUMBER | The supplier invoice raw commitment cost associated with a transaction in the transaction currency. | |||
| SUP_INV_CMT_RAW_COST_PC | NUMBER | The supplier invoice raw commitment cost associated with a transaction in the project currency. | |||
| SUP_INV_CMT_RAW_COST_PFC | NUMBER | The supplier invoice raw commitment cost associated with a transaction in the project functional currency. | |||
| SUP_INV_CMT_BRDND_COST_TC | NUMBER | The supplier invoice burdened commitment cost associated with a transaction in the transaction currency. | |||
| SUP_INV_CMT_BRDND_COST_PC | NUMBER | The supplier invoice burdened commitment cost associated with a transaction in the project currency. | |||
| SUP_INV_CMT_BRDND_COST_PFC | NUMBER | The supplier invoice burdened commitment cost associated with a transaction in the project functional currency. | |||
| SUP_INV_CMT_QUANTITY | NUMBER | The supplier invoice commitment quantity associated with a transaction | |||
| PO_CMT_RAW_COST_TC | NUMBER | The purchase order raw commitment cost associated with a transaction in the transaction currency. | |||
| PO_CMT_RAW_COST_PC | NUMBER | The purchase order raw commitment cost associated with a transaction in the project currency. | |||
| PO_CMT_RAW_COST_PFC | NUMBER | The purchase order raw commitment cost associated with a transaction in the project functional currency. | |||
| PO_CMT_BRDN_COST_TC | NUMBER | The purchase order burdened commitment cost associated with a transaction in the transaction currency. | |||
| PO_CMT_BRDN_COST_PC | NUMBER | The purchase order burdened commitment cost associated with a transaction in the project currency. | |||
| PO_CMT_BRDN_COST_PFC | NUMBER | The purchase order burdened commitment cost associated with a transaction in the project functional currency. | |||
| PO_CMT_QUANTITY | NUMBER | The purchase order commitment quantity associated with a transaction | |||
| PR_CMT_RAW_COST_TC | NUMBER | The requisition commitment raw cost in the transaction currency. | |||
| PR_CMT_RAW_COST_PC | NUMBER | The requisition commitment raw cost in the project currency. | |||
| PR_CMT_RAW_COST_PFC | NUMBER | The requisition commitment raw cost in the project functional currency. | |||
| PR_CMT_BRDND_COST_TC | NUMBER | The requisition commitment burdened cost in the transaction currency. | |||
| PR_CMT_BRDND_COST_PC | NUMBER | The requisition commitment burdened cost in the project currency. | |||
| PR_CMT_BRDND_COST_PFC | NUMBER | The requisition commitment burdened cost in the project functional currency. | |||
| PR_CMT_QUANTITY | NUMBER | The requisition commitment quantity associated with a transaction | |||
| OTH_CMT_RAW_COST_TC | NUMBER | The other commitment raw cost in the transaction currency. | |||
| OTH_CMT_RAW_COST_PC | NUMBER | The other commitment raw cost in the project currency. | |||
| OTH_CMT_RAW_COST_PFC | NUMBER | The other commitment raw cost in the project functional currency. | |||
| OTH_CMT_BRDND_COST_TC | NUMBER | The other commitment burdened cost in the transaction currency. | |||
| OTH_CMT_BRDND_COST_PC | NUMBER | The other commitment burdened cost in the project currency. | |||
| OTH_CMT_BRDND_COST_PFC | NUMBER | The other commitment burdened cost in the project functional currency. | |||
| OTH_CMT_QUANTITY | NUMBER | The other commitment quantity associated with a transaction. | |||
| APPROVED_COST_BGT_PLAN_TYPE_ID | NUMBER | 18 | The unique identifier of the current and original baselined approved cost budget plan type. | ||
| CURR_COST_BGT_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the current baselined approved cost budget plan. | ||
| CURR_COST_BGT_RAW_COST_TC | NUMBER | The raw cost associated with the current baselined approved cost budget in the transaction currency. | |||
| CURR_COST_BGT_RAW_COST_PC | NUMBER | The raw cost associated with the current baselined approved cost budget in the project currency. | |||
| CURR_COST_BGT_RAW_COST_PFC | NUMBER | The raw cost associated with the current baselined approved cost budget in the project functional currency. | |||
| CURR_COST_BGT_BRDND_COST_TC | NUMBER | The burdened cost associated with the current baselined approved cost budget in the transaction currency. | |||
| CURR_COST_BGT_BRDND_COST_PC | NUMBER | The burdened raw cost associated with the current baselined approved cost budget in the project currency. | |||
| CURR_COST_BGT_BRDND_COST_PFC | NUMBER | The burdened cost associated with the current baselined approved cost budget in the project functional currency. | |||
| CURR_COST_BGT_QUANTITY | NUMBER | The current baselined approved cost budget quantity. | |||
| APPROVED_REV_BGT_PLAN_TYPE_ID | NUMBER | 18 | The unique identifier of the current and original baselined approved revenue budget plan type. | ||
| CURR_REV_BGT_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the current baselined approved revenue budget plan version. | ||
| CURR_REV_BGT_REVENUE_TC | NUMBER | The revenue associated with the current baselined approved revenue budget in the transaction currency. | |||
| CURR_REV_BGT_REVENUE_PC | NUMBER | The revenue associated with the current baselined approved revenue budget in the project currency. | |||
| CURR_REV_BGT_REVENUE_PFC | NUMBER | The revenue associated with the current baselined approved revenue budget in the project functional currency. | |||
| ORIG_COST_BGT_PLAN_VER_ID | NUMBER | The unique identifier of the original baselined approved cost budget plan version. | |||
| ORIG_COST_BGT_RAW_COST_TC | NUMBER | The raw cost associated with the original baselined approved cost budget in the transaction currency. | |||
| ORIG_COST_BGT_RAW_COST_PC | NUMBER | The raw cost associated with the original baselined approved cost budget in the project currency. | |||
| ORIG_COST_BGT_RAW_COST_PFC | NUMBER | The raw cost associated with the original baselined approved cost budget in the project functional currency. | |||
| ORIG_COST_BGT_BRDND_COST_TC | NUMBER | The burdened cost associated with the original baselined approved cost budget in the transaction currency. | |||
| ORIG_COST_BGT_BRDND_COST_PC | NUMBER | The burdened cost associated with the original baselined approved cost budget in the project currency. | |||
| ORIG_COST_BGT_BRDND_COST_PFC | NUMBER | The burdened cost associated with the original baselined approved cost budget in the project functional currency. | |||
| ORIG_COST_BGT_QUANTITY | NUMBER | The original baselined approved cost budget quantity. | |||
| ORIG_REV_BGT_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the original baselined approved revenue budget plan version. | ||
| ORIG_REV_BGT_REVENUE_TC | NUMBER | The revenue associated with the original baselined approved revenue budget in the transaction currency. | |||
| ORIG_REV_BGT_REVENUE_PC | NUMBER | The revenue associated with the original baselined approved revenue budget in the project currency. | |||
| ORIG_REV_BGT_REVENUE_PFC | NUMBER | The revenue associated with the original baselined approved revenue budget in the project functional currency. | |||
| PRIM_COST_FCST_PLAN_TYPE_ID | NUMBER | 18 | The unique identifier of the primary cost approved forecast plan type. | ||
| PRIM_COST_FCST_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the primary cost approved forecast plan version. | ||
| PRIM_COST_FCST_RAW_COST_TC | NUMBER | The raw cost associated with the primary cost approved forecast in the transaction currency. | |||
| PRIM_COST_FCST_RAW_COST_PC | NUMBER | The raw cost associated with the primary cost approved forecast in the project currency. | |||
| PRIM_COST_FCST_RAW_COST_PFC | NUMBER | The raw cost associated with the primary cost approved forecast in the project functional currency. | |||
| PRIM_COST_FCST_BRDND_COST_TC | NUMBER | The burdened cost associated with the primary cost approved forecast in the transaction currency. | |||
| PRIM_COST_FCST_BRDND_COST_PC | NUMBER | The burdened cost associated with the primary cost approved forecast in the project currency. | |||
| PRIM_COST_FCST_BRDND_COST_PFC | NUMBER | The burdened cost associated with the primary cost approved forecast in the project functional currency. | |||
| PRIM_COST_FCST_QUANTITY | NUMBER | The primary cost approved forecast quantity. | |||
| PRIM_REV_FCST_PLAN_TYPE_ID | NUMBER | 18 | The unique identifier of the primary revenue approved forecast plan type. | ||
| PRIM_REV_FCST_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the primary revenue approved forecast plan version. | ||
| PRIM_REV_FCST_REVENUE_TC | NUMBER | The revenue associated with the primary revenue approved forecast in the transaction currency. | |||
| PRIM_REV_FCST_REVENUE_PC | NUMBER | The revenue associated with the primary revenue approved forecast in the project currency. | |||
| PRIM_REV_FCST_REVENUE_PFC | NUMBER | The revenue associated with the primary revenue approved forecast in the project functional currency. | |||
| PRIO_COST_FCST_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the prior cost approved forecast plan version. | ||
| PRIO_COST_FCST_RAW_COST_TC | NUMBER | The raw cost associated with the prior cost approved forecast in the transaction currency. | |||
| PRIO_COST_FCST_RAW_COST_PC | NUMBER | The raw cost associated with the prior cost approved forecast in the project currency. | |||
| PRIO_COST_FCST_RAW_COST_PFC | NUMBER | The raw cost associated with the prior cost approved forecast in the project functional currency. | |||
| PRIO_COST_FCST_BRDND_COST_TC | NUMBER | The burdened cost associated with the prior cost approved forecast in the transaction currency. | |||
| PRIO_COST_FCST_BRDND_COST_PC | NUMBER | The burdened cost associated with the prior cost approved forecast in the project currency. | |||
| PRIO_COST_FCST_BRDND_COST_PFC | NUMBER | The burdened cost associated with the prior cost approved forecast in the project functional currency. | |||
| PRIO_COST_FCST_QUANTITY | NUMBER | The prior cost approved forecast quantity. | |||
| PRIO_REV_FCST_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the prior revenue approved forecast plan version. | ||
| PRIO_REV_FCST_REVENUE_TC | NUMBER | The revenue associated with the prior revenue approved forecast in the transaction currency. | |||
| PRIO_REV_FCST_REVENUE_PC | NUMBER | The revenue associated with the prior revenue approved forecast in the project currency. | |||
| PRIO_REV_FCST_REVENUE_PFC | NUMBER | The revenue associated with the prior revenue approved forecast in the project functional currency. | |||
| CURR_USR_PLAN_3_VER_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 3 plan version. | ||
| CURR_USR_PLAN_3_TYPE_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 3 plan type. | ||
| CURR_USR_PLAN_3_RAW_COST_TC | NUMBER | The raw cost associated with the current user Plan Type 3 in the transaction currency. | |||
| CURR_USR_PLAN_3_RAW_COST_PC | NUMBER | The raw cost associated with the current user Plan Type 3 in the project currency. | |||
| CURR_USR_PLAN_3_RAW_COST_PFC | NUMBER | The raw cost associated with the current user Plan Type 3 in the project functional currency. | |||
| CURR_USR_PLAN_3_BRDND_COST_TC | NUMBER | The burdened cost associated with the current user Plan Type 3 in the transaction currency. | |||
| CURR_USR_PLAN_3_BRDND_COST_PC | NUMBER | The burdened cost associated with the current user Plan Type 3 in the project currency. | |||
| CURR_USR_PLAN_3_BRDND_COST_PFC | NUMBER | The burdened cost associated with the current user Plan Type 3 in the project functional currency. | |||
| CURR_USR_PLAN_3_REVENUE_TC | NUMBER | The revenue associated with the current user Plan Type 3 in the transactional currency. | |||
| CURR_USR_PLAN_3_REVENUE_PC | NUMBER | The revenue associated with the current user Plan Type 3 in the project currency. | |||
| CURR_USR_PLAN_3_REVENUE_PFC | NUMBER | The revenue associated with the current user Plan Type 3 in the project functional currency. | |||
| CURR_USR_PLAN_3_QUANTITY | NUMBER | The current user Plan Type 3 quantity. | |||
| CURR_USR_PLAN_4_VER_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 4 plan version. | ||
| CURR_USR_PLAN_4_TYPE_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 4 plan type. | ||
| CURR_USR_PLAN_4_RAW_COST_TC | NUMBER | The raw cost associated with the current user Plan Type 4 in the transaction currency. | |||
| CURR_USR_PLAN_4_RAW_COST_PC | NUMBER | The raw cost associated with the current user Plan Type 4 in the project currency. | |||
| CURR_USR_PLAN_4_RAW_COST_PFC | NUMBER | The raw cost associated with the current user Plan Type 4 in the project functional currency. | |||
| CURR_USR_PLAN_4_BRDND_COST_TC | NUMBER | The burdened cost associated with the current user Plan Type 4 in the transaction currency. | |||
| CURR_USR_PLAN_4_BRDND_COST_PC | NUMBER | The burdened cost associated with the current user Plan Type 4 in the project currency. | |||
| CURR_USR_PLAN_4_BRDND_COST_PFC | NUMBER | The burdened cost associated with the current user Plan Type 4 in the project functional currency. | |||
| CURR_USR_PLAN_4_REVENUE_TC | NUMBER | The revenue associated with the current user Plan Type 4 in the transaction currency. | |||
| CURR_USR_PLAN_4_REVENUE_PC | NUMBER | The revenue associated with the current user Plan Type 4 in the project currency. | |||
| CURR_USR_PLAN_4_REVENUE_PFC | NUMBER | The revenue associated with the current user Plan Type 4 in the project functional currency. | |||
| CURR_USR_PLAN_4_QUANTITY | NUMBER | The current user Plan Type 4 quantity. | |||
| CURR_USR_PLAN_5_VER_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 5 plan version. | ||
| CURR_USR_PLAN_5_TYPE_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 5 plan type. | ||
| CURR_USR_PLAN_5_RAW_COST_TC | NUMBER | The raw cost associated with the current user Plan Type 5 in the transaction currency. | |||
| CURR_USR_PLAN_5_RAW_COST_PC | NUMBER | The raw cost associated with the current user Plan Type 5 in the project currency. | |||
| CURR_USR_PLAN_5_RAW_COST_PFC | NUMBER | The raw cost associated with the current user Plan Type 5 in the project functional currency. | |||
| CURR_USR_PLAN_5_BRDND_COST_TC | NUMBER | The burdened cost associated with the current user Plan Type 5 in the transaction currency. | |||
| CURR_USR_PLAN_5_BRDND_COST_PC | NUMBER | The burdened cost associated with the current user Plan Type 5 in the project currency. | |||
| CURR_USR_PLAN_5_BRDND_COST_PFC | NUMBER | The burdened cost associated with the current user Plan Type 5 in the project functional currency. | |||
| CURR_USR_PLAN_5_REVENUE_TC | NUMBER | The revenue associated with the current user Plan Type 5 in the transaction currency. | |||
| CURR_USR_PLAN_5_REVENUE_PC | NUMBER | The revenue associated with the current user Plan Type 5 in the project currency. | |||
| CURR_USR_PLAN_5_REVENUE_PFC | NUMBER | The revenue associated with the current user Plan Type 5 in the project functional currency. | |||
| CURR_USR_PLAN_5_QUANTITY | NUMBER | The current user Plan Type 5 quantity. | |||
| CURR_USR_PLAN_6_VER_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 6 plan version. | ||
| CURR_USR_PLAN_6_TYPE_ID | NUMBER | 18 | The unique identifier of the current user Plan Type 6 plan type. | ||
| CURR_USR_PLAN_6_RAW_COST_TC | NUMBER | The raw cost associated with the current user Plan Type 6 in the transaction currency. | |||
| CURR_USR_PLAN_6_RAW_COST_PC | NUMBER | The raw cost associated with the current user Plan Type 6 in the project currency. | |||
| CURR_USR_PLAN_6_RAW_COST_PFC | NUMBER | The raw cost associated with the current user Plan Type 6 in the project functional currency. | |||
| CURR_USR_PLAN_6_BRDND_COST_TC | NUMBER | The burdened cost associated with the current user Plan Type 6 in the transaction currency. | |||
| CURR_USR_PLAN_6_BRDND_COST_PC | NUMBER | The burdened cost associated with the current user Plan Type 6 in the project currency. | |||
| CURR_USR_PLAN_6_BRDND_COST_PFC | NUMBER | The burdened cost associated with the current user Plan Type 6 in the project functional currency. | |||
| CURR_USR_PLAN_6_REVENUE_TC | NUMBER | The revenue associated with the current user Plan Type 6 in the transaction currency. | |||
| CURR_USR_PLAN_6_REVENUE_PC | NUMBER | The revenue associated with the current user Plan Type 6 in the project currency. | |||
| CURR_USR_PLAN_6_REVENUE_PFC | NUMBER | The revenue associated with the current user Plan Type 6 in the project functional currency. | |||
| CURR_USR_PLAN_6_QUANTITY | NUMBER | The current user Plan Type 6 quantity. | |||
| CW_PROJ_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the current working project plan version. | ||
| CW_PROJ_PLAN_RAW_COST_TC | NUMBER | The current working project plan raw cost in the transaction currency. | |||
| CW_PROJ_PLAN_RAW_COST_PC | NUMBER | The current working project plan raw cost in the project currency. | |||
| CW_PROJ_PLAN_RAW_COST_PFC | NUMBER | The current working project plan raw cost in the project functional currency. | |||
| CW_PROJ_PLAN_BRDND_COST_TC | NUMBER | The current working project plan burdened cost in the transaction currency. | |||
| CW_PROJ_PLAN_BRDND_COST_PC | NUMBER | The current working project plan burdened cost in the project currency. | |||
| CW_PROJ_PLAN_BRDND_COST_PFC | NUMBER | The current working project plan burdened cost in the project functional currency. | |||
| CW_PROJ_PLAN_REVENUE_TC | NUMBER | The current working project plan revenue in the transaction currency. | |||
| CW_PROJ_PLAN_REVENUE_PC | NUMBER | The current working project plan revenue in the project currency. | |||
| CW_PROJ_PLAN_REVENUE_PFC | NUMBER | The current working project plan revenue in the project functional currency. | |||
| CW_PROJ_PLAN_QUANTITY | NUMBER | The current working project plan quantity. | |||
| LP_PROJ_PLAN_VER_ID | NUMBER | 18 | The unique identifier of the latest published project plan version. | ||
| LP_PROJ_PLAN_RAW_COST_TC | NUMBER | The latest published project plan raw cost in the transaction currency. | |||
| LP_PROJ_PLAN_RAW_COST_PC | NUMBER | The latest published project plan raw cost in the project currency. | |||
| LP_PROJ_PLAN_RAW_COST_PFC | NUMBER | The latest published project plan raw cost in the project functional currency. | |||
| LP_PROJ_PLAN_BRDND_COST_TC | NUMBER | The latest published project plan burdened cost in the transaction currency. | |||
| LP_PROJ_PLAN_BRDND_COST_PC | NUMBER | The latest published project plan burdened cost in the project currency. | |||
| LP_PROJ_PLAN_BRDND_COST_PFC | NUMBER | The latest published project plan burdened cost in the project functional currency. | |||
| LP_PROJ_PLAN_REVENUE_TC | NUMBER | The latest published project plan revenue in the transaction currency. | |||
| LP_PROJ_PLAN_REVENUE_PC | NUMBER | The latest published project plan revenue in the project currency. | |||
| LP_PROJ_PLAN_REVENUE_PFC | NUMBER | The latest published project plan revenue in the project functional currency. | |||
| LP_PROJ_PLAN_QUANTITY | NUMBER | The latest published project plan quantity. | |||
| UNBILLED_AMOUNT_TC | NUMBER | The unbilled amount associated with a transaction in the transaction currency. | |||
| UNBILLED_AMOUNT_PC | NUMBER | The unbilled amount associated with a transaction in the project currency. | |||
| UNBILLED_AMOUNT_PFC | NUMBER | The unbilled amount associated with a transaction in the project functional currency. | |||
| UNBILLED_AMOUNT_CC | NUMBER | The unbilled amount associated with a transaction in the contract currency. | |||
| UNEARNED_AMOUNT_TC | NUMBER | The unearned amount associated with a transaction in the transaction currency. | |||
| UNEARNED_AMOUNT_PC | NUMBER | The unearned amount associated with a transaction in the project currency. | |||
| UNEARNED_AMOUNT_PFC | NUMBER | The unearned amount associated with a transaction in the project functional currency. | |||
| UNEARNED_AMOUNT_CC | NUMBER | The unearned amount associated with a transaction in the contract currency. | |||
| UNPAID_INV_AMOUNT_TC | NUMBER | The unpaid invoice amount associated with a transaction in the transaction currency. | |||
| UNPAID_INV_AMOUNT_PC | NUMBER | The unpaid invoice amount associated with a transaction in the project currency. | |||
| UNPAID_INV_AMOUNT_PFC | NUMBER | The unpaid invoice amount associated with a transaction in the project functional currency. | |||
| UNPAID_INV_AMOUNT_CC | NUMBER | The unpaid invoice amount associated with a transaction in the contract currency. | |||
| FUNDING_AMOUNT_CC | NUMBER | The funding amount granted for the award associated with a transaction in the contract currency. | |||
| FUND_ALLOCATED_AMOUNT_CC | NUMBER | The funding amount allocated to the award project associated with a transaction in the contract currency. | |||
| ADDL_ATTRIBUTE1 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE2 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE3 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE4 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE5 | VARCHAR2 | 150 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_PERF_SUMMARY_FACT_N1 | Non Unique | Default | PROJECT_ID, TASK_ID, GL_PERIOD_NAME |
| PJS_PERF_SUMMARY_FACT_N2 | Non Unique | Default | CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, GL_PERIOD_NAME |
| PJS_PERF_SUMMARY_FACT_N3 | Non Unique | Default | AWARD_ID, FUNDING_SOURCE_ID, AWARD_PERIOD_ID |
| PJS_PERF_SUMMARY_FACT_U1 | Unique | Default | SUMMARY_ID |