- DATA VIEW NAME
- HR_DIRECTORY_ADMIN
- OVERVIEW
- The population of the data view is based on employee data available in the University of Wisconsin System’s Identification, Authentication and Authorization (IAA) system. Employees who have ended their appointment with the UW System will stay in the IAA system and this data view for 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 HR_DIRECTORY_ADMIN data view includes addresses the employees have indicated they do not want released. These unreleased home addresses are only authorized to be used for official university business typically sent from the UW Service Center, e.g., W-4s. Employees expect other mailings will be sent to their office address, if they have requested their home address not be released. There are two alternative data views to be used when the contact is not for official university business. HR_DIRECTORY_HOME provides only the released home addresses and HR_DIRECTORY_CAMPUS provides all available campus addresses.
Home address should be available for all employees. Campus work address and email address are available only for those campuses who enter this information into 3270 (via the CPAD transaction or variation of CPAD) or feed this information into the IAA system via an IAA supplemental feed.
There should be a record for each UW System employee. 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
- Human Resources Office
Contact: Catharine Derubeis - AUTHORIZATION
- In order to receive approval from the data custodian for this data view you must have the need to communicate official university business to non-released home addresses.
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). |
| 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. |
| 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 |