# DW_AWARD_PROJECTS_D (Preview)

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

## Details

Module: Grants Management

## Key Columns

AWARD_PROJECT_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AWARD_PROJECT_ID | NUMBER | 38 | 0 | True | Primary key for award Project --ID |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System generated Unique identifier. |  |
AWARD_ID | NUMBER | 38 | 0 |  | Award which this Project associated with |  |
PROJECT_ID | NUMBER | 38 | 0 |  | Project that associated with Award |  |
IDC_SCHEDULE_ID | NUMBER | 38 | 0 |  | Burden Schedule overwrite at the Project level |  |
COST_IND_SCH_FIXED_DATE | DATE |  |  |  | Burden schedule fixed date |  |
AWARD_OWNING_ORG_ID | NUMBER | 38 | 0 |  | Award Owning Organization |  |
AWARD_START_DATE | DATE |  |  |  | Start date of contract. |  |
AWARD_END_DATE | DATE |  |  |  | End date of contract. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the user who created the row. |  |

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