OSP PROPOSAL PERSONS Table
View exposing personnel roster for proposals including investigator assignments, effort commitments, roles, and key personnel designations used for research team composition analysis.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
FACULTY_FLAG |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
8 |
OSP_PROPOSAL_NUMBER |
Osp proposal number associated with the record. |
VARCHAR2 |
8 |
PERSON_ID |
MIT ID number of the person. Use this field to join with other tables containing data about people at MIT. |
VARCHAR2 |
40 |
PERSON_NAME |
Person name associated with the record. |
VARCHAR2 |
90 |
PERSON_PROJECT_ROLE |
Person project role associated with the record. |
VARCHAR2 |
60 |
PERSON_ROLE |
Person role associated with the record. |
VARCHAR2 |
12 |
ROLODEX_ID |
Business identifier for the rolodex. |
NUMBER |
|
SEQUENCE_NUMBER |
Sequence number associated with the record. |
NUMBER |
|
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |