ALUMNI DEGREE

DATA VIEW NAME

ALUMNI_DEGREE

OVERVIEW

This view contains academic plan information for each individual who received a degree
of the University and who has a constituent type of 1 or 2. This includes all those who
have an electronic student record as well as many who graduated prior to 1970 and
have a paper student record. Deceased individuals are identified in the
UW-ALUMNI_DEMOGRAPHIC data view.

LOAD FREQUENCY

Data is refreshed every 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 the InfoAccess Home Page

SPECIAL
CONSIDERATIONS

For demographic information such as Gender or FERPA, join this view to UW_ALUMNI_DEMOGRAPHIC.

QUESTIONS

Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)

LAST UPDATED

9/99 Data view created.
7/01 New Definition for Acad_Career, updated Appendices

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)

APPENDIX: Degrees by Degree Code

Note: Degree Level: B = Bachelors; M = Masters; D = Doctoral; P = Professional
O = Other (e.g., certificates)

Degrees by Degree Description

Note Degree Level: B = Bachelors; M = Masters; D = Doctoral;
P = Professional O = Other (e.g., certificates)