EAH - Find the View You Need
- Saparnell
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? |
|---|---|---|---|---|---|---|
Employee absence activity and balances by absence type | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee accrual eligible hours by month for Leave, FMLA, Sabbatical and Benefits Eligibility | EmployeeDemographics | Narrow |
| P3 | Yes | |
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 |
|
|
|
|
|
|
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 | |
Employee basic, short term, long term, and supplemental disability benefit plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee FSA / HSA benefit plan enrollments and YTD balance tracking | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
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 | |
Employee UC Retirement plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee 403(b) and 457(b) plan enrollments | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee savings plan balances and limits. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee current benefit enrollments | No | Wide |
| P3 | Yes | |
Tracking employee patent amendment form completion. | EmployeeDemographics | Narrow |
| P3 | Yes | |
Components of an employee's base pay. This is a child of the JOB record. | No | Narrow | Current & AsOf | P3 | Yes | |
Employee contract pay information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
YTD, QTD and MTD payroll deduction balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee profile degree information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
EAH-DepartmentHierarchy-View | Hierarchy of Department Levels. | No | Narrow |
| P3 | No |
YTD, QTD and MTD payroll earnings balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee emergency contact information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee current demographics information | EmployeeDemographics | Narrow |
| P3 | Yes | |
Employee extended absence types and dates. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
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 |
Optional overrides to employee default payroll earnings and position distributions. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
Employee profile license information. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
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 | |
All detailed Liability transactions excluding any actual benefit liabilities built into the CBR. All details stored at the FAU level. | LLEmployeeDemo | Narrow |
| P3 | No | |
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 | |
All Salary Expenses for a particular Employee at the most granular FAU level. | LLEmployeeDemo | Narrow | Current | P3 | No | |
Combined LLFringe and LL Salary | LLEmployeeDemo | Narrow | Current | P3 | No | |
EAH-LLSummary-View | Contents of Labor Ledger Summary table. | No | Narrow |
| P3 | No |
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 |
Employee paycheck information and related federal and state tax withholding attributes. | No | Wide |
| P3 | Yes | |
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-SystemRole-View | User security roles and related to UCSD systems like Kuali, Oracle and UCPath. |
| Wide | Current | P3 |
|
YTD, QTD and MTD payroll 1042 reportable witholding tax balances by employee, calendar and fiscal year. | EmployeeDemographics | Narrow | Current & AsOf | P3 | Yes | |
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 in UCPath only. | 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 |