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     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.    
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    
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, 2023, Oracle and/or its affiliates.