PJS_AWARD_OVERVIEW_FACT
This table stores current budget period burn rate metrics, budget, commitment and actual costs for an award project.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
PJS_AWARD_OVERVIEW_FACT_PK |
AWARD_ID, PROJECT_ID, CURRENCY_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AWARD_ID | NUMBER | 18 | Yes | Unique identifier of the award. | |
| PROJECT_ID | NUMBER | 18 | Yes | Unique identifier of a project that is associated with an award. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Unique identifier of the business unit. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Yes | ISO code associated with the project ledger currency. | |
| BUDGET_AMOUNT | NUMBER | Amount budgeted for the award project in the current budget period. | |||
| ACTUAL_AMOUNT | NUMBER | Actual costs captured for the award project in the current budget period. | |||
| COMMITMENT_AMOUNT | NUMBER | Commitment amount for the award project in the current budget period. | |||
| CONSUMED_AMOUNT | NUMBER | Total of actual and commitment amount for the award project in the current budget period. | |||
| CONSUMED_AMOUNT_PERC | NUMBER | Percentage of consumed amount to budget amount for the current budget period. | |||
| CONSUMPTION_STATUS | VARCHAR2 | 30 | Burn rate status of the award project for the current budget period. Valid statuses are Overspending, On track and Underspending. | ||
| OVERSPENT_PERC | NUMBER | Difference between the burn rate of the award project and the configured overspent limit. | |||
| UNDERSPENT_PERC | NUMBER | Difference between the burn rate of the award project and the configured underspent upper limit. | |||
| ONTRACK_PERC | NUMBER | Difference between the burn rate of the award project and the configured underspent limit. | |||
| BU_BURNRATE_CONFIGURED | VARCHAR2 | 1 | Flag indicating whether the burn rate thresholds are configured for the business unit. | ||
| AVAILABLE_AMOUNT | NUMBER | Amount that is available for the current budget period, after deducting the consumed amount from the budget amount. | |||
| AVAILABLE_AMOUNT_PERC | NUMBER | Percentage of available amount for the current budget period. | |||
| EXPANDED_AUTH_FLAG | VARCHAR2 | 1 | Flag indicating whether the award funding is authorized to be spent across budget periods; that is, funds are carried over from one period to another. If this flag is disabled, then funding amount cannot be carried forward to the next budget period. This is called restricted authority spending. | ||
| BP_START_DATE | DATE | Yes | Start date of the current award budget period. | ||
| BP_END_DATE | DATE | Yes | End date of the current award budget period. | ||
| TIME_SPEND_PERC | NUMBER | Percentage of elapsed time for the current budget period. | |||
| BURN_RATE | NUMBER | Metric that represents the projected spend for the remainder of the award duration, based on the amount consumed in the current duration. | |||
| OVERSPENT_AMOUNT_DELTA | NUMBER | Spent amount that exceeds the budget amount for the current budget period. | |||
| DAYS_TO_OVERSPENT | NUMBER | Number of days spent that exceeds the budget amount for the current budget period. | |||
| TIME_SPEND_DAY | NUMBER | Elapsed time for the award project in the current budget period. | |||
| TIME_REMAIN_DAY | NUMBER | Remaining days for the award project in the current budget period. | |||
| BP_NAME | VARCHAR2 | 15 | Yes | Name of the current budget period. | |
| 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. | |
| 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. | ||
| CURRENCY_TYPE | VARCHAR2 | 1 | Yes | Type of the currency in which summarized data is created. | |
| 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. | ||
| ADDL_ATTRIBUTE6 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE7 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE8 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE9 | VARCHAR2 | 150 | Oracle internal use only. | ||
| ADDL_ATTRIBUTE10 | VARCHAR2 | 150 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJS_AWARD_OVERVIEW_FACT_U1 | Unique | Default | AWARD_ID, PROJECT_ID, CURRENCY_TYPE |