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

Copyright © 2019, 2026, Oracle and/or its affiliates.