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 18 Next »

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.

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 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 *= 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

"*" These 3 field filters would return 1 row per person with the indicated filter values.

  • No labels