Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD CONTACT Table


XXX


Field Name

Description

Data Type

Length

CONTACT_NAME

XXX

VARCHAR2

42

CONTACT_TYPE_CODE

XXX

VARCHAR2

3

CONTACT_TYPE_DESC

XXX

VARCHAR2

200

ORGANIZATION_NAME

The name of the MIT Department or Unit to which the project is assigned, usually the home unit or the Principal Investigator or Co-Investigator.

VARCHAR2

200

ROLODEX_ID

XXX

NUMBER

SUBAWARD_CODE

XXX

VARCHAR2

20

WAREHOUSE_LOAD_DATE

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

DATE