Hello EAH Developers - The below enhancements are included in this month's EAH Release.

Keep up with our future enhancements here: EAH Bugs and Enhancements In Progress

Learn more about the Employee Activity Hub in the EAH Quick Start Guides.

Table of Contents

Schedule

Friday, July 5: release enhancements to User Acceptance Testing
Thursday, July 11 end of day: release enhancement to Production
Friday, July 12, end of day: delete QA models

Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

Kacy Cashatt
David Mandell
Raul Navarro Rodriguez
Tiffany Swiderski
Eva Thiveos

New Views

EAH-GradWorkPeriodDetail-View - UAT will continue through August

BIA and the Grad Division is excited to release the EAH-GradWorkPeriodDetail-View. This view is a subset of data from the EAH-Workforce-View that is focused on employees with Graduate and Grad Academic Titles - which could include undergrads.

This view will be part of the EAH Core views and include row level security. This view will be going to Production in August 2024.

Epic: EAHE-3174 - Getting issue details... STATUS

SNOW tickets addressed: CS1902856

Fields include:

Calendar Quarter (Q)
Calendar Type
Calendar Type Code
Calendar Year (YYYY)
Employee ID
Employee Name Current
Employee PPS ID Current
Employee Record
Employee Work Days Per Period
Employee Work Days Per Period Prorated
Identity Student PID Current
Job Code
Job Code Description
Job Code Tuition Eligible Count
Job Code Tuition Eligible Flag
Job FTE
Term
Term Code
Union
Union Code
Work Days Per Period
Work Days Per Period Prorated
Work Period End Date
Work Period Job End Date
Work Period Job Start Date
Work Period Start Date

EAH-LLOriginalCombo-View - New Plan: Instead of creating a new view, the data in this view will be blending into the existing Labor Ledger views.

Epic: EAHE-3146 - Getting issue details... STATUS

SNOW tickets addressed: CS1924743

View Your Requested Enhancements

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

EAH-LLSalaryDetail-View

Epic: EAHE-3211 - Getting issue details... STATUS

SNOW ticket(s) addressed: CS1924743

Added the following new fields:

LL Salary Original Budget Reference OTC Indicator Code
LL Salary Original CCOA
LL Salary Original CCOA Entity
LL Salary Original CCOA Entity Code
LL Salary Original CCOA FinU
LL Salary Original CCOA FinU Code
LL Salary Original CCOA FND SRC
LL Salary Original CCOA FND SRC Code
LL Salary Original CCOA Funct
LL Salary Original CCOA Funct Code
LL Salary Original CCOA Fund
LL Salary Original CCOA Fund Code
LL Salary Original CCOA Project
LL Salary Original CCOA Project Code
LL Salary Original CCOA TASK
LL Salary Original CCOA TASK Code
LL Salary Original Department
LL Salary Original Department Code

EAH-LLFringeDetail-View, EAH-LLSalaryDetail-View & EAH-LLSalaryFringeDetail-View

Epic: EAHE-3178 - Getting issue details... STATUS

SNOW ticket(s) addressed: CS1988976

Added the following new fields:

Last Closed Accounting Period Flag
Last Closed Accounting Period Count
Last Opened Accounting Period Flag
Last Opened Accounting Period Count

EAH-LLSalaryFringeDetail-View

Epic: EAHE-3209 - Getting issue details... STATUS

SNOW ticket(s) addressed: CS1924743

Added the following new fields:

LL Original Budget Reference OTC Indicator Code
LL Original CCOA
LL Original CCOA Entity
LL Original CCOA Entity Code
LL Original CCOA FinU
LL Original CCOA FinU Code
LL Original CCOA FND SRC
LL Original CCOA FND SRC Code
LL Original CCOA Funct
LL Original CCOA Funct Code
LL Original CCOA Fund
LL Original CCOA Fund Code
LL Original CCOA Project
LL Original CCOA Project Code
LL Original CCOA TASK
LL Original CCOA TASK Code
LL Original Department
LL Original Department Code

EAH-PersonTraining-View

Epic: EAHE-3207 - Getting issue details... STATUS

SNOW ticket(s) addressed: CS2000190

Updated the following logic: Name of the Training

Original logic = Training Activity will show the original name of the training.
New logic = Training Activity will show the updated name of the training.

EAH-Workforce-View & EAH-WorkforceAllRows-View

Epic: EAHE-3213 - Getting issue details... STATUS

SNOW ticket(s) addressed:

Added the following new fields:

Union Code End Date
Union Code Start Date

UAT - Customer Service Reminder

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly. For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT. If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

Follow our Enhancement User Acceptance Testing (UAT) Steps

Use this UAT time to adjust your reports as needed prior to the Production release where your customers will be able to see any issues these enhancements cause.

Cognos: Use the packages in Cognos DEV > Student Activity Hub > Student Activity Hub Packages UAT to build your report and select Hana QA. Do not select Hana Prod as the report will fail. Using Hana QA will allow you to see the below enhancements with Production data.
Tableau: Sign into Tableau on your Tableau desktop tool and open your report. Add a new data source with the same name and -QA at the end of the title. Using this data source will allow you to see the below enhancements with Production data.
Hana QA: SAH data in Hana QA is production data loaded daily, just like in Hana PROD.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

What browser are you using?
What environment are you using? Cognos DEV, QA or PROD? Or Tableau?
What data source / package are you using?
What results were you expecting?

Reminder: QA data sources will be deleted the Friday after the enhancements are migrated to Production.

Browser not supported