- DATA VIEW NAME
- ID_CROSSWALK_HIST
- OVERVIEW
- The data view is based on the data available in the University of Wisconsin System’s Identification, Authentication, and Authorization (IAA) system. Affiliations included are UW-Madison employees/contingent workers, applicants, students, lifelong learner/CSIS, summer research programs/SROP, Hospital and Medical Foundation, Spec Auth, Spec Pop. This view contains data for people who have current affiliations with the university or are inactive and have more than one of the desired identifiers. The possibility exists that a person could have more than one row on this view if they were assigned multiple ID’s in SIS or the HR system(s).
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
- 09/2026 – New view created.
- 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 (30) | 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).
A person should have one PVI but may have multiple rows in this view for that PVI if they have duplicate identifiers from one of the source systems (i.e. multiple Employee_ID’s). If multiple PVI’s were assigned to a person, once resolved in the Person Hub, only the most recent PVI is brought into the view. |
| Campus | Varchar2 (250) | This will have the values UWMSN or null value. If the person has an active affiliation with UW-Madison in the IAA Person Hub the value will be UWMSN. If the person does not have an active affiliation with UW-Madison, the CAMPUS will be null. NOTE: “Active” affiliations are either someone with an affiliation on the date of extraction occurs, a former student, retiree, emeriti OR former employee/contingent worker (within last 2 years). |
| Employee_ID | Varchar2 (30) | A unique number assigned to each person in the Human Resource System. Eight characters are in use. The data in this field may go back as far as 2011 for a person.
There may be multiple unique identifiers for a person if they were/are duplicated within the HR System(s). All identifiers for UW-Madison affiliates (employee, former employee, contingent worker, former contingent worker, emeritus, retiree) will be provided. If an affiliation ended more than 2 years ago, IAA no longer retains the job information for the person and therefore can no longer determine if their affiliation was with UW-Madison or another campus. In this case, the identifier will be provided but could be from another campuses position. |
| SIS_Emplid | Varchar2 (30) | A unique number assigned to individuals entered in the Integrated Student Information System (ISIS). This ID should not change throughout the individual’s relationship with the University. Ten characters are in use.
Contains the UW-Madison SIS EMPLID associated with a person; this could be because they are or were a student/applicant or because they are or were an employee with access needed in SIS such as an instructor/advisor/etc. If they are a student, then the earliest this data would go back to is 2004, whereas, if someone was an employee it may go back as far as 1983. This will contain data for people who have no current affiliation with UW-Madison SIS but once did. |
| SIS_Campus_ID | Varchar2 (30) | A number assigned to individuals entered in the Student Information System (SIS) Ten characters are in use. The Campus_ID is used by the student and may change occasionally but the most recent Campus ID is presented. |
| Netid | Varchar2 (30) | NetID is a unique identifier used by the UW-Madison community to determine authorization for online resources. Up to twelve characters can be used. Field contains the current NetID for a person or contains the most recent NetID value assigned to a person who had a previous affiliation with Madison This will only have one value per person and does not have previous NetIDs a person may have had if they had a NetID change. This data may go back as far as 1993. |
| Photo_ID | Varchar2 (30) | 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.
Contains the current Photo ID or the most recently issued non-disabled Photo ID for a person. The current process is to expire cards without disabling them, so this data in very rare cases may go back as far as the late 1970s. This data will be changing in the future with the rollout of mobile credentials; it currently contains the ISSUE_CODE which will be NULL in the future so the length of this data will be shorter. |
| 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 |