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, 2024, Oracle and/or its affiliates.