- DATA VIEW NAME
- UGRD_ACAD_SUMMARY
- OVERVIEW
- This data view lists all of the reported external institutions attended by undergraduate prospects and applicants. Some of the institutions, namely high schools, will have additional academic information regarding their attendance at these institutions (GPA, Class Rank, etc.).
- LOAD FREQUENCY
- The data in this view is refreshed daily.
- 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 - None.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 01/2007 – 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.
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 |
|---|---|---|
| *Acad_Sum_Key | Number(15) | A unique identifier that is system generated. A surrogate key. It is based on ID, Ext_Org_ID, Ext_Career, Ext_Data_Nbr, and Ext_Summ_Type. |
| Prospect_Key | Number(15) | Surrogate key of prospect table. Match this key on this table to same key on Ugrd_Prospect view. |
| 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. |
| Institution_Code | Varchar2(11) | High School or Postsecondary Institution code |
| Institution_Career | Varchar2(4) | The applicant’s career in respect to the external institution. This career does not correspond to the career the applicant is seeking at UW Madison. |
| Data_Nbr | Number(3) | Integer counting up from 1 signifying multiple transcripts from a single institution. |
| Transcript_Source | Varchar2(3) | Transcript Source, examples of valid values include School & Self Rpted |
| Transcript_Desired_Flag | Varchar2(1) | Signifies transcript has been requested. |
| Transcript_Type | Varchar2(3) | Examples of valid values are: Official, Unofficial. |
| Transcript_Status | Varchar2(1) | Examples of valid values are: Final, In progress, Incomplete, Mid-Year. |
| Transcript_Requested_Date | Date | Date of requested transcript. |
| Transcript_Received_Flag | Varchar2(1) | Signifies transcript was received |
| Transcript_Received_Date | Date | Date transcript was received |
| Transcript_Medium | Varchar2(1) | Valid values include: Hard Copy, EDI |
| Acad_Summary_Type | Varchar2(4) | Valid values include: HSOV, HSTR, HS11, HS10, PSEC |
| Acad_Summary_level | Varchar2(4) | Academic level associated with the gpa & rank. Example of valid values: 9th, 10th, 11th, 12th, etc… |
| Acad_Summary_Term | Varchar2(4) | Academic term associated with the gpa & rank. Examples of valid values: Spring, Summer, Fall, 1,2,3,etc… |
| Acad_Summary_Term_Yr | Number(4) | Used in conjunction with the term value to specify the year. |
| Acad_Unit_Type | Varchar2(3) | Valid values include: Carnegie, Semester. |
| Units_Completed | Number(7,2) | Total number of units completed |
| Class_Rank | Number(5) | The propects high school rank. |
| Class_Size | Number(5) | The total number of students in the prospect’s high school class.. |
| Percentile_Rank | Number(3) | The prospect’s percentile rank based on the high school GPA. |
| Rank_Type | Varchar2(3) | Valid values: UNW – Unweighted WGT – Weighted NULL |
| GPA_Type | Varchar2(4) | Valid values: 4PT – DOMS – NNUM – NULL |
| GPA | Number(6,3) | The prospect’s cumulative high school GPA. The GPA value in this field is defined by the value in the Acad_Summary_Type field. For an Acad_Summary_Type of HSOV the GPA value will be a manuallly converted, 4.0, academic GPA. For an Acad_Summary_Type of HSTR, the GPA value will be the cumulative GPA taken from the high school transcript likely at the end of the high school student’s junior year with no scale conversions. |
| Extract Date Time | Date | The date and time these data were extracted from ISIS. Format : YYYYMMDD HH24:MI:SS |