Versions Compared

Old Version 4

changes.mady.by.user Saparnell

Saved on

compared with

New Version Current

changes.mady.by.user Saparnell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Workforce Basic Testing

In Cognos DEV do not use Hana PROD.  Data is 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 but the table structure is different so reports in Cognos DEV won't work with Hana Prod.

In Tableau QA use the Sign into Tableau QA on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA in at the end of the title.  Data is .  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:

All except
  • EAH-Position-View
  • EAH-JobCodeSalaryPlan-View
  • EAH-LLSummary-View
  • EAH-UCRole-View
    • EAH-DepartmentHierarchy
    ViewCognos TableauEpic& 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-PositionFundingEmployeeDemographics-View
    • Add new field: LL Employee CBR Rate GroupImplementation 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 CBR RatePPS ID Current
    • Add new field:   Position Fund Cap Type CodeLL Salary Earnings Period Start Date
    • Add new field:   Position Fund Cap RateLL 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