Data Warehouse

CITIZENSHIP_INDICATOR

Indicator identifying whether citizenship (Y/N).

VARCHAR2

2

CITIZENSHIP_INDICATOR_DESC

Description of citizenship indicator.

VARCHAR2

100

COUNTRY_ORIGIN_CODE

Code identifying country origin.

VARCHAR2

2

COUNTRY_ORIGIN_DESC

Description of country origin.

VARCHAR2

100

FULL_NAME

Full name associated with the person or organization.

VARCHAR2

110

IPEDS_ETHNIC_CODE

Code identifying ipeds ethnic.

VARCHAR2

2

IPEDS_ETHNIC_DESC

Description of ipeds ethnic.

VARCHAR2

100

IS_AMERICAN_INDIAN_ALASKA_NATV

Indicator identifying whether american indian alaska natv (Y/N).

VARCHAR2

1

IS_AMER_INDIAN_ALASKA_NATV_IR

Indicator identifying whether amer indian alaska natv ir (Y/N).

VARCHAR2

1

IS_ASIAN

Indicator identifying whether asian (Y/N).

VARCHAR2

1

IS_ASIAN_IR

Indicator identifying whether asian ir (Y/N).

VARCHAR2

1

IS_BLACK_OR_AFRICAN_AMERICAN

Indicator identifying whether black or african american (Y/N).

VARCHAR2

1

IS_BLACK_OR_AFRICAN_AMER_IR

Indicator identifying whether black or african amer ir (Y/N).

VARCHAR2

1

IS_CURRENT_STUDENT

Indicator identifying whether current student (Y/N).

VARCHAR2

1

IS_HISPANIC_OR_LATINO

Indicator identifying whether hispanic or latino (Y/N).

VARCHAR2

1

IS_HISPANIC_OR_LATINO_IR

Indicator identifying whether hispanic or latino ir (Y/N).

VARCHAR2

1

IS_INTERNATIONAL_NOT_CITZ_PR

Indicator identifying whether international not citz pr (Y/N).

VARCHAR2

1

IS_INTERNTL_NOT_CITZ_PR_IR

Indicator identifying whether interntl not citz pr ir (Y/N).

VARCHAR2

1

IS_MORE_THAN_ONE_RACE_REPORTED

Indicator identifying whether more than one race reported (Y/N).

VARCHAR2

1

IS_MORE_THAN_ONE_RACE_REP_IR

Indicator identifying whether more than one race rep ir (Y/N).

VARCHAR2

1

IS_NATIVE_HAWAIIAN_PACIFIC_ISL

Indicator identifying whether native hawaiian pacific isl (Y/N).

VARCHAR2

1

IS_NATIVE_HAWAIIAN_PAC_ISL_IR

Indicator identifying whether native hawaiian pac isl ir (Y/N).

VARCHAR2

1

IS_NO_ETHNICITY_ON_RECORD

Indicator identifying whether no ethnicity on record (Y/N).

VARCHAR2

1

IS_NO_ETHNICITY_ON_RECORD_IR

Indicator identifying whether no ethnicity on record ir (Y/N).

VARCHAR2

1

IS_RACE_ETHNICITY_UNKNOWN

Indicator identifying whether race ethnicity unknown (Y/N).

VARCHAR2

1

IS_RACE_ETHNICITY_UNKN_IR

Indicator identifying whether race ethnicity unkn ir (Y/N).

VARCHAR2

1

IS_WHITE

Indicator identifying whether white (Y/N).

VARCHAR2

1

IS_WHITE_IR

Indicator identifying whether white ir (Y/N).

VARCHAR2

1

MIT_ID

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

VARCHAR2

9

MIT_PRIME_ETHNIC_CODE

Code identifying mit prime ethnic.

VARCHAR2

2

MIT_PRIME_ETHNIC_DESC

Description of mit prime ethnic.

VARCHAR2

100

STUDENT_SOURCE

Student source associated with the record.

VARCHAR2

9

WAREHOUSE_LOAD_DATE

Date the record was loaded into the data warehouse.

DATE