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.