# DW_AWARD_D (Preview)

This table requires activation of Grants Management functional area. This table stores Project Awards Details.

## Details

Module: Grants Management

## Key Columns

AWARD_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AWARD_ID | NUMBER | 38 | 0 | True | Primary Key, Unique identifier of award header |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System genrated unique key. |  |
BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business Unit Id |  |
SPONSOR_ID | NUMBER | 38 | 0 |  | Sponsor Party Id (From GMS_SPONSORS table) |  |
AWARD_OWNING_ORG_ID | NUMBER | 38 | 0 |  | Award Owning Organization |  |
INSTITUTION_ID | NUMBER | 38 | 0 |  | Awarded Institution |  |
LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal Entity Identifier of Award. |  |
AWARD_PURPOSE_CODE | VARCHAR2 | 32 |  |  | Award Purpose |  |
AWARD_TYPE | VARCHAR2 | 32 |  |  | Award Type |  |
SPONSOR_AWARD_NUMBER | VARCHAR2 | 32 |  |  | Sponsor Award Number |  |
AWARD_NUMBER | VARCHAR2 | 128 |  |  | Contract number of contract. |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Contract's transaction currency. |  |
STATUS_CODE | VARCHAR2 | 32 |  |  | User status of the contract. |  |
AWARD_START_DATE | DATE |  |  |  | Start date of contract. |  |
AWARD_END_DATE | DATE |  |  |  | End date of contract. |  |
VALIDATE_STATUS | VARCHAR2 | 16 |  |  | Validation Status, N -- for Not validated, C -- Clean, E -- Error, W -- Warning, P -- Pending Calendar Update. |  |
EXPANDED_AUTH_FLAG | VARCHAR2 | 16 |  |  | Expanded authority flag |  |
IS_INTELL_PROP_REPORTED | VARCHAR2 | 16 |  |  | Intellectual Property Reported Flag |  |
CLOSE_DATE | DATE |  |  |  | Award Close Date |  |
PRE_AWARD_DATE | DATE |  |  |  | Pre-award spending date |  |
PRE_AWARD_SPENDING_ALLOWED | VARCHAR2 | 16 |  |  | Previous Award - Spending Allowed Flag |  |
PREV_AWARD_ID | NUMBER | 38 | 0 |  | Previous award ID |  |
PREV_AWARD_RENEWAL_INPRG | VARCHAR2 | 16 |  |  | Previous award Renewal In Progress Flag |  |
PREV_AWARD_ABR | VARCHAR2 | 16 |  |  | Previous award - Accomplishment Based Renewal |  |
PREV_AWARD_BU | NUMBER | 38 | 0 |  | Previous award Business Unit |  |
FLOW_THROUGH_FROM_DATE | DATE |  |  |  | Flow Through - From Date |  |
FLOW_THROUGH_PRIMARY_SPONSOR | NUMBER | 38 | 0 |  | Flow Through - Primary Sponsor |  |
FLOW_THROUGH_IS_FEDERAL | VARCHAR2 | 16 |  |  | Flow Through - Is Federal Flag |  |
FLOW_THROUGH_TO_DATE | DATE |  |  |  | Flow Through - To Date |  |
FLOW_THROUGH_AMOUNT | NUMBER |  |  |  | Flow Through - Amount |  |
COI_INST_POLICY_COMPLIANT | VARCHAR2 | 16 |  |  | Conflict Of Interest Policy Compliance Flag |  |
COI_REVIEW_COMPLETED | VARCHAR2 | 16 |  |  | Conflict Of Interest Review Completion Status |  |
IDC_SCHEDULE_ID | NUMBER | 38 | 0 |  | Award default burden schedule |  |
COST_IND_SCH_FIXED_DATE | DATE |  |  |  | Indirect Cost schedule fixed date |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.