This view contains all of the basic core employee information. Start here and then branch out if you are need finding the data you need.
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 Data:
EAH-Workforce-View includes data on employee job,position,salary information, and benefits eligibility for all employee types.
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 Code = C
- Job Effective Sequence Indicator Code - Max is the current record for 1 row per empid and record number, Prior is previous record
- Job Indicator
- Organizational Relationship
- HR Status
- Employee Status
- Job Code = CONV are converted records that can be filtered out if not needed