Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse COUNTRY OF ORIGIN Table


View exposing country-of-origin detail for people including MIT identifier, full name, country code, country name, note, activity date, and warehouse load date.


Field Name

Description

Data Type

Length

COUNTRY

Country as provided by the source.

VARCHAR2

100

COUNTRY_CODE

Code identifying country.

VARCHAR2

20

FULL_NAME

Full name as provided by the source.

VARCHAR2

90

LAST_ACTIVITY_DATE

Date associated with last activity.

DATE

MIT_ID

MIT ID number of the person. Use this field to join with other tables containing data about people at MIT.

VARCHAR2

9

NOTE

Note as provided by the source.

VARCHAR2

200

WAREHOUSE_LOAD_DATE

Date associated with warehouse load.

DATE