OSP PROP INVESTIGATOR TYPE Table
View exposing proposal investigator type classifications including investigator role categories and responsibility designations used for investigator role standardization.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
IS_FACULTY |
Indicator identifying whether faculty (Y/N). |
VARCHAR2 |
1 |
IS_LEAD_UNIT |
Indicator identifying whether lead unit (Y/N). |
VARCHAR2 |
1 |
IS_NON_MIT_PERSON |
Indicator identifying whether non mit person (Y/N). |
VARCHAR2 |
1 |
IS_PRINCIPAL_INVESTIGATOR |
Indicator identifying whether principal investigator (Y/N). |
VARCHAR2 |
1 |
OSP_PROP_INVESTIGATOR_TYPE_KEY |
Surrogate key identifying the osp prop investigator type. |
VARCHAR2 |
4 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |