|
InfoAccess |
|
|
DATA VIEW NAME |
INSTITUTION_STOUT |
|
OVERVIEW |
This view contains information on various institutions. |
|
LOAD FREQUENCY |
Data is refreshed every night |
|
DATA CUSTODIAN |
Admissions - Julie Schumacher |
|
AUTHORIZATION |
You must receive approval to access data from the data custodian. For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page |
|
SPECIAL CONSIDERATIONS |
|
|
QUESTIONS |
Contact: Division of Information Technology Help Desk |
|
LAST UPDATED |
09/2004 – New view created. |
|
DATA FORMATS |
Primary Key Columns are identified with an asterisk(*) |
|
Alphanumeric Data |
VARCHAR2( N) (N) = maximum length. Field contains letters and/or
numbers. Trailing blanks are eliminated. |
|
Numeric Data |
NUMBER (N) (N) = length. Field contains only numbers. |
|
Date |
DATE - Date can be in various formats. Date functions
available with your query tool can be used to format the date. |
INSTITUTION TABLE
|
Column Name |
Format |
Description |
|---|---|---|
|
*INST_ID |
VARCHAR2(10) |
ID Number assigned by Datatel to be used internally. Unique ID for each institution |
|
INST_NAME |
VARCHAR2(57) |
Institution’s official name |
|
INST_OTHER_NAME |
VARCHAR2(57) |
Former or abbreviated names of the institution |
|
INST_ADDR_LINE1 |
VARCHAR2(30) |
First line of the institution’s address |
|
INST_ADDR_LINE2 |
VARCHAR2(30) |
Second line of the institution’s address |
|
INST_CITY |
VARCHAR2(30) |
City where the institution is located |
|
INST_STATE |
VARCHAR2(2) |
State where the institution is located |
|
INST_ZIP |
VARCHAR2(10) |
Zip code where the institution is located |
|
INST_COUNTRY |
VARCHAR2(8) |
Country where the institution is located |
|
INST_COUNTRY_DESC |
VARCHAR2(20) |
Description of country where the institution is located |
|
INST_PHONE1 |
VARCHAR2(20) |
Phone number for the institution |
|
INST_PHONE2 |
VARCHAR2(20) |
Phone number for the institution |
|
INST_PHONE3 |
VARCHAR2(20) |
Phone number for the institution |
|
INST_PHONE_TYPE1 |
VARCHAR2(5) |
Type of phone (i.e. business, home, etc..) |
|
INST_PHONE_TYPE2 |
VARCHAR2(5) |
Type of phone (i.e. business, home, etc..) |
|
INST_PHONE_TYPE3 |
VARCHAR2(5) |
Type of phone (i.e. business, home, etc..) |
|
INST_PHONE_TYPE_DESC1 |
VARCHAR2(30) |
Description for type of phone number |
|
INST_PHONE_TYPE_DESC2 |
VARCHAR2(30) |
Description for type of phone number |
|
INST_PHONE_TYPE_DESC3 |
VARCHAR2(30) |
Description for type of phone number |
|
INST_EMAIL |
VARCHAR2(50) |
Email address for institution |
|
INST_EMAIL_TYPE |
VARCHAR2(3) |
Type of email address for institution (i.e. business, other, etc..) |
|
INST_TYPE |
VARCHAR2(2) |
Education type of institution (i.e. high school, 2-yr, etc..) |
|
INST_TYPE_DESC |
VARCHAR2(25) |
Description of the institution type |
|
CEEB |
VARCHAR2(15) |
College Board ID number unique to institution |
|
FICE |
VARCHAR2(6) |
Federal ID number unique to institution |
|
INST_OTHER_ID |
VARCHAR2(15) |
UW-System reporting ID number for institution |
|
INST_STATUS |
VARCHAR2(2) |
Institution status (active/inactive) |
|
INST_STATUS_DESC |
VARCHAR2(25) |
Description of institution status |
|
EXTRACT_DATE_TIME |
DATE |
The date and time these data were extracted. |