20200813 - Start UAT in Cognos and Tableau

To: Employeeanalytics-COP-l@ucsd.edu
Cc: ITS-BIA <its-bia@ucsd.edu>;
Subject: EAH enhancements - UAT available - due Aug 20th


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

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 August 20 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 August 20 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
All Views
  • *Removed "Employee Disability Percentage AsOf",

  • *Removed "Employee Disability Status Code AsOf",

  • *Removed "Employee Disability Status Flag AsOf",

  • *Removed "Employee Disability Status Count AsOf",

  • *Removed "Employee Disability Veteran Flag AsOf",

  • *Removed "Employee Disability Veteran Count AsOf",

  • *Removed "Employee Disability HR Disclosure Date AsOf",

  • *Removed "Employee EEO AmIndian Flag AsOf",

  • *Removed "Employee EEO AmIndian Count AsOf",

  • *Removed "Employee EEO Asian Flag AsOf",

  • *Removed "Employee EEO Asian Count AsOf",

  • *Removed "Employee EEO Black Flag AsOf",

  • *Removed "Employee EEO Black Count AsOf",

  • *Removed "Employee EEO Hawaiian Flag AsOf",

  • *Removed "Employee EEO Hawaiian Count AsOf",

  • *Removed "Employee EEO Hispanic Flag AsOf",

  • *Removed "Employee EEO Hispanic Count AsOf",

  • *Removed "Employee EEO White Flag AsOf",

  • *Removed "Employee EEO White Count AsOf",

  • *Removed "Employee EEO Not Specified Flag AsOf",

  • *Removed "Employee EEO Not Specified Count AsOf",

  • *Removed "Employee EEO Race Code AsOf",

  • *Removed "Employee EEO Race AsOf",

  • *Removed "Employee Gender Code AsOf",

  • *Removed "Employee Military Status Code AsOf",

  • *Removed "Employee Military Discharge Date AsOf",

  • *Removed "Vietnam Veteran Flag AsOf",

  • *Removed "Vietnam Veteran Count AsOf"

EAHMAINT-854
EAH-IdentityDemographics-View
  • Added new field "Identity PPS ID Short"
  • Added new field "Identity Bar Code"
EAHMAINT-716
EAH-Workforce-View
  • Added "Employee EEO AmIndian Flag Current",
  • Added "Employee EEO AmIndian Count Current",

  • Added "Employee EEO Asian Flag Current",

  • Added "Employee EEO Asian Count Current",

  • Added "Employee EEO Black Flag Current",

  • Added "Employee EEO Black Count Current",

  • Added "Employee EEO Hawaiian Flag Current",

  • Added "Employee EEO Hawaiian Count Current",

  • Added "Employee EEO Hispanic Flag Current",

  • Added "Employee EEO Hispanic Count Current",

  • Added "Employee EEO White Flag Current",

  • Added "Employee EEO White Count Current",

  • Added "Employee EEO Not Specified Flag Current",

  • Added "Employee EEO Not Specified Count Current",

  • Added "Employee EEO Federal Race Code Current",

  • Added "Employee EEO Federal Race Current",

  • Added "Employee EEO Race Code Current",

  • Added "Employee EEO Race Current",

  • Added "Vietnam Veteran Flag Current",

  • Added "Vietnam Veteran Count Current",

  • Added "Employee Military Status Code Current" ,

  • Added "Employee Military Discharge Date Current"

  • Added "Identity Student PID"
  • Added "Identity Instructor PID"
EAHMAINT-854
EAH-PositionFunding-View
  • Added "Employee EEO AmIndian Flag Current",
  • Added "Employee EEO AmIndian Count Current",

  • Added "Employee EEO Asian Flag Current",

  • Added "Employee EEO Asian Count Current",

  • Added "Employee EEO Black Flag Current",

  • Added "Employee EEO Black Count Current",

  • Added "Employee EEO Hawaiian Flag Current",

  • Added "Employee EEO Hawaiian Count Current",

  • Added "Employee EEO Hispanic Flag Current",

  • Added "Employee EEO Hispanic Count Current",

  • Added "Employee EEO White Flag Current",

  • Added "Employee EEO White Count Current",

  • Added "Employee EEO Not Specified Flag Current",

  • Added "Employee EEO Not Specified Count Current",

  • Added "Employee EEO Federal Race Code Current",

  • Added "Employee EEO Federal Race Current",

  • Added "Employee EEO Race Code Current",

  • Added "Employee EEO Race Current",

  • Added "Vietnam Veteran Flag Current",

  • Added "Vietnam Veteran Count Current",

  • Added "Employee Military Status Code Current" ,

  • Added "Employee Military Discharge Date Current"

EAHMAINT-854
EAH-EmployeeDemographics-View
  • Added "Employee EEO AmIndian Flag Current",
  • Added "Employee EEO AmIndian Count Current",

  • Added "Employee EEO Asian Flag Current",

  • Added "Employee EEO Asian Count Current",

  • Added "Employee EEO Black Flag Current",

  • Added "Employee EEO Black Count Current",

  • Added "Employee EEO Hawaiian Flag Current",

  • Added "Employee EEO Hawaiian Count Current",

  • Added "Employee EEO Hispanic Flag Current",

  • Added "Employee EEO Hispanic Count Current",

  • Added "Employee EEO White Flag Current",

  • Added "Employee EEO White Count Current",

  • Added "Employee EEO Not Specified Flag Current",

  • Added "Employee EEO Not Specified Count Current",

  • Added "Employee EEO Federal Race Code Current",

  • Added "Employee EEO Federal Race Current",

  • Added "Employee EEO Race Code Current",

  • Added "Employee EEO Race Current",

  • Added "Vietnam Veteran Flag Current",

  • Added "Vietnam Veteran Count Current",

  • Added "Employee Military Status Code Current" ,

  • Added "Employee Military Discharge Date Current"

  • Added "Identity Student PID"
  • Added "Identity Instructor PID"
EAHMAINT-854