- 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
- 02/2008 – New view created.
03/2009 – Photo_ID field added to view.
07/2012 – Changed to include PVI for persons employed within the last 2 yrs.
Also, added field Current_Employee - 07/2025 – Workday updates
- – new field Contingent_Worker_Ind
- – Hr_Person_Id renamed to Employee_Id
- -Isis_Emplid renamed to Sis_Emplid
- -Isis_Campus_Id renamed to Sis_Campus_Id
- -Current_Employee renamed to Current_Employee_Ind
- 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) |
| Employee_ID | Varchar2 (30) | A unique number assigned to each person and sourced from HRS EMPLID. Eight characters are in use. |
| SIS_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. |
| SIS_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_Ind | Varchar2 (1) | This field identifies 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 |
| Contingent_Worker_Ind | Varchar2 (1) | This field indicates if the person is a contingent worker (e.g. consultant). ‘Y’ – Yes, the person is a contingent employee ‘N’ – No, the person is not a contingent employee |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |