- DATA VIEW NAME
- STDNT_STUDY_ABROAD
- OVERVIEW
- All students who have been registered on campus for participation on a UW-Madison-sponsored international program. Each Administrative Unit sponsoring an international program is responsible for registering UW participants through the Office of the Registrar. Only those students who have been properly registered will appear in this dataview.
Although some data for the 1970’s (terms 0722-0794) are present, they are incomplete. Data for 1979-85 (terms 0802-0856) are better, though still incomplete. For best results, use terms >= 0862 for academic year and semester programs (fall and spring), and use terms >= 0906 for summer programs. Note: Most other Retention views start with data >= 0856.
- LOAD FREQUENCY
- This data is refreshed each weekend.
- DATA CUSTODIAN
- Registrar’s Office
Contact: Phil Hull - 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 - 1) Certain Study Agreement Codes are not shown in this view. They are: CIC, HEC-FIT, ED-OT-INTR, and ED-PT-INTR.
2) This query does not count UW-Madison students who studied abroad on a program sponsored by another university. Students who study on a “non-Madison program” must present a transcript to the UW-Madison Admissions Office for evaluation of transfer credits. Those students are coded differently for their international program.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 01/2005 – New view created.
09/2012 – Data Custodian Contact changed from Karen Hanson to Kim Alling
12/2014 – Preferred name policy s8w. - DATA FORMAT
- 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 |
|---|---|---|
| *Term | Varchar2(4) | The ISIS code for the UW Madison academic year and semester during which the student participated on the international program. |
| Term Descr | Varchar2(30) | Description of the code for the UW Madison academic year and semester. |
| *ID | Varchar2(11) | ISIS personal Identifier. It will never be changed throughout the individual’s relationship with the University. This is not the same as Campus_ID. Only 10 characters are in use. |
| Campus ID | Varchar2(16) | This is simply a unique student identifier (10 digits). It may change occasionally at the student’s request. |
| Name | Varchar2(50) | Student’s preferred name (last, first, middle with no space between last and first names). |
| Program Type Code | Varchar2(1) | Indicates the type of UW-Madison foreign study program in which the student participated. Derived from the study agreement short description. Values are: A = Study abroad (academic credit-bearing educational program overseas officially sponsored by UW-Madison). E = Exchange program (credit-bearing educational program that is based on an official exchange agreement signed by UW-Madison and the sponsoring institution). I = Internship Abroad (internship, externship, or external study program officially sponsored by UW-Madison). O = Other (Students attending another academic credit-bearing program). Null = Study agreement short description is either not available or is not coded correctly. |
| Study Agreement Code | Varchar2(10) | A code indicating the international study program in which the student participated in the given term. Note that some study agreement codes have been excluded from this view (see Special Considerations above). |
| Study Agreement Descr | Varchar2(30) | Description of the Study Agreement Code. |
| Study Agreement Adm Unit Code | Varchar2(10) | Code representing the unit administering UW-Madison foreign studies program. Derived from the first 2-4 characters of the Study Agreement Code. |
| Study Agreement Adm Unit Descr | Varchar2(80) | Name of the Administrative Unit for the program.
The current administrative units are: Note: All rows that do not have one of the above units indicated will show ‘Other’ as the Study Agreement Unit Descr. |
| Study Agreement Country | Varchar2 (3) | The code for the country in which the study agreement program took place. |
| Study Agreement Country Descr | Varchar2(30) | The descriptive name of the country in which the study agreement program took place. |
| In Progress Ind | Varchar2(1) | Indicates whether the student’s international program is in session at the time the refresh program runs (based on the study agreement end date). Valid values: Y = In progress |
| Study Agreement Year | Varchar2(7) | Shows the academic year during in which the study abroad program took place. Note: Calendar Year programs will show the academic year when the program started on both terms they participated in the program. For example, if the program started in Spring 1034 and ended Fall 1042 the value in Study Agreement Year should be 2002-03 on both entries. |
| Study Agreement Duration | Varchar2(30) | Duration of UW-Madison programs. Valid Values: Fall: one semester program (12-18 credits), starting sometime during what would be considered the fall term at UW, but does NOT necessarily match the overall timing. E.g. here on campus, fall may be Sept. 3-Dec.21. Overseas, it may be Aug 1-Dec. 1 or October 15-March15, but they are all FALL term programs. Spring: similar to Fall; 12-18 credits roughly in our spring term. Year: a program where students earn 24-36 credits over roughly the equivalent of our academic year (a northern hemisphere fall + spring); dates could be e.g. Sept-May, Oct-June, or Sept-July with longer breaks. Calendar Year: a program where students earn 24-36 credits but what would be a northern hemisphere spring first + the subsequent fall); usually they are in the southern hemisphere (to match the “academic year” there), and generally run late February-early December.31 Days or Less: A short term or “module” program during the academic year where students generally earn no more than 4 credits (usually as one class). These USUALLY are scheduled for the winter break and are currently attached to session A2 of the spring term. Based on a count of the number of days between the program’s start and end dates. Fewer than 8 weeks: a program during the academic year that is longer than a month, but less than 8 weeks. This is often for internship or practicum programs (education and the med school have these). Based on a count of the number of days between the program’s start and end dates. Summer: generally any program 2-10 weeks in length that falls in what would be considered the UW summer term. |
| Study Agreement Start Date | Date | The start date of the UW-Madison-sponsored international program. Regular on-campus semester start dates appear consistently through approx. 1999, and thereafter actual overseas start dates generally appear. |
| Study Agreement End Date | Date | The end date of the UW-Madison-sponsored international program. Regular on-campus semester end dates appear consistently through approx. 1999, and thereafter actual overseas end dates generally appear. |
| Extract Date Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |