Data Warehouse

IS&T Home >   Data Warehouse

MIT Data Warehouse ADM GRAD ATTENDED SCHOOL Table


This table contains information about all the previously attended schools of the graduate admissions applicant. There is one record for a school attended. Join this table with ADM_GRAD_APPLICANT by adm_grad_applicant_key to get all the schools previously attended by the applicant.


Field Name

Description

Data Type

Length

ADM_GRAD_APPLICANT_KEY

Graduate admissions applicant key. This field is used to join ADM GRAD APPLICANT table and a Graduate Admissions fact table (e.g. ADM GRAD APPLICATION DETAIL, ADM GRAD TEST SCORE DETAIL and ADM GRAD ATTENDED SCHOOL).

VARCHAR2

8

CITY

City.

VARCHAR2

35

DEGREE_RECEIVED_OR_EXPECTED

The undergraduate or advanced degree received or expected to receive by the admissions applicant.

VARCHAR2

30

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

GPA

Grade Point Average

NUMBER

2.1

IS_TOP_SCHOOL

Is this school considered one of the top schools? Y, N.

VARCHAR2

1

LAST_ACTIVITY_DATE

Date when information in the record was last updated.

DATE

8

MAJOR_OR_FIELD_OF_STUDY

The major or the field of study

VARCHAR2

40

MONTH_ATTENDED_FROM

The month when the applicant started attending the program/school.

VARCHAR2

2

MONTH_ATTENDED_THRU

The month when the applicant completed the program at the school.

VARCHAR2

2

MONTH_OF_DEGREE

The month of year when the degree was received.

VARCHAR2

2

NATION

Nation/Country

VARCHAR2

28

SCHOOL_ADDR_ACTIVITY_DATE

The last activity date on the school address

DATE

8

SCHOOL_ATTENDED_KEY

XXX

VARCHAR2

10

SCHOOL_NAME

The descriptive text for SCHOOL_CODE.

VARCHAR2

30

SECOND_DEGREE_RECEIVED_CODE

XXX

VARCHAR2

4

SECOND_MAJOR_OR_FIELD_DESC

XXX

VARCHAR2

40

STATE

State.

VARCHAR2

30

STREET1

Street address

VARCHAR2

30

STREET2

Street address

VARCHAR2

30

STREET3

Street address

VARCHAR2

30

WAREHOUSE_LOAD_DATE

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

DATE

8

YEAR_ATTENDED_FROM

The year when the applicant started attending the school/program.

VARCHAR2

4

YEAR_ATTENDED_THRU

The year when the applicant was through with the school/program.

VARCHAR2

4

YEAR_OF_DEGREE

In STUDENT Biograhic and Directory tables this field contains the student's current year of study at MIT: 1, 2, 3, 4, G, U. The length of the field in those tables are of one character. In GRADUATE ADMISSION tables, this field, with a length of four character, contains the year when the applicant recieved the degree from the school/program attended.

VARCHAR2

1

ZIP_CODE4

The additional 4-digit Zip code

VARCHAR2

4

ZIP_CODE5

The 5-digit Zip code

VARCHAR2

5