# DW_AWARD_PERSONNEL_D (Preview)

This table requires activation of Grants Management functional area. This table stores Award Personnel assigned to an award (External and Internal)

## Details

Module: Grants Management

## Key Columns

AWARD_PERSONNEL_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
AWARD_PERSONNEL_ID | NUMBER | 38 | 0 | True | Primary Key of the table |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System generated unique identifier. |  |
AWARD_ID | NUMBER | 38 | 0 |  | Award Identifier |  |
AWARD_PROJECT_LINK_ID | NUMBER | 38 | 0 |  | Award Project linkage id |  |
PARTY_ID | NUMBER | 38 | 0 |  | PartyId - maps to the id of External person | DW_PERSON_NAME_CURRENT_D | PERSON_ID
PERSONNEL_ID | NUMBER | 38 | 0 |  | Personnel Id - This maps to the id of internal Person | DW_PARTY_D | PARTY_ID
ROLE_ID | NUMBER | 38 | 0 |  | Unique identifier for role. |  |
PERSONNEL_NUMBER | VARCHAR2 | 32 |  |  | Personnal Number |  |
PERSONNEL_NAME | VARCHAR2 | 512 |  |  | Personnal Name |  |
START_DATE | DATE |  |  |  | Start Date of the award personnel. |  |
END_DATE | DATE |  |  |  | End Date of the award personnel. |  |
INTERNAL_FLAG | VARCHAR2 | 16 |  |  | Flag which specifies Internal or External personnel. |  |
CREDIT_PERCENT | NUMBER |  |  |  | Credit Percent- cannot be more than 100 percent |  |
CURRENT_PI_FLAG | VARCHAR2 | 16 |  |  | Flag to identify Current Principal Investigator |  |
CREATION_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |

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