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 |