Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD ATTD SCH 2 Table


This table contains information about the previously school/college attended by the graduate admissions applicant. Usually this is the last/latest school attended by the applicant, and most probably from which the applicant received an advanced (or post-undergraduate) degree.


Field Name

Description

Data Type

Length

ADM_GRAD_ATTD_SCH_2_KEY

Use this field to join the ADM GRAD ATTD SCH 2 table to the ADM GRAD APPLICATION DETAIL table to get the last school attended by the applicant.

VARCHAR2

20

CITY

City.

VARCHAR2

35

ETS_CODE

School codes assigned by the Educational Testing Service (ETS) in Princeton, NJ, to identify the different institutions (high schools, colleges, and universities).

VARCHAR2

6

NATION

Nation/Country

VARCHAR2

28

SCHOOL_NAME

The descriptive text for SCHOOL_CODE.

VARCHAR2

30

STATE

State.

VARCHAR2

30

WAREHOUSE_LOAD_DATE

The date the record was loaded into the Data Warehouse from the source system.

DATE

8