- DATA VIEW NAME
- HR_DIRECTORY_CAMPUS
- Overview
- The population of 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 the UW System will stay in the system 2 years after their appointment has ended. It is advised you get your population from the HR data views and join to these views to get the correct population of employees.
This view contains employee campus work address and email address. There should be a record for each UW System employee. Campus work address and email address are available only for those campuses who enter this information into 3270 (via the CPAD transaction or a variation of CPAD) or feed this information into the IAA system via an IAA supplemental feed.
This data view contains one row per PVI and Major Appointment Dept. The data is restricted using the Major Appointment Dept UDDS code to limit the records returned based on your authorization.
- LOAD FREQUENCY
- The data is refreshed daily.
- DATA CUSTODIAN
- UW-Madison Human Resources Office
Contact: Catharine Derubeis - 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 - QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357)
- LAST UPDATED
- 02/2008 – New view created.
11/2011 – Data Custodian Change. - 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)
| 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) |
| Person_ID | Varchar2 (30) | A unique number assigned to each person in the IADS HR system. |
| *Appointment_Major_Dept | Char (7) | The department that coordinates the appointment. This department assumes responsibility for coordinating personnel decisions. This is in the form of a UDDS code. |
| First_Name | Varchar2 (30) | First name of employee. |
| Middle_Name | Varchar2 (30) | Middle name of employee. |
| Last_Name | Varchar2 (30) | Last name of employee. |
| Email_Address | Varchar2 (64) | Electronic mailing address of employee. Only present for certain campuses (see Overview). |
| Campus_Address_Line_1 | Varchar2 (64) | First line of campus work address. |
| Campus_Address_Line_2 | Varchar2 (64) | Second line of campus work address. |
| Campus_City | Varchar2 (64) | City associated with campus work address. |
| Campus_State | Varchar2 (64) | State associated with campus work address. |
| Campus_Zip_Code | Varchar2 (64) | Zip code associated with campus work address. |
| Campus_Building_Nbr | Varchar2 (64) | Building number associated with campus work address. |
| Campus_Building_Wing | Varchar2 (64) | Wing of the building associated with campus work address. |
| Campus_Room_Nbr | Varchar2 (64) | The room number associated with campus work address. |
| Campus_Phone_1 | Varchar2 (64) | Telephone number associated with campus work address. |
| Campus_Phone_2 | Varchar2 (64) | Second telephone number associated with campus work address. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |