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.
Module: Grants Management
AWARD_DEPARTMENT_CREDIT_ID
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.