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

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.