OSP PROP INVESTIGATOR DETAIL Table
View exposing detailed proposal investigator records including PI/Co-PI designations, proposed effort, biographical sketches, and current funding status used for investigator analysis and team composition tracking.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
NON_MIT_PERSON_ORGANIZATION |
Non mit person organization associated with the record. |
VARCHAR2 |
200 |
NON_MIT_PERSON_TITLE |
Non mit person title associated with the record. |
VARCHAR2 |
35 |
OSP_INVESTIGATOR_ID |
Business identifier for the osp investigator. |
VARCHAR2 |
40 |
OSP_INVESTIGATOR_NAME |
Osp investigator name associated with the record. |
VARCHAR2 |
90 |
OSP_PROPOSAL_KEY |
Surrogate key identifying the osp proposal. |
VARCHAR2 |
10 |
OSP_PROP_INVESTIGATOR_TYPE_KEY |
Surrogate key identifying the osp prop investigator type. |
VARCHAR2 |
4 |
OSP_UNIT_KEY |
Surrogate key identifying the osp unit. |
VARCHAR2 |
8 |
PERCENTAGE_EFFORT |
Percentage effort associated with the record. |
NUMBER |
5,2 |
PROFIT_CENTER_KEY |
Surrogate key identifying the profit center. |
VARCHAR2 |
13 |
RECORD_COUNTER |
Record counter associated with the record. |
NUMBER |
28 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |