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 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
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.