This table requires activation of Grants Management functional area. 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 | 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 | |||||
| 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, 2024, Oracle and/or its affiliates.