202409 EAH Release Notes

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, September 5: release enhancements to User Acceptance Testing

  • Thursday, September 12 end of day: release enhancement to Production

  • Friday, September 13, end of day: delete QA models


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Kacy Cashatt
  • Kevin Chou
  • Shawn Pappelbaum
  • John Porter
  • Daniel Redfern
  • Heather Sears


New Views

EAH-ApprovalPayPathDetail-View 

In conjunction with the UCPath Reporting Team, BIA is excited to release the EAH-ApprovalPayPathDetail-View.   This new view will allow visibility into the pay path approval workflow transactions.

This view will be part of the EAH Core views and uses row level security.  This view will remain in UAT for another month.

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

SNOW tickets addressed:  CS1174422

Unique fields include: 

  • Approval Comments
  • Employee Display Name Current
  • Employee First Name Current
  • Employee Last Name Current
  • Employee Name Current
  • PayPath Academic Duration Appointment
  • PayPath Academic Duration Appointment Code
  • PayPath Business Unit
  • PayPath Business Unit Code
  • PayPath Cubicle
  • PayPath Department
  • PayPath Department Code
  • PayPath Effective Date
  • PayPath Effective Sequence Number
  • PayPath Employee Class
  • PayPath Employee Class Code
  • PayPath Employee ID
  • PayPath Employee Record
  • PayPath Employee Relations
  • PayPath Employee Relations Code
  • PayPath ERIT End Date
  • PayPath FLSA Status
  • PayPath FLSA Status Code
  • PayPath FTE
  • PayPath Job Action
  • PayPath Job Action Code
  • PayPath Job Action Reason
  • PayPath Job Action Reason Code
  • PayPath Job Automatically End Count
  • PayPath Job Automatically End Flag
  • PayPath Job Code
  • PayPath Job Code Description
  • PayPath Job Comments
  • PayPath Job Compensation Frequency
  • PayPath Job Compensation Frequency Code
  • PayPath Job Compensation Rate
  • PayPath Job Earnings Distribution Type
  • PayPath Job Earnings Distribution Type Code
  • PayPath Job Expected End Date
  • PayPath Job FTE
  • PayPath Job Leave Of Absence End Date
  • PayPath Job Standard Hours Frequency Code
  • PayPath Last Updated By User ID
  • PayPath Location
  • PayPath Location Code
  • PayPath Location Use End Date
  • PayPath Location Use Type Code
  • PayPath Mail Drop
  • PayPath Position
  • PayPath Position Action
  • PayPath Position Action Code
  • PayPath Position Action Reason
  • PayPath Position Action Reason Code
  • PayPath Position Class
  • PayPath Position Class Code
  • PayPath Position Number
  • PayPath Position Pool
  • PayPath Position Pool ID
  • PayPath Probation End Date
  • PayPath Probation Status
  • PayPath Probation Status Code
  • PayPath Reports To Position Number
  • PayPath Representation
  • PayPath Representation Code
  • PayPath Request Status
  • PayPath Request Status Code
  • PayPath Salary Grade
  • PayPath Salary Grade Code
  • PayPath Salary PlanPay
  • Path Salary Plan Code
  • PayPath Salary Step Number
  • PayPath Standard Hours
  • PayPath Standard Hours Frequency
  • PayPath Transaction Category
  • PayPath Transaction Category Code
  • PayPath Trial Employment End Date
  • PayPath Union
  • PayPath Union Code
  • PayPath Workflow Status
  • PayPath Workflow Status Code

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-GradTuitionEligibility-View

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

SNOW ticket(s) addressed:  CS2088169CS2117580

Added the following new fields:

