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 | |
EAH-EmployeeDemographics-View | · Add Identity EPPN Current | |
EAH-IdentityDemographics-View | · Add Identity Photo File · Add Identity Photo Location | |
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 | |
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 | |
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 | |
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 | |
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 | |
EAH-PayrollDeductionDetail-View | New view | |
EAH-PayrollEarningsDetail-View | New view | |
EAH-PayrollTaxDetail-View | New view | |
EAH-Position-View | · Add Position Employee Relations | |
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 | |
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 |
Thanks,
Sarah Parnell
Analytics Community of Practice Manager
Business Intelligence & Analytics | Information Technology Services | UC San Diego
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