EAH Quick Start Guide
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 |
---|---|
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? |
---|---|---|---|---|---|---|
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 |
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 |
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 | |
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 |
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. |