Completed Units Term
Graduate Advanced to PHD Candidacy Approved Date
Graduate Primary Major Department
Graduate Primary Major Department Code
Graduate Primary Major Department Code Current
Graduate Primary Major Department Current
Job Code All GSR Fellow Or Trainee Count
Job Code All GSR Fellow Or Trainee Flag
Job Code Placeholder GSR Fellow Or Trainee Count
Job Code Placeholder GSR Fellow Or Trainee Flag
Job Code Stipend GSR Fellow Or Trainee Count
Job Code Stipend GSR Fellow Or Trainee Flag
Job Code Stipend Or Placeholder GSR Fellow Count
Job Code Stipend Or Placeholder GSR Fellow Flag
Job Code Stipend Or Placeholder GSR Trainee Count
Job Code Stipend Or Placeholder GSR Trainee Flag
Job Code Supplement GSR Fellow Or Trainee Count
Job Code Supplement GSR Fellow Or Trainee Flag
Last Enrolled Term Code
Registration Status
Registration Status Code
Registration Status Code Current
Registration Status Current
Student Citizenship Country Code Current
Student Citizenship Country Current
Student Classification
Student Classification Code
Student Level
Student Level Current
Student Residency Status Code Current
Student Residency Status Current
Visa Type Code
Visa Type Code Current


EAH-GradWorkPeriodDetail-View

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

SNOW ticket(s) addressed:  CS2117580

Added the following new fields:

Completed Units Term
Graduate Advanced to PHD Candidacy Approved Date
Graduate Primary Major Department
Graduate Primary Major Department Code
Graduate Primary Major Department Code Current
Graduate Primary Major Department Current
Job Code All GSR Fellow Or Trainee Count
Job Code All GSR Fellow Or Trainee Flag
Job Code Placeholder GSR Fellow Or Trainee Count
Job Code Placeholder GSR Fellow Or Trainee Flag
Job Code Stipend GSR Fellow Or Trainee Count
Job Code Stipend GSR Fellow Or Trainee Flag
Job Code Stipend Or Placeholder GSR Fellow Count
Job Code Stipend Or Placeholder GSR Fellow Flag
Job Code Stipend Or Placeholder GSR Trainee Count
Job Code Stipend Or Placeholder GSR Trainee Flag
Job Code Supplement GSR Fellow Or Trainee Count
Job Code Supplement GSR Fellow Or Trainee Flag
Last Enrolled Term Code
Registration Status
Registration Status Code
Registration Status Code Current
Registration Status Current
Student Citizenship Country Code Current
Student Citizenship Country Current
Student Classification
Student Classification Code
Student Level
Student Level Current
Student Residency Status Code Current
Student Residency Status Current
Visa Type Code
Visa Type Code Current


EAH-EAH-LLFringeDetail-View

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

SNOW ticket(s) addressed:  CS2100971, CS2114043, CS2132625, CS2132208

Added the following new fields:

LL Fringe Original Budget Reference OTC Indicator Code
LL Fringe Original CCOA
LL Fringe Original CCOA Entity
LL Fringe Original CCOA Entity Code
LL Fringe Original CCOA FinU
LL Fringe Original CCOA FinU Code
LL Fringe Original CCOA FND SRC
LL Fringe Original CCOA FND SRC Code
LL Fringe Original CCOA Funct
LL Fringe Original CCOA Funct Code
LL Fringe Original CCOA Fund
LL Fringe Original CCOA Fund Code
LL Fringe Original CCOA Project
LL Fringe Original CCOA Project Code
LL Fringe Original CCOA TASK
LL Fringe Original CCOA TASK Code
LL Fringe Original Department
LL Fringe Original Department Code

LL Job Family Code
LL Job Family
LL Job Function Code
LL Job Function


EAH-LLSalaryDetail-View and EAH-LLSalaryFringeDetail-View

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

SNOW ticket(s) addressed:  CS2132208CS2132625

Added the following new fields:

LL Job Family Code
LL Job Family
LL Job Function Code
LL Job Function


EAH-Position-View

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

SNOW ticket(s) addressed:  CS2120862

Added the following new fields:

Position Location
Position Location Code


EAH-Workforce-View and EAH-WorkforceAllRows-View

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

SNOW ticket(s) addressed:  CS2117656CS2120862

Added the following new fields:

Salary Step Max Pay Rate Annual
Salary Step Max Pay Rate Daily
Salary Step Max Pay Rate Hourly
Salary Step Max Pay Rate Monthly
Salary Step Mid Pay Rate Annual
Salary Step Mid Pay Rate Daily
Salary Step Mid Pay Rate Hourly
Salary Step Mid Pay Rate Monthly
Salary Step Min Pay Rate Annual
Salary Step Min Pay Rate Daily
Salary Step Min Pay Rate Hourly
Salary Step Min Pay Rate Monthly



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.