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