- DATA VIEW NAME
- HOUS_HR_PERSON
- OVERVIEW
- Person who has some relationship with UW Housing regarding student employment. This includes, but is not restricted to, applicants and employees.
- LOAD FREQUENCY
- The data is replaced every night.
- DATA CUSTODIAN
- University Housing
Contact: Brenda Krueger - 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 - Desc
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 10/2007 – New view created
06/2014 – Added new field APPT_EMPLID and updated doc view s8w
08/2014 – Added new field Form_19_section1_completed_ind s8w
01/2015 – Updated preferred name description s8w. - 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 |
|---|---|---|
| *PERSON_ID | NUMBER(10,0) | Unique identifier for a person in the Housing HR system. |
| CAMPUS_ID | VARCHAR2(10) | Campus ID on the Integrated Student Information System. |
| NAME | VARCHAR2(50) | Full preferred name in following format: last, first middle. |
| BIRTHDATE | DATE | Date of birth. Data comes from either ISIS or from the Housing Human Resources System, whichever source was added most recently. |
| GENDER | VARCHAR2(1) | M=male, F=female. Data comes from either ISIS or from the Housing Human Resources System, whichever source was added most recently. |
| FORM_I9_ELIG_COMPLETED_IND | VARCHAR2(1) | Eligibility portion of I-9 form. Values: Y,N |
| FORM_I9_IDENTITY_COMPLETED_IND | VARCHAR2(1) | Identity portion of I-9 form. Values: Y,N |
| FORM_I9_SECTION1_COMPLETED_IND | VARCHAR2(1) | Indicates I9 Section 1 is complete. Values: Y,N |
| FORM_W4_COMPLETED_IND | VARCHAR2(1) | Values: Y,N |
| MN_TAX_FORM_COMPLETED_IND | VARCHAR2(1) | Minnesota tax form. Values: Y,N |
| APPT_EMPLID | NUMBER(8) | HR Employee ID – added at 1st appointment for this person. |
| ROSE_AWARD_IND | VARCHAR2(1) | Values: Y,N |
| WORK_PERMIT_ON_FILE_IND | VARCHAR2(1) | Values: Y,N |
| DIRECT_DEPOSIT_IND | VARCHAR2(1) | Values: Y,N |
| DO_NOT_HIRE_UNTIL_IND | VARCHAR2(1) | Values: Y,N |
| BACKGROUND_CHECK_COMPLETED _IND |
VARCHAR2(1) | Values: Y,N |
| DRIVERS_LICENSE_CHECKED_IND | VARCHAR2(1) | Values: Y,N |
| DRIVERS_LICENSE_ISSUED_DATE | DATE | The date the license was issued to the person. |
| DRIVERS_LICENSE_ISSUED_STATE | VARCHAR2(2) | The state in which he driver’s license was issued. |
| DRIVERS_LICENSE_NUMBER | VARCHAR2(50) | The driver’s license number. |
| MAIL_ADDRESS_1 | VARCHAR2(55) | First line of mailing address. Free format. Data comes from either ISIS or from the Housing Human Resources System (If a campus_id is on record, then source will be ISIS). |
| MAIL_ADDRESS_2 | VARCHAR2(55) | Second line of mailing address. Free format. |
| MAIL_ADDRESS_3 | VARCHAR2(55) | Third line of mailing address. Free format. |
| MAIL_ADDRESS_4 | VARCHAR2(55) | Fourth line of mailing address. Free format. |
| MAIL_CITY | VARCHAR2(35) | City portion of mailing address. |
| MAIL_STATE | VARCHAR2(2) | State code portion of mailing address. Domestic addresses only. |
| MAIL_ZIP | VARCHAR2(12) | Postal code portion of mailing address. Domestic addresses only. |
| SUMMER_ADDRESS_1 | VARCHAR2(55) | First line of summer address. Free format. Data comes from the Housing Human Resources System. |
| SUMMER_ADDRESS_2 | VARCHAR2(55) | Second line of summer address. Free format. |
| SUMMER_ADDRESS_3 | VARCHAR2(55) | Third line of summer address. Free format. |
| SUMMER_ADDRESS_4 | VARCHAR2(55) | Fourth line of summer address. Free format. |
| SUMMER_CITY | VARCHAR2(35) | City portion of summer address. |
| SUMMER_STATE | VARCHAR2(2) | State code portion of summer address. Domestic addresses only. |
| SUMMER_ZIP | VARCHAR2(12) | Postal code portion of summer address. Domestic addresses only. |
| MAIL_PHONE | VARCHAR2(24) | Current Mailing Telephone number. Format varies depending if campus, local, US, international or other category. Data comes from either ISIS or from the Housing Human Resources System. (If a campus_id is on record, then source will be ISIS). |
| HOME_PHONE | VARCHAR2(24) | Current home telephone number. Format varies depending if campus, local, US, international or other category. Data comes from either ISIS or from the Housing Human Resources System. (If a campus_id is on record, then source will be ISIS). |
| CELL_PHONE | VARCHAR2(24) | Current cell phone number. Format varies depending if campus, local, US, international or other category. Data comes from either ISIS or from the Housing Human Resources System. (If a campus_id is on record, then source will be ISIS). |
| ISIS_PREFERRED_EMAIL_ADDRESS | VARCHAR2(100) | The person’s preferred email address from ISIS. |
| ONLINE_ACCOUNT_EMAIL_ADDRESS | VARCHAR2(100) | The email address that the person supplied when they created their online account. |
| OTHER_EMAIL_ADDRESS | VARCHAR2(100) | An additional email address that the person supplied when they submitted their application. |
| HOUSING_EMAIL_ADDRESS | VARCHAR2(100) | Self-declared home email address. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |