ADM GRAD ATTENDED SCHOOL Table
View exposing graduate applicant attended-school detail including school, address, major, attendance, degree, and GPA attributes used for graduate admissions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADM_GRAD_APPLICANT_KEY |
Surrogate key identifying the adm grad applicant. |
VARCHAR2 |
8 |
CITY |
City as provided by the source. |
VARCHAR2 |
20 |
DEGREE_RECEIVED_OR_EXPECTED |
Degree received or expected as provided by the source. |
VARCHAR2 |
4 |
ETS_CODE |
Code identifying ets. |
VARCHAR2 |
6 |
GPA |
Gpa as provided by the source. |
NUMBER |
5,3 |
IS_TOP_SCHOOL |
Indicator identifying whether top school (Y/N). |
VARCHAR2 |
1 |
LAST_ACTIVITY_DATE |
Date associated with last activity. |
DATE |
|
MAJOR_OR_FIELD_OF_STUDY |
Major or field of study as provided by the source. |
VARCHAR2 |
30 |
MONTH_ATTENDED_FROM |
Month attended from as provided by the source. |
VARCHAR2 |
2 |
MONTH_ATTENDED_THRU |
Month attended thru as provided by the source. |
VARCHAR2 |
2 |
MONTH_OF_DEGREE |
Month of degree as provided by the source. |
VARCHAR2 |
2 |
NATION |
Nation as provided by the source. |
VARCHAR2 |
28 |
SCHOOL_ADDR_ACTIVITY_DATE |
Date associated with school addr activity. |
DATE |
|
SCHOOL_ATTENDED_KEY |
Surrogate key identifying the school attended. |
VARCHAR2 |
10 |
SCHOOL_NAME |
School name as provided by the source. |
VARCHAR2 |
40 |
SECOND_DEGREE_RECEIVED_CODE |
Code identifying second degree received. |
VARCHAR2 |
4 |
SECOND_MAJOR_OR_FIELD_DESC |
Description of second major or field. |
VARCHAR2 |
30 |
STATE |
State as provided by the source. |
VARCHAR2 |
2 |
STREET1 |
Street1 as provided by the source. |
VARCHAR2 |
30 |
STREET2 |
Street2 as provided by the source. |
VARCHAR2 |
30 |
STREET3 |
Street3 as provided by the source. |
VARCHAR2 |
30 |
WAREHOUSE_LOAD_DATE |
Date the record was loaded into the data warehouse. |
DATE |
|
YEAR_ATTENDED_FROM |
Year attended from as provided by the source. |
VARCHAR2 |
4 |
YEAR_ATTENDED_THRU |
Year attended thru as provided by the source. |
VARCHAR2 |
4 |
YEAR_OF_DEGREE |
Year of degree as provided by the source. |
VARCHAR2 |
4 |
ZIP_CODE4 |
Zip code4 as provided by the source. |
VARCHAR2 |
4 |
ZIP_CODE5 |
Zip code5 as provided by the source. |
VARCHAR2 |
5 |