- DATA VIEW NAME
- HR_DIRECTORY_HOME
- 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 current employees.
This view contains employee home address for all UW System employees who have approved their address for release. Those who have not approved their home address for release will not exist on this data view.
Email address is available for those campuses who enter their email addresses into 3270 (via the CPAD transaction or a variation of CPAD) or feed this information into the IAA system via an IAA supplemental feed.
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 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). |
| Release_Home_Address_Ind | Varchar2 (64) | Indicates whether an employee has allowed their home address to be released. Y = Home address can be released N = Home address CANNOT be released |
| Home_Address_Line_1 | Varchar2 (64) | First line home address. |
| Home_Address_Line_2 | Varchar2 (64) | Second line of home address. |
| Home_City | Varchar2 (64) | City associated with home address. |
| Home_State | Varchar2 (64) | State associated with home address. |
| Home_Zip_Code | Varchar2 (64) | Zip code associated with home address. |
| Home_Phone | Varchar2 (64) | Telephone number associated with home address. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |