20201009 EAH UAT Start Notes

From: Parnell, Sarah <saparnell@ucsd.edu>
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 October 16


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 October 16.  If you find an issue, please email busintel@ucsd.edu with a subject line "EAH UAT due Oct 16" right away so we can address it prior to October 16.

How to perform User Acceptance Testing (UAT):

  • 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 October 16 when your customers will be able to see any issues these enhancements cause. 

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
  • Add Identity Working Title Current
  • Add UCPath Job Start Date  (this will pull from JOB_ENTRY_DT with no filtering) 
  • Add UCPath Position Start Date (this will pull from POSITION_ENTRY_DT with no filtering)
  • Add Eligibility Configuration 8
  • Add Eligibility Configuration 8 Code
  • Add Work Authorization End Date Current
  • Add Work Authorization External System Current
  • Repoint FICA Status Employee Code
  • Repoint FICA Status Employee
EAHMAINT-1039
EAH-EmployeeDemographics-View
  • Add Identity Working Title Current
  • Add Work Authorization End Date Current
  • Add Work Authorization External System Current
EAHMAINT-1095
EAH-LLFringeDetail-View
  • Add "LL Fringe Earnings Period Start Date”   
  • Add "LL Fringe Earnings Period End Date"
EAHMAINT-1060
EAH-PositionFunding-View
  • Add Work Authorization End Date Current
  • Add Work Authorization External System Current
  • Add Position Funding OTC Indicator Code
  • Add Position Funding OTC Indicator Flag
  • Add Position Funding OTC Indicator Count
  • Add Position Funding Earnings Type
  • Add Position Funding Earnings Category Code
  • Add Position Funding Earnings Category
  • Add Position Funding Effort Bearing Flag
  • Add Position Funding Effort Bearing Count
  • Add "Position Funding Compensation Report Flag"
  • Add "Position Funding Compensation Report Count"
  • Add Position Funding Compensation Rate
  • Add Identity Working Title Current
  • Add UCPath Job Start Date  (this will pull from JOB_ENTRY_DT with no filtering) 
  • Add UCPath Position Start Date (this will pull from POSITION_ENTRY_DT with no filtering)
  • Add Eligibility Configuration 8
  • Add Eligibility Configuration 8 Code
  • Repoint Position_Funding CCOA Project from UCPath to OFC
  • Repoint FICA Status Employee Code
  • Repoint FICA Status Employee
EAHMAINT-1041
EAH-UCRole-ViewAdded Employee Demographic InformationEAHMAINT-721
EAH-UCRoleDepartmentDetail-ViewNew ViewEAHMAINT-1106
EAH-Workforce-View
  • Add Identity Working Title Current
  • Add UCPath Job Start Date  (this will pull from JOB_ENTRY_DT with no filtering) 
  • Add UCPath Position Start Date (this will pull from POSITION_ENTRY_DT with no filtering)
  • Add Eligibility Configuration 8
  • Add Eligibility Configuration 8 Code
  • Add Work Authorization End Date Current
  • Add Work Authorization External System Current
  • Repoint FICA Status Employee Code
  • Repoint FICA Status Employee
EAHMAINT-1036
EAH-WorkforceRestricted-View
  • Add Identity Working Title Current
  • Add UCPath Job Start Date  (this will pull from JOB_ENTRY_DT with no filtering) 
  • Add UCPath Position Start Date (this will pull from POSITION_ENTRY_DT with no filtering)
  • Add Eligibility Configuration 8
  • Add Eligibility Configuration 8 Code
  • Add Work Authorization End Date Current
  • Add Work Authorization External System Current
  • Repoint FICA Status Employee Code
  • Repoint FICA Status Employee
EAHMAINT-1037