DW_AWARD_DEPARTMENT_CREDIT_D (Preview)

This table requires activation of Grants Management functional area. Table to store Department Credits. Same table is used to store Department Credits at Award level as well as Award Project level.

Details

Module: Grants Management

Key Columns

AWARD_DEPARTMENT_CREDIT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AWARD_DEPARTMENT_CREDIT_ID NUMBER 38 0 True Primary key of the table.    
SOURCE_RECORD_ID VARCHAR2 256     System    
AWARD_ID NUMBER 38 0   Foreign Key to Award header    
AWD_PROJECT_LNK_ID NUMBER 38 0   Award Project linkage id    
ORGANIZATION_ID NUMBER 38 0   Department    
DEPARTMENT_CREDIT NUMBER       Department Credit - cannot be more than 100 percent    
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, 2023, Oracle and/or its affiliates.