20200918 EAH Release Notes

From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Friday, September 18, 2020 8:04 PM
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: RE: EAH enhancements - UAT available - due Sept 16th


Happy Friday!  The below enhancements have successfully been moved into Production.


Thanks for being awesome,

Sarah Parnell

Analytics Community of Practice Manager

Business Intelligence & Analytics | Information Technology Services | UC San Diego

https://ucsdcollab.atlassian.net/wiki/x/A4C0C

work cell: 858-354-9709

My pronouns [https://www.mypronouns.org/]: she/her/hers

Join my Slack workspace: UCSD Analytics https://join.slack.com/t/ucsdanalytics/shared_invite/zt-dfkjum6q-Lc9jF8W4XpIoHXDE_~FddA

“I take care of step 1 thru 3 so you can get to step 4 faster. What’s your step 1?” - Sarah


From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Wednesday, September 16, 2020 7:13 PM
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: RE: EAH enhancements - UAT available - due Sept 16th


Hi folks - Good news!  We have received no notifications of issues associated with this release.  Due to the size of this release we've decided to wait until Friday 9/18 at 3pm PST to start the release as it will impact those who are using the affected views during this window.  Please note that if you are using any of the below views via Tableau or Cognos or column groups you may see a brief interruption in data availability.  Feel free to take a stretch break during this time.


Thanks for being awesome,

Sarah Parnell

Analytics Community of Practice Manager

Business Intelligence & Analytics | Information Technology Services | UC San Diego

https://ucsdcollab.atlassian.net/wiki/x/A4C0C

work cell: 858-354-9709

My pronouns [https://www.mypronouns.org/]: she/her/hers

Join my Slack workspace: UCSD Analytics https://join.slack.com/t/ucsdanalytics/shared_invite/zt-dfkjum6q-Lc9jF8W4XpIoHXDE_~FddA

“I take care of step 1 thru 3 so you can get to step 4 faster. What’s your step 1?” - Sarah


From: Parnell, Sarah <saparnell@ucsd.edu>
Sent: Wednesday, September 9, 2020 5:36 PM
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.

View

Enhancement

Epic

EAH-Benefits-View

·         Added all of the extended Workforce fields to the view

·         Add Identity EPPN Current

EAHMAINT-892

EAH-EmployeeDemographics-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-View

New view

EAHMAINT-813

EAH-PayrollEarningsDetail-View

New view

EAHMAINT-730

EAH-PayrollTaxDetail-View

New view

EAHMAINT-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   


Thanks,

Sarah Parnell

Analytics Community of Practice Manager

Business Intelligence & Analytics | Information Technology Services | UC San Diego

saparnell@ucsd.edu

work cell: 858-354-9709

My pronouns [https://www.mypronouns.org/]: she/her/hers

Join my Slack workspace: UCSD Analytics https://join.slack.com/t/ucsdanalytics/shared_invite/zt-dfkjum6q-Lc9jF8W4XpIoHXDE_~FddA 

“My job is to make your job easier.  Where do you want to start?” - Sarah