202410 EAH Release Notes

Owned by Saparnell
Last updated: Oct 11, 2024

Hello EAH Developers - The below enhancements are included in this month's EAH Release.

Keep up with our future enhancements here: EAH Bugs and Enhancements In Progress

Learn more about the Employee Activity Hub in the EAH Quick Start Guides.

Table of Contents


Schedule

  • Thursday, October 10: release enhancements to User Acceptance Testing

  • Thursday, October 17 end of day: release enhancement to Production

  • Friday, October 18, end of day: delete QA models


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Rehan Ahmed
  • Kacy Cashatt
  • Jonathan Matsen
  • John Porter
  • Shawn Pappelbaum
  • Daniel Redfern
  • Heather Sears


New View

EAH-HRLocation-View

BIA and the UC Path Reporting team are excited to release the EAH-HRLocation-View.   This view contains all of the possible active locations in UC Path. 

This view will be part of the EAH Core views but have no row level security.  This view will be going to Production in October 2024.

Epic:   EAHE-3281 - Getting issue details... STATUS

SNOW tickets addressed: CS2120862

Fields include:

  • HR Location
  • HR Location Address Line 1
  • HR Location Address Line 2
  • HR Location Address Line 3
  • HR Location Building Code
  • HR Location City
  • HR Location Code
  • HR Location Country
  • HR Location Country Code
  • HR Location County
  • HR Location Effective Date
  • HR Location End Effective Date
  • HR Location Floor Code
  • HR Location Postal Code
  • HR Location Set Code
  • HR Location State
  • HR Location State Code


View Your Requested Enhancements

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

EAH-ApprovalDirectRetroDetail-View & EAH-ApprovalSalaryCostTransferDetail-View

Epic:  EAHE-3320 - Getting issue details... STATUS , EAHE-3318 - Getting issue details... STATUS

SNOW ticket(s) addressed: CS2149909

Added the following new fields:

  • LL Salary Posted to Financials Count
  • LL Salary Posted to Financials Flag = When "LL Salary Cost Transfer Code" has at least one line in EAH-LLSalaryDetail-View with a "LL Salary In Process Code" = 'M' (Posted with Modifications), then Y for rows with the same "LL Salary Cost Transfer Code", else N for rows with the same "LL Salary Cost Transfer Code".


EAH-GradTuitionEligibility-View

Epic:  EAHE-3283 - Getting issue details... STATUS

SNOW ticket(s) addressed:  CS2088169, CS2184930

Added the following new fields:

  • Graduate Advanced to Candidacy in a Masters Program Count
  • Graduate Advanced to Candidacy in a Masters Program Flag
  • Graduate Advanced to PHD Candidacy Non-Resident Waiver Count
  • Graduate Advanced to PHD Candidacy Non-Resident Waiver Count Current
  • Graduate Advanced to PHD Candidacy Non-Resident Waiver Flag
  • Graduate Advanced to PHD Candidacy Non-Resident Waiver Flag Current
  • Medical Primary Major Department
  • Medical Primary Major Department Code
  • Medical Primary Major Department Code Current
  • Medical Primary Major Department Current
  • Pharmacy Primary Major Department
  • Pharmacy Primary Major Department Code
  • Pharmacy Primary Major Department Code Current
  • Pharmacy Primary Major Department Current
  • Student Residency Status
  • Student Residency Status Code
  • Student Residency Status Code Current
  • Student Residency Status Current
  • Student Residency Status End Term Code
  • Student Residency Status Start Term Code
  • UG Primary Major Department
  • UG Primary Major Department Code
  • UG Primary Major Department Code Current
  • UG Primary Major Department Current


EAH-GradWorkPeriodDetail-View

Epic:  EAHE-3283 - Getting issue details... STATUS

SNOW ticket(s) addressed:  CS2088169, CS2184930

Added the following new fields:

  • Graduate Advanced to Candidacy in a Masters Program Count
  • Graduate Advanced to Candidacy in a Masters Program Flag
  • Medical Primary Major Department
  • Medical Primary Major Department Code
  • Medical Primary Major Department Code Current
  • Medical Primary Major Department Current
  • Pharmacy Primary Major Department
  • Pharmacy Primary Major Department Code
  • Pharmacy Primary Major Department Code Current
  • Pharmacy Primary Major Department Current
  • Student Residency Status Code Current
  • Student Residency Status Current
  • UG Primary Major Department
  • UG Primary Major Department Code
  • UG Primary Major Department Code Current
  • UG Primary Major Department Current


EAH-LLFringeDetail-View, EAH-LLSalaryDetail-View and EAH-LLSalaryFringeDetail-View

Epic:  EAHE-3326 - Getting issue details... STATUS

SNOW ticket(s) addressed:  CS2114043, CS2199451

Added the following new fields:

  • Most Recent Reports To Department Code
  • Most Recent Reports To Employee ID
  • Most Recent Reports To Employee Record
  • Most Recent Reports To Employee Status Code
  • Most Recent Reports To Identity Active Directory ID Current
  • Most Recent Reports To Job Code
  • Most Recent Reports To Organizational Relationship
  • Most Recent Reports To Position
  • Most Recent Reports To Position Number
  • Most Recent Reports To Work Email Address
  • Most Recent Reports To Employee
  • Project Nickname


EAH-PositionBudgetComparisonSummary-View

Epic:  EAHE-3316 - Getting issue details... STATUS

SNOW ticket(s) addressed:  CS2161857

Added the following new fields:

CBO is requesting a logic update for EPBCS Budget Data loaded to HANA for EAH.  Records exist within the EPBCS load file without a Position Budget Type assigned when certain conditions are met (details below). We need all records to have a Position Budget Type of Recurring or One-Time in the PositionBudgetComparisonSummary-View.


CASE 1: [Position Budget Type] = ‘#missing’ for [Employee] = ‘PooledEmp’ when: [Period] = ‘Jul-Jun’ [Scenario] = ‘Base_Bugt’ or ‘BudgetRequest’


UAT - Customer Service Reminder

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly.  For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT.  If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

Follow our Enhancement User Acceptance Testing (UAT) Steps

Use this UAT time to adjust your reports as needed prior to the Production release where your customers will be able to see any issues these enhancements cause. 
  • Cognos: Use the packages in Cognos DEV > Student Activity Hub > Student Activity Hub Packages UAT to build your report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements with Production data. 
  • Tableau: Sign into Tableau 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.  Using this data source will allow you to see the below enhancements with Production data.
  • Hana QA:  SAH data in Hana QA is production data loaded daily, just like in Hana PROD.

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?  Or Tableau?
  • What data source / package are you using?
  • What results were you expecting? 

Reminder: QA data sources will be deleted the Friday after the enhancements are migrated to Production.