OSP AWARD PERSON Table
View exposing personnel associations with sponsored awards including investigator roles (PI, Co-PI), effort commitments, key personnel designations, and personnel sequence used for project staffing and research team reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FULL_NAME |
Full name associated with the record. |
VARCHAR2 |
90 |
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
KEY_PERSON_PROJECT_ROLE |
Key person project role associated with the record. |
VARCHAR2 |
60 |
MIT_AWARD_KEY |
Surrogate key identifying the mit award. |
VARCHAR2 |
12 |
MIT_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
PERSON_ROLE |
Person role associated with the record. |
VARCHAR2 |
10 |
PERSON_ROLE_CODE |
Code identifying person role. |
VARCHAR2 |
12 |
ROLODEX_ID |
Business identifier for the rolodex. |
VARCHAR2 |
6 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |