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