- DATA VIEW NAME
- STDNT_PREV_SCHOOLS_ATTENDED
- OVERVIEW
- Descriptive name and address information for schools previously attended by Undergraduate applicants.
- LOAD FREQUENCY
- This data is refreshed daily Monday-Friday and Sunday.
- DATA CUSTODIAN
- Undergraduate Admissions Office
Contact: David Leszczynski - 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 the InfoAccess Home Page
- SPECIAL CONSIDERATIONS
- This data view contains active and inactive information for previous schools attended. This data view includes inactive information to provide data about previous schools a student may have attended that have closed.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 06/2002 New View
06/2003 Data Custodian change - 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.
Example: VARCHAR2 (5) could contain ‘ABC12’ or ‘ABC’ or ‘A’ - Numeric Data
- NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) = format for numbers with decimal positions
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12 - Date
- DATE – Date can be in various formats. Date functions available with your query tool can be used to format the date.
Examples: DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)
| Column Name | Format | Description |
|---|---|---|
| *Prev_Inst__Code | varchar2 (10) | Identification code assigned to an institution. |
| *Prev_Inst_Eff_Date | date | Date of last update to institution information |
| Prev_Inst__Eff_status | varchar (1) | Status of the institution. Values are: A = active; I = inactive |
| Prev_Inst__Type_Code | varchar (4) | The type of institution. Values are: BUSN = Business NONP = Non-Profit NUWS = Non-UW Madison Study Abroad OTHR = Other SCHL = School TPEX = Third Party External TPIN = Third Party Internal UWSA = UW-Madison Study Abroad |
| Prev_Inst__School_Code | varchar (10) | The code for the higher education institution with which this organization shares a catalog. |
| Prev_Inst__School_Type | varchar (3) | The type of higher education institution. ELM = Elementary HSC = Secondary – Closed JRH – Junior High MDL – Middle PHS – Postsecondary SCD – Secondary |
| Prev_Inst__FICE_Code | varchar (6) | The FICE code for this school. FICE code is a 6-digit code maintained for historical purposes. This identifier was originally created by the Federal Interagency Committee on Education (FICE) to distinguish postsecondary schools that qualified as institutions of higher education from other postsecondary institutions. |
| Prev_Inst__ATP_Code | varchar (6) | The ATP code for this school. The ATP Code or College Board ID is a 6-digit number that is used by standardized tests such as SAT and ACT. The first 2 digits indicate the state. The ATP Code is a 4-digit number for higher education institutions. |
| Prev_Inst__Long_Descr | varchar2 (50) | Name of the institution. |
| Prev_Inst__Short_Descr | varchar2 (10) | First 10 characters of the institution name. |
| Prev_Inst__Address1 | varchar2 (35) | First line of the institution address. |
| Prev_Inst__Address2 | varchar2 (35) | Second line of the institution address. |
| Prev_Inst__Address3 | varchar2 (35) | Third line of the institution address. |
| Prev_Inst__Address4 | varchar2 (35) | Fourth line of the institution address. |
| Prev_Inst__City | varchar2 (30) | City where the institution is located. |
| Prev_Inst__County | varchar2 (30) | County where the institution is located. |
| Prev_Inst__State | varchar2 (6) | State where the institution is located. |
| Prev_Inst__Postal_Code | varchar2 (12) | Zip Code of the institution. |
| Prev_Inst__Country_Code | varchar2 (3) | Country code where the institution is located. |
| Prev_Inst__Contact_Nbr | number (4) | The number of this contact person in the list of contacts for this organization. |
| Prev_Inst__Department_Nbr | number (3) | The department number, from the Organization Departments page, for this contact’s department. |
| Prev_Inst__Location_Code | number (3) | The location number, from the Organization Locations page, for this department’s location. |
| Prev_Inst__ACT_Code | varchar (6) | The ACT code for this school |
| Prev_Inst__IPEDS_Code | varchar (6) | The IPEDS code for this school. The IPEDS (Integrated Post Secondary Educational Survey) code used in federal reporting. |
| Prev_Inst__School_District_Desc | varchar (50) | The district in which this organization is located. |
| EXTRACT_DATE_TIME | Date | The date and time these data were extracted. |