ID_CROSSWALK_UWMSN

This data view contains one row for each UW-Madison employee and/or student.  The data view is based on the data available in the University of Wisconsin System's Identification, Authentication and Authorization (IAA) system.   Employees who have ended their affiliation with UW Madison will remain in the system for 30 days.  Students typically will show if enrolled in the previous 2 semesters, current semester, or any future term activated semesters.

This data view is intended to help facilitate merging data from existing human resource data views with data in existing student data views.  This data view will be used to link the existing data views together.  This data view should not be used for identity management.

The data is extracted nightly from the IAA system

Division of Information Technology
Contact: Ty Letto

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

None.

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

2/2008 – New view created.

Primary Key Columns are identified with an asterisk(*)

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’

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)

Varchar2 (9)

The Publicly Visible Identifier (or PVI) is a unique number assigned to each person in the University of Wisconsin System's Identification, Authentication and Authorization (IAA) system.  The PVI is in the form in the form of UW000A000 and is issued to identify a person and tie together the multiple roles that person may have in various source systems (HR, Student, etc)  

Varchar2 (30)

A unique number assigned to each person in the IADS Human Resource System.  Eight characters are in use.

Varchar2 (30)

A unique number assigned to individuals entered in the Integrated Student Information System (ISIS).  This ID will never be changed throughout the individual’s relationship with the University. Ten characters are in use.

Varchar2 (64)

A number assigned to individuals entered in the Integrated Student Information System (ISIS).  The Campus_ID is used by the student and may change occasionally at the student's request.  Ten characters are in use.

Varchar2 (64)

NetID is a unique identifier used by the UW-Madison community to determine authorization for online resources.  Up to twelve characters can be used.

Date

The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS