Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse OSP CONTACT TYPE Table


View exposing contact type reference values used to classify relationships, roles, and contact categories in sponsored project administration and communication tracking.


Field Name

Description

Data Type

Length

CONTACT_TYPE

Contact type associated with the record.

VARCHAR2

200

CONTACT_TYPE_CODE

Code identifying contact type.

VARCHAR2

3

CONTACT_TYPE_KEY

Surrogate key identifying the contact type.

VARCHAR2

3

RECORD_COUNT

Record count associated with the record.

NUMBER

28,7

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE