Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP SUBAWARD CONTACT Table


View exposing subawardee contact information including principal contacts, technical contacts, and administrative contacts used for subaward communication and administration.


Field Name

Description

Data Type

Length

CONTACT_NAME

Contact name associated with the record.

VARCHAR2

42

CONTACT_TYPE_CODE

Code identifying contact type.

VARCHAR2

3

CONTACT_TYPE_DESC

Description of contact type.

VARCHAR2

200

ORGANIZATION_NAME

Organization name associated with the record.

VARCHAR2

200

ROLODEX_ID

Business identifier for the rolodex.

NUMBER

SUBAWARD_CODE

Code identifying subaward.

VARCHAR2

20

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE