Getting Started

Have a field name but not sure what view to look in? Search the Activity Hub Field List.

Data is loaded into the Employee Activity Hub (EAH) 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.

EAH Basics

UCPath data is sent from UCOP to UCSD on a nightly basis. EAH-Workforce-View is the first view to run and therefore will be the first available.
Current = reflects the value as of today/last data load
AsOf = aka History, reflects the value as of a date depending on the Data Source View, field, and desired outcome.
Identity fields come from internal UCSD identity systems, not UCPath
Student employees can be identified by using the Employee Class field.

CCOA = Common Chart of Accounts

UCPath and Oracle maintain separate Common Charts of Accounts. EAH provides the CCOA values from the sources indicated below, as requested by the report developer community. You can find these field in the Labor Ledger views and Position Funding view.

Field	Source

Field	Source
CCOA Entity	UCPath
CCOA Fund	UCPath
CCOA FinU	OFC
CCOA Account	OFC
CCOA Funct	UCPath
CCOA Program	UCPath
CCOA Location	UCPath
CCOA Project	OFC
CCOA Activity	UCPath
CCOA TASK	OFC
CCOA FND SRC	UCPath

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 > Public > AH Data Load Status Report.

Find the View You Need

View Name aka Cognos/Tableau Data Source View	Use this view when you are looking for...	+Includes Demographics Fields	Narrow or Wide?	Current and/or AsOf?	View Protection Level	Includes row-level security?

