ADM GRAD SCHOOL Table
View exposing graduate school reference data including school identifiers, names, address attributes, and top-school indicator used for graduate admissions reporting.
Field Name |
Description |
Data Type |
Length |
|---|---|---|---|
ADDRESS_ACTIVITY_DATE |
Date associated with address activity. |
DATE |
|
CITY |
City as provided by the source. |
VARCHAR2 |
20 |
COLLEGE_NAME |
College name as provided by the source. |
VARCHAR2 |
30 |
COLLEGE_NAME_CAPS |
College name caps as provided by the source. |
VARCHAR2 |
30 |
COLLEGE_NAME_FIXED_UP |
College name fixed up as provided by the source. |
VARCHAR2 |
40 |
ETS_CODE |
Code identifying ets. |
VARCHAR2 |
6 |
IS_TOP_SCHOOL |
Indicator identifying whether top school (Y/N). |
VARCHAR2 |
1 |
NATION_CODE |
Code identifying nation. |
VARCHAR2 |
3 |
NATION_NAME |
Nation name as provided by the source. |
VARCHAR2 |
28 |
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 |
|
ZIP_CODE4 |
Zip code4 as provided by the source. |
VARCHAR2 |
4 |
ZIP_CODE5 |
Zip code5 as provided by the source. |
VARCHAR2 |
5 |