ID CROSSWALK UWMSN

DATA VIEW NAME
ID_CROSSWALK_UWMSN
OVERVIEW
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 2 years. Students include all those currently enrolled, any enrolled in future semesters, as well as former students since Fall 2011-12.

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 on it’s own or for identity management.

LOAD FREQUENCY
The data is extracted nightly from the IAA system
DATA CUSTODIAN
Division of Information Technology
Contact: Abrianna Barca
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 InfoAccess Home Page
SPECIAL
CONSIDERATIONS
None.
QUESTIONS
Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
LAST UPDATED
2/2008 – New view created.
3/2009 – Photo_ID field added to view.
7/2012 – Changed to include PVI for persons employed within the last 2 yrs.
Also, added field Current_Employee
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’
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
*PVI 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)
HR_Person_ID Varchar2 (30) A unique number assigned to each person in the IADS Human Resource System. Eight characters are in use.
ISIS_Emplid 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.
ISIS_Campus_ID 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.
Netid 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.
Photo_ID Varchar2 (12) The Photo_ID number is printed on the official UW-Madison identification card (or WiscCard). It will give you access to libraries, recreation facilities, and other campus services.
Current_Employee Varchar2 (1) This field idetifies whether or not the individual is currently employed by the University.
‘Y’ – Yes, the person is a current employee
‘N’ – No, the person is not a current employee
Extract_Date_Time Date The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS
Skip to content