DW_AWARD_CERTIFICATION_D (Preview)

This table requires activation of Grants Management functional area. This table store the certification requirements specific to an award.

Details

Module: Grants Management

Key Columns

AWARD_CERTIFICATION_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
AWARD_CERTIFICATION_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    
CERTIFICATION_ID NUMBER 38 0   Certification Id    
CERTIFIED_BY NUMBER 38 0   Person who Certified the Certification    
CERTIFICATION_INDICATOR VARCHAR2 16     Indicator    
EXPEDITED_REVIEW VARCHAR2 16     whether this Certification should have a expedited review    
FULL_REVIEW VARCHAR2 16     whether this Certification should have a full committe review    
CERTIFICATION_DATE DATE       Certification Date    
APPROVAL_DATE DATE       Date Certification is approved    
EXPIRATION_DATE DATE       Expiration Date of the Certification    
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.