- DATA VIEW NAME
- HR_Heritage_Hist
- OVERVIEW
- The HR_Heritage_Hist data view contains all heritage codes on record for individual employees over time. The data has records available for past, present, and future employees along with any changes that have occurred to their Heritage Codes since November 2009.
This data view contains sensitive information and the data has no authorization filter. Therefore, this data view should only be given to a select few University staff who have the business need to see this data
- LOAD FREQUENCY
- The data will be refreshed nightly, Monday thru Friday evening.
- DATA CUSTODIAN
- Office of Equity and Diversity
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 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.
Special Considerations
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 will need to use the Effective and End Dates of the Heritage Codes to make sure you are selecting the correct time period of interest.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 11/09 – New view created.
3/10 – 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 |
|---|---|---|
| *PERSON_ID | VARCHAR(8) | A unique number assigned to a person. It is always the same. |
| *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. |
| ACTIVE_IND | VARCHAR2(1) | Indicates status of the heritage. Valid values are: Y – Active status. Blank – Heritage code has already been end-dated. |
| *EFF_DATE | DATE | The date on which the heritage was entered as claimed by the person, via IADS transaction PRVY. Format: YYYYMMDD. |
| END_DATE | DATE | The date on which the heritage was entered as no longer claimed by the person, via IADS transaction PRVY. Format: YYYYMMDD. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |