20200909 EAH Start UAT Release Notes

To: Employeeanalytics-COP-l@ucsd.edu
Cc: ITS-BIA <its-bia@ucsd.edu>;  ITS-DataIntergrationServices <ITS-DataIntergrationServices@AD.UCSD.EDU>; Beatrice Dormoy <bea@ucsd.edu>; Linardos, Nickolas <nlinardos@UCSD.EDU>; Lorentz, Brian <blorentz@ucsd.edu>
Subject: EAH enhancements - UAT available - due Sept 16th

Hello EAH Developers - We are excited to release a number of Employee Activity Hub enhancements for you to test between now and end of day September 16.  If you find an issue, please email busintel@ucsd.edu with a subject line "EAH UAT due Sept 16" right away so we can address it prior to September 16.

In Cognos DEV open your report and replace the current package with the package of the same name from the Team Content > Employee Activity Hub > EAH Analytics Packages UAT folder.  Run the report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using the new package from the EAH Analytics Packages UAT folder will allow you to see the below enhancement.  EAH data is the same in Hana prod and Hana QA.

Sign into Tableau QA 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.  Replace the original data source with the –QA data source.  Using the –QA data source will allow you to see the below enhancements.  EAH data is the same in Hana prod and Hana QA.  Please use this UAT time to adjust your reports as needed prior to September 16 when your customers will be able to see any issues these enhancements cause.  If you make adjustments to your report(s), please email busintel@ucsd.edu to schedule a migration of your folder from Cognos DEV to Cognos PROD for September 16 to coincide with the EAH migration to production.

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?  Tableau QA or Prod?
  • What data source / package are you using?
  • What results were you expecting?

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

ViewEnhancementEpic
EAH-Benefits-View
  • Added all of the extended Workforce fields to the view
  • Add Identity EPPN Current
EAHMAINT-892
EAH-EmployeeDeographics-View
  • Add Identity EPPN Current
EAHMAINT-990
EAH-IdentityDemographics-View
  • Add Identity Photo File
  • Add Identity Photo Location
EAHMAINT-944
EAH-LLActualDetail-View
  • Add LL Employee CBR Rate Code
  • Repoint LL Employee CBR Rate Group
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
EAHMAINT-908
EAH-LLDeductionDetail-View
  • Add LL Employee CBR Rate Code
  • Repoint LL Employee CBR Rate Group
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
EAHMAINT-910
EAH-LLFringeDetail-View
  • Add LL Fringe Award Number
  • Add LL Fringe Award Title
  • Add LL Employee CBR Rate Code
  • Repoint LL Employee CBR Rate Group
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
EAHMAINT-899
EAH-LLSalaryDetail-View
  • Add LL Salary Award Number
  • Add LL Salary Award Title
  • Add LL Employee CBR Rate Code
  • Repoint LL Employee CBR Rate Group
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
EAHMAINT-896
EAH-Payroll-View
  • Add Pay Check Pay Group
  • Add Pay Check Total Gross YTD
  • Add Pay Check Total Deductions YTD
  • Add Pay Check Total Taxes YTD
  • Add Pay Check Net Pay YTD
EAHMAINT-914
EAH-PayrollDeductionDetail-ViewNew viewEAHMAINT-813
EAH-PayrollEarningsDetail-ViewNew viewEAHMAINT-730
EAH-PayrollTaxDetail-ViewNew viewEAHMAINT-814
EAH-Position-View
  • Add Position Employee Relations
EAHMAINT-1004
EAH-PositionFunding-View
  • Add LL Employee CBR Rate Code
  • Repoint LL Employee CBR Rate Group
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
  • Add Position Funding Award Number
  • Add Position Funding Award Title
  • Add Identity Student PID Current
  • Add Identity Instructor PID Current
  • Add Identity EPPN Current
  • Add Position Employee Relations Code
  • Add Position Employee Relations
EAHMAINT-897
EAH-Workforce-View
  • Add CBR Category Code
  • Add Identity EPPN Current
  • Add Identity Student PID Current
  • Add Identity Instructor PID Current
  • Add LL Employee CBR Rate Code
  • Add LL Employee UCPath CBR Rate Code
  • Add LL Employee UCPath CBR Rate Group
  • Add Position Employee Relations Code and description.
  • Add Position Funding Award Number
  • Add Position Funding Award Title
  • Add UCPath CBR Category Code
  • Add UCPath CBR Category
  • Repoint CBR Category
  • Repoint LL Employee CBR Rate Group

EAHMAINT-920

CS0213967   

EAH-WorkforceRestricted-ViewNew viewEAHMAINT-790