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.