EAH - Find the View You Need
How to Read This Table
View Name aka Cognos/Tableau Data Source View: The name of the Cognos package or Tableau data source
Use this view when you are looking for...: Short description of what
Includes Demographics Fields: If "EmployeeDemographics" is present in the column on the row for the column then that View includes EAH-EmployeeDemographics-View fIelds and the EAH-EmployeeDemographics-View Quick Start Guide will apply.
Narrow of Wide: Narrow views have many rows per person. Wide views have less rows per person and is closer to a pivot-table.
Current and/or AsOf? current indicates data that is the current value, AsOf indicates historical information.
View Protection Level: Indicates the highest level of Protection Level Classification for the fields in the view. See UC Classification Page for additional details.
Includes Row-Level Security: Yes indicates the view includes row-level security on the view. The customer will only see data they have been approved to see.
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 activity and balances by absence type | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-AccrualHours-View | Employee accrual eligible hours by month for Leave, FMLA, Sabbatical and Benefits Eligibility | EmployeeDemographics | Narrow | P3 | Yes | |
| EAH-AddlPayDetail-View | Planned one-time or recurring pay for additional work or bonus pay. | No | Narrow | Current & AsOf | P3 | Yes |
| EAH-ApprovalDirectRetroDetail-View | ||||||
| EAH-ApprovalSmartHRDetail-View | ||||||
| EAH-ApprovalWorklist-View | ||||||
| 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 |
| EAH-BenefitDisabilityDetail-View | Employee basic, short term, long term, and supplemental disability benefit plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-BenefitFSADetail-View | Employee FSA / HSA benefit plan enrollments and YTD balance tracking | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-BenefitHealthDetail-View | Employee Medical, Dental, Vision, Legal Services, Wellness, Behavioral, Prescription plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| Employee Life, Supplemental Life, AD & D, Dependent life plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
| EAH-BenefitRetireDetail-View | Employee UC Retirement plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-BenefitSavingsDetail-View | Employee 403(b) and 457(b) plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-BenefitSavingsExtension | Employee savings plan balances and limits. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-Benefits-View | Employee current benefit enrollments | No | Wide | P3 | Yes | |
| EAH-CertificationActivities-View | Tracking employee patent amendment form completion. | EmployeeDemographics | Narrow | P3 | Yes | |
| EAH-Compensation-View | Components of an employee's base pay. This is a child of the JOB record. | No | Narrow | Current & AsOf | P3 | Yes |
| EAH-Contract-View | Employee contract pay information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-DeductionBalance-View | YTD, QTD and MTD payroll deduction balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-Degree-View | Employee profile degree information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-DepartmentHierarchy-View | Hierarchy of Department Levels. | No | Narrow | P3 | No | |
| EAH-EarningsBalance-View | YTD, QTD and MTD payroll earnings balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-EmergencyContact-View | Employee emergency contact information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| Employee current demographics information | EmployeeDemographics | Narrow | P3 | Yes | ||
| EAH-ExtendedAbsence-View | Employee extended absence types and dates. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-GeneralDeductionDetail-View | Planned one-time or recurring additional paycheck deductions beyond core benefits. | No | Narrow | Current & AsOf | P3 | Yes |
| EAH-IdentityDemographics-View | Employee Identity Information. *For data integration. | No | Narrow | P3 | No | |
| EAH-JobCodeSalaryPlan-View | Jobcode and Related Salry Plan, Grade and Step attribues. No employee Data. | No | Wide | P3 | No | |
| EAH-JobEarnsDist-View | Optional overrides to employee default payroll earnings and position distributions. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-License-View | Employee profile license information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| 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 | No | |
| 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 | No | |
| 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 |
| EAH-LLSalaryDetail-View | All Salary Expenses for a particular Employee at the most granular FAU level. | LLEmployeeDemo | Narrow | Current | P3 | No |
| EAH-LLSalaryFringeDetail-View | Combined LLFringe and LL Salary | LLEmployeeDemo | Narrow | Current | P3 | No |
| EAH-LLSummary-View | Contents of Labor Ledger Summary table. | No | Narrow | P3 | No | |
| EAH-PayCalendar-View | Pay Calendar Information for Employees. | No | Narrow | P3 | No | |
| EAH-PayCalenderDetail-View | P3 | |||||
| EAH-PayrollChartStringCombination-View | Current & AsOf | P3 | ||||
| EAH-PayrollDeductionDetail-View | Payroll Deduction Information for Employees. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-PayrollEarningsDetail-View | Payroll Earnings Information for Employees. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-PayrollProjectionPerMonth-View | P3 | No | ||||
| EAH-PayrollSpecialEarningsDetail-View | P3 | |||||
| EAH-PayrollTaxDetail-View | Payroll Tax Detail Information for Employees. | EmployeeDemographics | Narrow | P3 | Yes | |
| EAH-Payroll-View | Employee paycheck information and related federal and state tax withholding attributes. | No | Wide | P3 | Yes | |
| EAH-PersonTraining-View | Employee training data | EmployeeDemographics | Narrow | Current | P3 | No |
| EAH-PositionBudgetComparisonSummary-View | Yes | |||||
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 | |
| EAH-PositionPerMonth-View | P3 | |||||
| EAH-Position-View | Position attributes | No | Wide | Current & AsOf | P3 | No |
| 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 |
| EAH-TaxBalance-View | YTD, QTD and MTD payroll tax balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-UCRoleDepartmentDetail | User Security by Departments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
| EAH-UCRole-View | User security roles and related UC attributes. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes |
Employee job, position, salary information and benefits eligibility. *Includes all employee types | EmployeeDemographics | Wide | Current & AsOf | P3 | Yes | |
EAH-WorkforceRestricted-View | Workforce View with security | EmployeeDemographics | Wide | Current & AsOf | No |