Oracle Fusion · Data dictionary
GMS_AWARD_HEADERS_VL
SharedUsed in 29 subject areas26 reporting columns
view layer, joins the base table with translations for the current language.
Likely primary key: AWARD_HEADER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): AWARD_HEADER_ID → GMS_AWARD_HEADERS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AWARD_HEADER_ID | PK? | ○ | Identifier for the award header. |
| AWARD_PURPOSE_CODE | ● | Code identifying the award purpose. | |
| AWARD_TYPE | ● | Type of award. | |
| CLOSE_DATE | ● | Close date. | |
| COI_APPROVAL_DATE | ● | Coi approval date. | |
| COI_INST_POLICY_COMPLIANT | ● | Coi inst policy compliant. | |
| COI_REVIEW_COMPLETED | ● | Coi review completed. | |
| COST_IND_SCH_FIXED_DATE | ● | Cost ind sch fixed date. | |
| DESCRIPTION | ● | Description. | |
| EXPANDED_AUTH_FLAG | ● | Indicator (Y/N) for the expanded auth. | |
| FT_AMOUNT | ● | Ft amount. | |
| FT_FROM_DATE | ● | Ft from date. | |
| FT_IS_FEDERAL | ● | Ft is federal. | |
| FT_TO_DATE | ● | Ft to date. | |
| ID | ● | Id. | |
| IFS_APPROVAL_DATE | ● | Ifs approval date. | |
| IFS_SPONSOR_APPROVAL_REQ_FLAG | ● | Indicator (Y/N) for the ifs sponsor approval req. | |
| INTELL_PROP_DESC | ● | Description of the intell prop. | |
| IS_INTELL_PROP_REPORTED | ● | Is intell prop reported. | |
| PREV_AWARD_ABR | ● | Prev award abr. | |
| PREV_AWARD_RENEWAL_INPRG | ● | Prev award renewal inprg. | |
| PRE_AWARD_DATE | ● | Pre award date. | |
| PRE_AWARD_GSF | ● | Pre award gsf. | |
| PRE_AWARD_SPENDING_ALLOWED | ● | Pre award spending allowed. | |
| SPONSOR_AWARD_NUMBER | ● | Sponsor award number. | |
| TEMPLATE_FLAG | ● | Indicator (Y/N) for the template. | |
| VALIDATE_STATUS | ● | Status of the validate. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI, the owned conformed model joins them on shared keys.
- Costing - Cost Accounting Real Time
- Costing - Receipt Accounting Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Inventory - Inventory Transactions Real Time
- Inventory - Inventory Transfer Order Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Purchased Item Usage Real Time
- Manufacturing - Resource Usage Real Time
- Manufacturing - Work Order Performance Real Time
- Procurement - Procure To Pay Real Time
- Procurement - Purchasing Real Time
- Procurement - Requisitions Real Time
- Project Billing - Invoices Real Time
- Project Billing - Revenue Real Time
Need the extract + dbt staging for GMS_AWARD_HEADERS_VL?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table