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 LevelIncludes Row-Level Security?
EAH-AbsenceDetail-ViewEmployee absence activity and balances by absence typeEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-AccrualHours-ViewEmployee accrual eligible hours by month for Leave, FMLA, Sabbatical and Benefits EligibilityEmployeeDemographicsNarrow
P3Yes
EAH-AddlPayDetail-ViewPlanned one-time or recurring pay for additional work or bonus pay.NoNarrowCurrent & AsOfP3Yes
EAH-ApprovalDirectRetroDetail-View





EAH-ApprovalSmartHRDetail-View





EAH-ApprovalWorklist-View





EAH-BenefitBillingEnrollment-ViewThe Benefits Billing module allows for a company to charge the employee or dependent for benefits and track payment collection outside of payroll deduction.EmployeeDemographicsBothCurrent & AsOfP3Yes
EAH-BenefitDisabilityDetail-ViewEmployee basic, short term, long term, and supplemental  disability benefit plan enrollmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-BenefitFSADetail-ViewEmployee FSA / HSA benefit plan enrollments and YTD balance trackingEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-BenefitHealthDetail-ViewEmployee Medical, Dental, Vision, Legal Services, Wellness, Behavioral, Prescription plan enrollmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes

EAH-BenefitLifeDetail-View

Employee Life, Supplemental Life, AD & D, Dependent life plan enrollmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-BenefitRetireDetail-ViewEmployee UC Retirement plan enrollmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-BenefitSavingsDetail-ViewEmployee 403(b) and 457(b) plan enrollmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-BenefitSavingsExtensionEmployee savings plan balances and limits.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-Benefits-ViewEmployee current benefit enrollmentsNoWide
P3Yes
EAH-CertificationActivities-ViewTracking employee patent amendment form completion.EmployeeDemographicsNarrow
P3Yes
EAH-Compensation-ViewComponents of an employee's base pay. This is a child of the JOB record.NoNarrowCurrent & AsOfP3Yes
EAH-Contract-ViewEmployee contract pay information.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-DeductionBalance-ViewYTD, QTD and MTD payroll deduction balances by employee, calendar and fiscal year.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-Degree-ViewEmployee profile degree information.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-DepartmentHierarchy-ViewHierarchy of Department Levels.NoNarrow
P3No
EAH-EarningsBalance-ViewYTD, QTD and MTD payroll earnings balances by employee, calendar and fiscal year.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-EmergencyContact-ViewEmployee emergency contact information.EmployeeDemographicsNarrowCurrent & AsOfP3Yes

EAH-EmployeeDemographics-View

Employee current demographics informationEmployeeDemographicsNarrow
P3Yes
EAH-ExtendedAbsence-ViewEmployee extended absence types and dates.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-GeneralDeductionDetail-ViewPlanned one-time or recurring additional paycheck deductions beyond core benefits.NoNarrowCurrent & AsOfP3Yes
EAH-IdentityDemographics-ViewEmployee Identity Information.  *For data integration.NoNarrow
P3No
EAH-JobCodeSalaryPlan-ViewJobcode and Related Salry Plan, Grade and Step attribues. No employee Data.NoWide
P3No
EAH-JobEarnsDist-ViewOptional overrides to employee default payroll earnings and position distributions.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-License-ViewEmployee profile license information.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-LLActualDetail-ViewAll detailed actual transactions (Expenses & Liabilities) that were associated with Deductions in the Composite Benefit Rate. Details will not include an FAU.LLEmployeeDemoNarrow
P3No
EAH-LLDeductionDetail-ViewAll detailed Liability transactions excluding any actual benefit liabilities built into the CBR. All details stored at the FAU level.LLEmployeeDemoNarrow
P3No
EAH-LLFringeDetail-ViewAll detailed Employer Contribution expense transactions excluding any Actual Benefit expenses built into the CBR. All details stored at the detailed FAU level.LLEmployeeDemoNarrowCurrentP3No
EAH-LLSalaryDetail-ViewAll Salary Expenses for a particular Employee at the most granular FAU level.LLEmployeeDemoNarrowCurrentP3No
EAH-LLSalaryFringeDetail-ViewCombined LLFringe and LL SalaryLLEmployeeDemoNarrowCurrentP3No
EAH-LLSummary-ViewContents of Labor Ledger Summary table.NoNarrow
P3No
EAH-PayCalendar-ViewPay Calendar Information for Employees.NoNarrow
P3No
EAH-PayCalenderDetail-View



P3
EAH-PayrollChartStringCombination-View


Current & AsOfP3
EAH-PayrollDeductionDetail-ViewPayroll Deduction Information for Employees.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-PayrollEarningsDetail-ViewPayroll Earnings Information for Employees.EmployeeDemographicsNarrow Current & AsOfP3Yes
EAH-PayrollProjectionPerMonth-View



P3No
EAH-PayrollSpecialEarningsDetail-View



P3
EAH-PayrollTaxDetail-ViewPayroll Tax Detail Information for Employees.EmployeeDemographicsNarrow 
P3Yes
EAH-Payroll-ViewEmployee paycheck information and related federal and state tax withholding attributes.NoWide
P3Yes
EAH-PersonTraining-ViewEmployee training dataEmployeeDemographicsNarrowCurrentP3No
EAH-PositionBudgetComparisonSummary-View




Yes

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

EmployeeDemographicsNarrowCurrent & AsOfP3No
EAH-PositionPerMonth-View



P3
EAH-Position-ViewPosition attributesNoWideCurrent & AsOfP3No
EAH-Tax1042Balance-ViewYTD, QTD and MTD payroll 1042 reportable witholding tax balances by employee, calendar and fiscal year.EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-TaxBalance-ViewYTD, QTD and MTD payroll tax balances by employee, calendar and fiscal year. EmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-UCRoleDepartmentDetailUser Security by DepartmentsEmployeeDemographicsNarrowCurrent & AsOfP3Yes
EAH-UCRole-ViewUser security roles and related UC attributes.EmployeeDemographicsNarrowCurrent & AsOfP3Yes

EAH-Workforce-View

Employee job, position, salary information and benefits eligibility.

*Includes all employee types

EmployeeDemographicsWideCurrent & AsOfP3Yes

EAH-WorkforceRestricted-View

Workforce View with securityEmployeeDemographicsWideCurrent & AsOf
No