This view contains all detailed employer contribution expense transactions excluding any Actual Benefit expenses built into the CBR. All details stored at the detailed FAU level. 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
Fields that make up the primary key:
- LL Employee ID
- LL Employee Record
- LL Job Action Effective Date
- LL Job Effective Sequence Number
- LL Pay Run Code
- LL Earnings Run Code
- LL Business Unit Code
- LL Pay Check Off Cycle Flag
- LL Earnings Type Code
- LL Fringe Journal ID
- LL Fringe GL Journal Line Number
- LL Fringe Journal Line Reference
- LL Fringe Additional Sequence Number
Key Fields to use as filters:
- 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.
- LL Fringe CCOA Project
- LL Fringe CCOA Task
- LL Fringe CCOA Location
- LL Fringe CCOA Program
- LL Fringe CCOA Function
- LL Fringe CCOA FINU
- LL Fringe CCOA Entity
- LL Fringe CCOA Fund Source