- DATA VIEW NAME
- HR_Heritage
- OVERVIEW
- The HR_Heritage data view contains all heritage codes on record for individual employees. The data is only available in this view for individuals with currently active appointments who have specified one or more heritage codes. This view does not show a history of the changes to heritage codes over time. This view contains sensitive information that should only be made available to authorized University faculty and staff.
The data view in this view is filtered by the UDDS code found in the Appt_Major_Dept to limit the records returned based on your authorization. - LOAD FREQUENCY
- The data will be refreshed nightly, Monday thru Friday evening.
- DATA CUSTODIAN
- Office of Equity and Diversity
Contact: Catharine Derubeis - AUTHORIZATION
- This data view uses UDDS code to limit the records returned based on your 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 - This view only contains records for an employee if the person had designated one or more race or ethnic heritage categories. Individuals with no race/ethnicity data reported are not included in the view.
When joining this data to other appointment data views please consider the following:
- You may want to change the join properties so that you get back all the employees not just those with a Heritage Code on file (i.e. left join)
- You may need to suppress duplicates because the person may have more than one appointment in the range of UDDS codes you are authorized to see.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 11/09 – New view created. c4j.
12/09 – Added multiple_heritage_indicator. c4j
3/10 – Data Custodian Change c4j - 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 | VARCHAR(8) | A unique number assigned to a person. It is always the same. |
| *APPT_MAJOR_DEPT | VARCHAR(11) | This is the department that coordinates the appointment. This department assumes responsibility for coordinating personnel decisions. |
| MULTIPLE_HERITAGE_IND | VARCHAR(1) | This indicator indicates that there are multiple heritage codes for this person_id. |
| *HERITAGE_CODE | VARCHAR(1) | Racial/Ethnic heritage as claimed by the person.. Valid values are: 1 – Black 2 – Asian 3 – Native American 4 – Hispanic 5 – White 6 – Hawaiian |
| HERITAGE_CODE_DESCR | VARCHAR(15) | The description associated with the heritage code. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |