This table stores Award Personnel assigned to an award (External and Internal)
Module: Grants Management
AWARD_PERSONNEL_ID
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.