Overview

This view contains all of the basic core employee information.  Start here and then branch out if you are not finding the data you need.

EAH-Workforce-View includes data on employee job,position,salary information, and benefits eligibility for all employee types.

Other Resources

• Have a field name but not sure what view to look in?  Search the Activity Hub Field List. 
• Data is loaded into the Student Activity Hub (SAH) each night.  To see when the data load completed, use see this report: Tableau > Public > AH Data Load Status Report.
• Additional support can be found in the Analytics Community of Practice. 

Critical Concepts

Appointments

Identity Fields

Identity data is loaded into EAH on a nightly basis and comes from a combination of:

• Affiliates_safe_attributes
• Rosetta_Stone
• System
• Employee
• Building - Source Phone directory, managed by the TMS team.
• IDCard_Lookup

Job Code Description, Position or Job Org Business Title

For Job Code Description, Position and Job Org Business Title: All three are managed within UCPath. Job Code Description is the origin. Position inherits the Job Code description upon position creation. Job Org Business Title inherits from position description when a Job record is created. It is a business decision to override the Position or Job Org Business Title with a more descriptive value. When the business overrides the position description, it flows through to the Job Org Business title. While UCSD HR does not train or tell departments to override the Job Org Business title, they can absolutely do so and HR has no control to stop them.

Job Indicator

For predicable reporting results we desire each unique UCPath person to have exactly one 'Primary' workforce record for the current effective date, regardless of status.

For some edge cases, current workforce data in the ODS does not have exactly one primary job. Scenarios include, but are not limited to
- multiple job employees whose primary job is at a location other than UCSD
- some inactive employees
- some contingent workers

We calculate a primary job for these cases and pull it into the 'Job Indicator' field as 'Primary'. The Job Indicator Calculated field is for transparency to distinguish which Job Indicator values are assigned 'Primary' coming from UCPath vs 'Calculated' using our custom EAH logic.

Position Funding in CCOA

Prebuilt Filters in Cognos and Tableau

Steps to Take

Key Fields to Display

*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 Filter on

• 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
• 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.
• Employee Type has values - Salaried, hourly etc.
• Salary Plan has values - RX Salary Plan, Career Tracks etc.
• FLSA Status has values - Exempt, Nonexempt
• Occupation Sub Group has values - Managers, Facilities, Contingent Workers etc.
• Eligibility Configuration codes
• Class Indicator has 5 values of Academic, Senior Management Group etc.
• Full/Part Time Indicator has values - Variable, Fixed etc.
• Probation Status has values - Within Probation, probation Completed etc.
• Salary Grade has values - Professor, Assistant Professor, Technical Assistant etc.
• Location Use Type

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

Granularity

Granularity is the scale or level of detail present in a set of data.  It identifies where levels of uniqueness exists in the data.  The data lives in the view at the lowest level, but each BI tool totals the levels differently.

Please note:  The Level of Detail (LOD) calculations listed here for Tableau developers are a baseline and do not necessary include all of the LOD equations needed for your report.