Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD CITIZENSHIP Table


View exposing graduate applicant citizenship reference data including citizenship status and nationality used for graduate admissions reporting.


Field Name

Description

Data Type

Length

ADM_GRAD_CITIZENSHIP_KEY

Surrogate key identifying the adm grad citizenship.

VARCHAR2

4

CITIZENSHIP_STATUS

Citizenship status as provided by the source.

VARCHAR2

30

IS_CITIZEN

Indicator identifying whether citizen (Y/N).

VARCHAR2

1

NATIONALITY

Nationality as provided by the source.

VARCHAR2

32

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE