Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

This view contains components of an employee's base pay.  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 Salary Journal ID
  • LL Salary GL Journal Line Number
  • LL Salary Journal Line Reference
  • LL Salary Additional Sequence Number

Key Fields to use as filters:

  • LL Pay Confirmation Flag Current
  • LL Position Fund Run Flag Current
  • LL Pay GL Interface Run Flag Current

Notes 

  • LLSalaryDetail View - Actual distribution for the past.  It has the monetary amount associated with distribution and the user can summarize and formulate the actual distribution percentage that the user is looking for.  This is also the view that drives DOPES report that UC Path version has been released

  • No labels