202407 EAH Release Notes

Owned by Saparnell
Last updated: Aug 27, 2024
4 min read

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.