- DATA VIEW NAME
- RETENTION_EXT_ACADEMIC_DATA
- OVERVIEW
- This view contains information regarding a student’s external academic experiences. See STDNT_PREV_INSTITUTION_CODES for translate values of External Org Id’s. This view contains information for students enrolled since the summer term of the 1984-85 academic year term 0856.
- LOAD FREQUENCY
- Data is replaced the 3rd of each month.
- DATA CUSTODIAN
- Graduate School
Contact: Katie Bourassa - 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
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 05/2002– New view created.
11/2002 – Load Frequency changed. - 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 |
|---|---|---|
| *ID | Varchar2 (11) | A personal Identifier. The ID 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. |
| *External_Org_ID | Varchar2 (11) | This code identifies the external organization that conferred the degree.
UW-Madison may be listed as an external organization if the student, for example, changed careers, e.g. undergrad to grad. |
| *External_Career | Varchar2 (4) | The type of external career. Valid values: HS, UGRD, GRAD, PROF, MED, VMED, & LAW. |
| *External_Data_Nbr | Varchar2 (3) | A sequence number that counts the number of records for each combination of student, external institution and career. |
| *Data_Source | Varchar2 (3) | The source of the external data. Example Values are: SCH = School SLF = Self-Reported WWW = World Wide Web |
| External_Academic_Level | Varchar2 (4) | The highest academic level obtained by the student at the external institution in the given career. Values are: 0 = Unknown 5 = 12th grade 6 = Post-secondary 1st year 9 = Post-secondary senior 90 = Post-secondary 92 = Post-secondary Master 93 = Post-secondary Professional 94 = Post-Doctoral |
| Transcript_Date | Date | The date the transcript was received. |
| Attendance_Start_Date | Date | The date the student began attending the external institution. |
| Attendance_End_Date | Date | The date the student stopped attending the external institution. Often not populated. |
| Sav_GPA | Varchar2 (10) | Free-form self-reported GPAs of Graduate School applicants. |
| *External_Sum_Type | Varchar2 (4) | The type of external summary. Example Values are: HSOV = High School Overall ADSC = Admitting Degree School PSEC = Post Secondary |
| Extract_Date_Time | Date | The date and time these data were extracted from ISIS. Format: YYYYMMDD HH24:MI:SS |