View Name aka Cognos/Tableau Data Source View	Use this view when you are looking for...	+Includes Demographics Fields	Narrow or Wide?	Current and/or AsOf?	View Protection Level	Includes row-level security?
EAH-AbsenceDetail-View	Employee absence activtiy and balances by absence type	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-AccrualHours-View	Employee accrual eligible hours by month for Leave, FMLA, Sabbatical and Benefits Eligibility	EmployeeDemographics	Narrow		P3	Yes - Includes Row Level Security
EAH-AddlPayDetail-View	Planned one-time or recurring pay for additional work or bonus pay.	No	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-ApprovalDirectRetroDetail-View					P3	No row level security
EAH-ApprovalFundingEntryDetail-View					P3	No row level security
EAH-ApprovalSmartHRDetail-View					P3	No row level security
EAH-ApprovalWorklist-View					P3	No row level security
EAH-BenefitBillingEnrollment-View	The Benefits Billing module allows for a company to charge the employee or dependent for benefits and track payment collection outside of payroll deduction.	EmployeeDemographics	Both	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitDisabilityDetail-View	Employee basic, short term, long term, and supplemental disability benefit plan enrollments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitFSADetail-View	Employee FSA / HSA benefit plan enrollments and YTD balance tracking	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitHealthDetail-View	Employee Medical, Dental, Vision, Legal Services, Wellness, Behavioral, Prescription plan enrollments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitLifeDetail-View	Employee Life, Supplemental Life, AD & D, Dependent life plan enrollments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitRetireDetail-View	Employee UC Retirement plan enrollments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitSavingsDetail-View	Employee 403(b) and 457(b) plan enrollments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-BenefitSavingsExtension-View	Employee savings plan balances and limits.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-Benefits-View	Employee current benefit enrollments	No	Wide		P3	Yes - Includes Row Level Security
EAH-CertificationActivities-View	Tracking employee patent amendment form completion.	EmployeeDemographics	Narrow		P3	Yes - Includes Row Level Security
EAH-Compensation-View	Components of an employee's base pay. This is a child of the JOB record.	No	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-Contract-View	Employee contract pay information.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-DeductionBalance-View	YTD, QTD and MTD payroll deduction balances by employee, calendar and fiscal year.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-Degree-View	Employee profile degree information.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-DepartmentHierarchy-View	Hierarchy of Department Levels.	No	Narrow		P3	No row level security.
EAH-EarningsBalance-View	YTD, QTD and MTD payroll earnings balances by employee, calendar and fiscal year.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-EmergencyContact-View	Employee emergency contact information.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-EmployeeDemographics-View	Employee current demographics information	EmployeeDemographics	Narrow		P3	Yes - Includes Row Level Security
EAH-ExtendedAbsence-View	Employee extended absence types and dates.	EmployeeDemographics	Narrow	Current & AsOf	P3	No row level security.
EAH-GeneralDeductionDetail-View	Planned one-time or recurring additional paycheck deductions beyond core benefits.	No	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-IdentityDemographics-View	Employee Identity Information. *For data integration.	No	Narrow		P3	No row level security.
EAH-JobCodeSalaryPlan-View	Jobcode and Related Salry Plan, Grade and Step attribues. No employee Data.	No	Wide		P3	No row level security.
EAH-JobEarnsDist-View	Optional overrides to employee default payroll earnings and position distributions.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-License-View	Employee profile license information.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-LLActualDetail-View	All detailed actual transactions (Expenses & Liabilities) that were associated with Deductions in the Composite Benefit Rate. Details will not include an FAU.	LLEmployeeDemo	Narrow		P3
EAH-LLDeductionDetail-View	All detailed Liability transactions excluding any actual benefit liabilities built into the CBR. All details stored at the FAU level.	LLEmployeeDemo	Narrow		P3
EAH-LLFringeDetail-View	All detailed Employer Contribution expense transactions excluding any Actual Benefit expenses built into the CBR. All details stored at the detailed FAU level.	LLEmployeeDemo	Narrow	Current	P3	No row level security.
EAH-LLSalaryDetail-View	All Salary Expenses for a particular Employee at the most granular FAU level.	LLEmployeeDemo	Narrow	Current	P3	No row level security.
EAH-LLSalaryFringeDetail-View	Combined LLFringe and LL Salary	LLEmployeeDemo	Narrow	Current	P3	No row level security.
EAH-LLSummary-View	Contents of Labor Ledger Summary table.	No	Narrow		P3	No row level security.
EAH-PayCalendar-View	Pay Calendar Information for Employees.	No	Narrow		P3	No row level security.
EAH-PayCalenderDetail-View					P3	No row level security.
EAH-PayrollChartStringCombination-View				Current & AsOf	P3	No row level security.
EAH-PayrollDeductionDetail-View	Payroll Deduction Information for Employees.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-PayrollEarningsDetail-View	Payroll Earnings Information for Employees.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-PayrollEarningsTransactionDetail-View					P3	Yes - Includes Row Level Security
EAH-PayrollProjectionPerMonth-View					P3
EAH-PayrollSpecialEarningsDetail-View					P3	Yes - Includes Row Level Security
EAH-PayrollTaxDetail-View	Payroll Tax Detail Information for Employees.	EmployeeDemographics	Narrow		P3	Yes - Includes Row Level Security
EAH-Payroll-View	Employee paycheck information and related federal and state tax withholding attributes.	No	Wide		P3	Yes - Includes Row Level Security
EAH-PersonTraining-View	Employee training data	EmployeeDemographics	Narrow	Current	P3	No row level security.
EAH-PositionBudgetComparisonSummary-View					P3	Yes - Includes Row Level Security
EAH-PositionBudgetDistribution-View	This view uses the UCPath Budget Distribution page which displays all UCSD staff and is where permanent staffing will be managed going forward.	No		Current	P3	Yes - Includes Row Level Security
EAH-PositionFunding-View	Planned position funding distribution. *Does not contain Active Contingent Workers, Active ‘Without Salary’ employees, or Active paid employees with positions where UCSD has not entered position funding	EmployeeDemographics	Narrow	Current & AsOf	P3	No row level security.
EAH-PositionPerMonth-View					P3	No row level security.
EAH-Position-View	Position attributes	No	Wide	Current & AsOf	P3	No row level security.
EAH-Security-View					P3
EAH-Tax1042Balance-View	YTD, QTD and MTD payroll 1042 reportable witholding tax balances by employee, calendar and fiscal year.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-TaxBalance-View	YTD, QTD and MTD payroll tax balances by employee, calendar and fiscal year.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-TimeReported-View						Yes - Includes Row Level Security
EAH-UCRoleDepartmentDetail	User Security by Departments	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-UCRole-View	User security roles and related UC attributes.	EmployeeDemographics	Narrow	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-Workforce-View	Employee job, position, salary information and benefits eligibility. Row level security limits what the user sees to only the department they have been approve to see. *Includes all employee types	EmployeeDemographics	Wide	Current & AsOf	P3	Yes - Includes Row Level Security
EAH-WorkforceAllRows-View	Employee job, position, salary information and benefits eligibility. Shows all departments and should be used for report development or testing prior to reporting a report to EAH-Workforce-View. All fields and folders are named the same as EAH-Workforce-view.	EmployeeDemographics	Wide	Current & AsOf	P3	No row level security.
EAH-WorkforceRestricted-View	Employee job, position, salary information and benefits eligibility including P4 demographic information.	EmployeeDemographics	Wide	Current & AsOf	P4	No row level security.
EAH-WorkforceRestrictedPer Month-View	Employee job, position, salary information and benefits eligibility including P4 demographic information. Grain: Same as Workforce + As Of Date	EmployeeDemographics	Wide	Current & AsOf	P4	No row level security.
EAH-WorkforceRestrictedPerMonthSnap-View	Employee job, position, salary information and benefits eligibility including P4 demographic information.	EmployeeDemographics	Wide	Current & AsOf	P4	No row level security.

Analytics Community of Practice (ACP)

EAH Quick Start Guide

Getting Started

EAH Basics

CCOA = Common Chart of Accounts

Data Loads

Find the View You Need