Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP UNIT Table


OSP Proposal Unit Investigator


Field Name

Description

Data Type

Length

ADMINISTRATIVE_OFFICER_MIT_ID

MIT ID number of the OSP UNIT Administrative Officer

VARCHAR2

9

DEAN_VP_MIT_ID

XXX

VARCHAR2

9

OSP_ADMINISTRATOR_MIT_ID

MIT ID number of the OSP Administrator

VARCHAR2

9

OSP_UNIT_KEY

XXX

VARCHAR2

8

OSP_UNIT_NAME

Investigator Unit

VARCHAR2

60

OTHER_PERSON_TO_NOTIFY_ID

XXX

VARCHAR2

9

UNIT_HEAD_MIT_ID

MIT ID number of the OSP Unit Head

VARCHAR2

9

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8