ADM GRAD SCHOOL Table
This table contains a list of universities and colleges previously attended by the graduate admissions applicants. Information of the school include the ETS code, name, and address of the school.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_ACTIVITY_DATE |
XXX |
DATE |
8 |
CITY |
City. |
VARCHAR2 |
35 |
COLLEGE_NAME |
XXX |
VARCHAR2 |
30 |
COLLEGE_NAME_CAPS |
XXX |
VARCHAR2 |
30 |
COLLEGE_NAME_FIXED_UP |
XXX |
VARCHAR2 |
40 |
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 |
IS_TOP_SCHOOL |
Is this school considered one of the top schools? Y, N. |
VARCHAR2 |
1 |
NATION_CODE |
Nation/country code. |
VARCHAR2 |
5 |
NATION_NAME |
Name of the nation/country |
VARCHAR2 |
28 |
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 |
ZIP_CODE4 |
The additional 4-digit Zip code |
VARCHAR2 |
4 |
ZIP_CODE5 |
The 5-digit Zip code |
VARCHAR2 |
5 |