- DATA VIEW NAME
- CHRIS HR Transaction
- OVERVIEW
- CHRIS HR Transaction displays classified HR transaction information. This table can be used to look up HR transaction information such as certification number, transaction duration, current status, employee name, etc.
- LOAD FREQUENCY
- Nightly (Monday through Friday)
- DATA CUSTODIAN
- Classified Human Resources Office
Contacts:
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 - There are no special considerations.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 02/2005 – New view created.
02/2006 — Added Appointment_Type_Code, Appointment_Type_Descr,
Final_Title_Code, Final_Title_Descr, Final_Bargaining_Unit_Code,
Final_Bargaining_Unit_Descr & Changed UDDS_Descr
C4j
11/2007 Updated data custodian c4j - DATA FORMAT
- 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 |
|---|---|---|
| *HR_Transaction_Key | Number(15) | A unique identifier for an individual HR transaction in the CHRIS system. |
| Transaction_ID | Number(10) | Identifies the certification number. |
| Transaction_Type_Descr | Varchar2(30) | Identifies the type of HR transaction Valid values are: 01 – Position Vacancy 02 – Reclassification 03 – Update 06 – Reallocation 07 – Limited Term Employee |
| Transaction_Begin_Date | Date | Date HR transaction was entered. |
| Transaction_End_Date | Date | Date HR transaction was closed. |
| Transaction_Duration | Number(4) | Number of days transaction was in process. |
| Transaction_Duration_Adjusted | Number(4) | Number of days transaction was in process excluding the time transaction was in draft status. |
| Transaction_Completion_Ind | Char(1) | Y – Transaction complete. N – Transaction not approved yet. |
| Current_Status_Descr | Varchar2(100) | Status of HR transaction Valid values are: 01 – Draft 02 – Dept HR Review Validated 03 – Div HR Review Closed 04 – CHR Review CPO Review Cancelled 06 – Class Approved Contractually Posted 07 – Applicant(s) Referred 08 – Recruiting 09 – Selected 10 – Appointed 11 – Payrolled 19 – No LTE Applicant 20 – LTE Applicant Entered 22 – LTE Applicant Div Review 51 – Denied 52 – Withdrawn 59 – Reclass Approved 60 – Competition Required 61 – Reallocation Approved |
| Appointment_ID | Number(8) | A unique number assigned to each and every appointment. The assignment of an appointment ID number means a person has been selected but the appointment is not valid until the effective date is reached. An appointment record is the result of the association of a position with the individual who fills that position. A position is defined as a set of duties and responsibilities expected to be performed by the person who will be appointed. An appointment must exist for each person who is to be paid salary or stipend, and each person without pay who has a university affiliation. |
| Appointment_Type_Code | Varchar2(2) | Identifies the major personnel category for this appointment. Each type is governed by specific statutes and/or personnel regulations, policies, or procedures. Valid values are: CP – Classified Permanent CL – Classified LTEs CJ – Classified Project |
| Appointment_Type_Descr | Varchar2(30) | Identifies the major personnel category for this appointment. Valid values are: Permanent – Classified Project – Classified Limited Term – Classified |
| Final_Title_Code | Varchar2(10) | Used to identify the official University System title or WI civil service final title for the appointment. |
| Final_Title_Descr | Varchar2(21) | Descriptive name for the final title. |
| Final_Bargaining_Unit_Code | Varchar2(2) | Identifies the bargaining unit for this final title code. |
| Final_Bargaining_Unit_Descr | Varchar2(60) | Descriptive name for the final bargaining unit (i.e. WSEU, WPEC). |
| Employee_Name | Varchar2(60) | Name of employee. |
| Employee_First_Name | Varchar2(30) | First name of employee. |
| Employee_Middle_Name | Varchar2(30) | Middle name of employee. |
| Employee_Last_Name | Varchar2(30) | Last name of employee. |
| UDDS_Code | Varchar2(7) | This is the UDDS Code associated with the HR transaction. |
| UDDS_Descr | Varchar2(10) | The textual description of the UDDS Code. The field contains the abbreviated names for the division level, the department level and the subdepartment code levels, concatenated together. |
| Unit_Code | Char(1) | This is a breakdown of the UDDS field. It is the first character of the UDDS code. |
| Division_Code | Varchar2(2) | This is a breakdown of the UDDS field. It is the second two characters of the UDDS code. |
| Department_Code | Varchar2(2) | This is a breakdown of the UDDS field. It is the fourth and fifth characters of the UDDS code. |
| Subdepartment_Code | Varchar2(2) | This is a breakdown of the UDDS field. It is the last two characters of the UDDS code. |
| PD_Effective_Date | Date | HR transaction effective date. |
| Extract_Date_Time | Date | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |