PJS_AWARD_FACT
This table contains summarized actual and plan data pertaining to awards.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONTRACT_ID | NUMBER | 18 | Yes | Unique identifier of the award. | |
| PROJECT_ID | NUMBER | 18 | Yes | Unique identifier of the project that is associated with the award. | |
| TASK_ID | NUMBER | 18 | Yes | Unique identifier for the task. | |
| TOP_TASK_ID | NUMBER | 18 | Identifier of the top task. Value is identical to the TASK_ID for the top tasks. | ||
| PLAN_VERSION_ID | NUMBER | 18 | Yes | Identifier of the current baselined version of approved cost budget. | |
| AWARD_PERIOD_ID | NUMBER | 18 | Yes | Identifier for the award budget period. The award budget period is defined separately from the GL period. | |
| RBS_VERSION_ID | NUMBER | 18 | Yes | Identifier of the plannng resource breakdown structure version. | |
| RBS_ELEMENT_ID | NUMBER | 18 | Yes | Identifier of the resource breakdown structure element. | |
| MID_RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the middle level primary resource breakdown structure element. | ||
| TOP_RBS_ELEMENT_ID | NUMBER | 18 | Identifier of the top level primary resource breakdown structure element. | ||
| CURRENCY_TYPE | VARCHAR2 | 1 | Yes | Type of currency used to represent amounts from project financial plans. Value is P for project currency, F for project functional currency, or T for project transaction currency. | |
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | The three-letter ISO code associated with a currency used in projects. | |
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| RAW_COST | NUMBER | Raw cost amount for the award transaction. | |||
| BRDND_COST | NUMBER | Burdened cost amount for the award transaction. | |||
| SUP_INV_CMT_RAW_COST | NUMBER | Actual supplier invoice commitment cost for the award transaction. | |||
| SUP_INV_CMT_BRDND_COST | NUMBER | Burdened supplier invoice commitment cost amount for the award transaction. | |||
| PO_CMT_RAW_COST | NUMBER | Actual purchase order commitment cost for the award transaction. | |||
| PO_CMT_BRDND_COST | NUMBER | Burdened purchase order commitment cost amount for the award transaction. | |||
| PR_CMT_RAW_COST | NUMBER | Actual requisition commitment cost for the award transaction. | |||
| PR_CMT_BRDND_COST | NUMBER | Burdened requisition commitment cost amount for the award transaction. | |||
| OTH_CMT_RAW_COST | NUMBER | External or third party commitment cost for the award transaction. | |||
| OTH_CMT_BRDND_COST | NUMBER | External or third party burdened commitment cost for the award transaction. | |||
| REVENUE | NUMBER | Actual revenue recognized from Oracle Fusion Project Billing. | |||
| INVOICE_AMT | NUMBER | Actual amount invoiced from Oracle Fusion Project Billing and Oracle Fusion Receivables. | |||
| UNPAID_AMT | NUMBER | Difference between the actual amount invoiced and invoiced amount paid in Oracle Fusion Receivables. | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| FUNDING_SOURCE_ID | NUMBER | 18 | Identifier of the award funding source. | ||
| TO_CMT_RAW_COST | NUMBER | Raw cost committed through transfer orders. | |||
| TO_CMT_BRDND_COST | NUMBER | Burdened cost committed through transfer orders. | |||
| RCPT_CMT_RAW_COST | NUMBER | Raw cost committed through receipts. | |||
| RCPT_CMT_BRDND_COST | NUMBER | Burdened cost committed through receipts. | |||
| TTL_CMT_RAW_COST | NUMBER | Total raw cost that is committed. | |||
| TTL_CMT_BRDND_COST | NUMBER | Total burdened cost that is committed. | |||
| 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_NUM_11 | NUMBER | Oracle internal use only. | |||
| ADDL_ATTRIBUTE_NUM_12 | 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. | ||
| 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 |
|---|---|---|---|
| PJS_AWARD_FACT_U1 | Unique | Default | CONTRACT_ID, PROJECT_ID, TASK_ID, PLAN_VERSION_ID, AWARD_PERIOD_ID, RBS_VERSION_ID, RBS_ELEMENT_ID, CURRENCY_TYPE, CURRENCY_CODE, FUNDING_SOURCE_ID |