This view contains all of the basic core employee information. Start here and then branch out if you are not finding the data you need.
EAH-Workforce-View includes data on employee job,position,salary information, and benefits eligibility for all employee types.
Granularity:
One row per employee, per employee record, per job action effective date, per job effective sequence numbers.
| Level | Key (uniqueness / group by) | Measures | |
|---|---|---|---|
| 1 | Employee | Employee ID | |
| 2 | Employee Record | Employee ID + Employee Record | |
| 3 | Job Action Effective Date | Employee ID + Employee Record + Job Action Effective Date | |
| 4 | Lowest | Employee ID + Employee Record + Job Action Effective Date + Job Effective Sequence Number |
Key Fields: *Make Up the Primary Key
- Employee ID*
- Employee Record*
- Job Action Effective Date (use in combination w/above depending on current or as of date requirements of your report)
- Job Effective Sequence Number (use in combination w/above depending on current or date requirements of your report)
Key Fields to use as filters:
- Job AsOf Indicator *= Values of Current, History, and Future in cases where there are Future positions or jobs in UCPath.
- Job Effective Sequence Indicator *= Maximum is the current record for 1 row per empid and record number, Prior is previous record
- Job Indicator *= Primary returns only the primary job when employee has concurrent jobs
- Organizational Relationship - values EMP for Employees and CWR for Contingent Workers
- HR Status - Values of Active and Inactive
- Employee Status - 6 Values of Active Paid Leave of Absence, Retired, etc.
- Job Code = CONV are converted records that can be filtered out if not needed
- Employee Class - Values of Academic, Staff, Student etc.
- Position Pool - Values of WS-Federal, WS-Math/Reading Tutors
- Job Action has values - Termination, Hire, Rehire etc.
- Job Action Reason has values - Rehire, Academic Concurrent Hire etc.
- Union Code has values - Service, Technical, Academic Researchers etc.
- Employee Type has values - Salaried, hourly etc.
- Salary Plan has values - RX Salary Plan, Career Tracks etc.
- FLSA Status has values - Exempt, Nonexempt
- Occupation Sub Group has values - Managers, Facilities, Contingent Workers etc.
- Eligibility Configuration codes
- Class Indicator has 5 values of Academic, Senior Management Group etc.
- Full/Part Time Indicator has values - Variable, Fixed etc.
- Probation Status has values - Within Probation, probation Completed etc.
- Salary Grade has values - Professor, Assistant Professor, Technical Assistant etc.
- Location Use Type
"*" These 3 field filters would return 1 row per person with the indicated filter values.