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.
Granularity:
One row per employee, per employee record, per job action effective date, per job effective sequence numbers.
Data Loads:
UCPath data is sent from UCOP to UCSD on a nightly basis. To see when the data completed being loaded by UCSD into EAH see this report: Tableau QA > Public > AH Data Load Status Report
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)
EAH-Workforce-View includes data on employee job,position,salary information, and benefits eligibility for all employee types.
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
"*" These 3 field filters would return 1 row per person with the indicated filter values.