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 This column is for Oracle Internal use only. 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.