20200713 - EAH Start UAT Release Notes

Hello EAH Developers - We are excited to release a number of enhancements for you to test between now and end of day July 19.  We plan to push these enhancement to production with the EAH security changes so please be sure to test both the security and these enhancement.  Double check any report saved to your My Content (Cognos) area or your desktop (Tableau).  If you find an issue, please email busintel@ucsd.edu right away so we can address it prior to July 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 and the new security structure.  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 enhancement and the new security structure.  EAH data is the same in Hana prod and Hana QA.

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?  What departments were you approved for via the new EAH row level security?

Jira filter to see all expected releases:  project in ("Employee Activity Hub Maintenance (EAHMAINT)") AND status not in (Done, Closed, Cancelled, Inactive) AND type = Epic and labels = EAH-Jul20

Enhancements for your testing:

ViewCognos & TableauEpic
EAH-AbsenceDetail-View
  • Implementation of row level security
  • Removed extraneous fields

EAHMAINT-266, EAHMAINT-591

EAH-AccrualHours-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-AddlPayDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitBillingEnrollment-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitDisabilityDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitFSADetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitHealthDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitLifeDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitRetireDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitSavingsDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-BenefitSavingsExtension
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-Benefits-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-CertificationActivities-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-Compensation-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-Contract-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-DeductionBalance-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-Degree-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-DepartmentHierarchy-View
  • Created and ready for release
EAHMAINT-586
EAH-EarningsBalance-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-EmergencyContact-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-EmployeeDemographics-View
  • Implementation of row level security
  • Add new field: Identity Active Directory ID Current
EAHMAINT-266, EAHMAINT-651
EAH-ExtendedAbsence-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-GeneralDeductionDetail-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-JobEarnsDist-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-License-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-LLActualDetail-Vew
  • Implementation of row level security
EAHMAINT-266
EAH-LLDeductionDetail-View
  • Implementation of row level security
EAHMAINT-266
EAH-LLFringeDetail-View
  • Implementation of row level security
EAHMAINT-266
EAH-LLSalaryDetail-View
  • Implementation of row level security
  • Add new field: LL Employee PPS ID Current
  • Add new field: LL Salary Earnings Period Start Date
  • Add new field: LL Salary Earnings Period End Date
EAHMAINT-266, EAHMAINT-687
EAH-Payroll-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266
EAH-PositionFunding-View
  • Add new field: LL Employee CBR Rate Group
  • Add new field:  LL Employee CBR Rate
  • Add new field:  Position Fund Cap Type Code
  • Add new field:  Position Fund Cap Rate
  • Add new field: Manager Flag
  • Add new field: Manager Count
  • Add new field: Report To Work Email Address
  • Add new field: Identity Active Directory ID Current
  • Implementation of row level security
  • Removed extraneous fields

EAHMAINT-405, EAHMAINT-266

EAHMAINT-591, EAHMAINT-651

EAH-Tax1042Balance-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-TaxBalance-View
  • Implementation of row level security
  • Removed extraneous fields
EAHMAINT-266, EAHMAINT-591
EAH-UCRole-View
  • Add new field: User Authorized Department
  • Add new field: User Authorized Department Code
  • Add new field: User Primary Job Department
  • Add new field: User Primary Job Department Code
EAHMAINT-605
EAH-Workforce-View
  • Implementation of row level security
  • Add new field: Manager Flag
  • Add new field: Manager Count
  • Add new field: Report To Work Email Address
  • Add new field: Identity Active Directory ID Current
EAHMAINT-266, EAHMAINT-651