MIT Data & Reporting Services

 

data warehouse logo 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 school from which the applicant received an advanced (or post-undergraduate) degree.


Field Name

Description

Data Type

Length

ADM_GRAD_ATTD_SCH_2_KEY

Graduate Admissions Attended School Key - 2. Use this field to join the ADM GRAD ATTD SCH 2 table to Graduate Admissions Application fact table (ADM GRAD APPLICATION DETAIL).

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