STDNT UGRD APPLICANT MAJORS

DATA VIEW NAME

STDNT_UGRD_APPLICANT_MAJORS

OVERVIEW

This view contains information on an applicant’s original and alternate majors entered on the application.  This data view shows all undergraduate applicants (academic career = UGRD) applying to the University of Wisconsin-Madison. There are applications for multiple terms available. All applications entered will be available, but only the most recent Program Action/Action Reason for a specific application.
This view contains information on an applicant’s original and alternate majors entered on the application.

LOAD FREQUENCY

Data is refreshed daily Monday – Saturday

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 can be joined to the Stdnt_Ugrd_Applicant data view by joining on ID and Application Number.

QUESTIONS

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

LAST UPDATED

1/2018 New Data View

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)