202408 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

  • Friday, August 8: release enhancements to User Acceptance Testing

  • Thursday, August 15 end of day: release enhancement to Production

  • Friday, August 16, end of day: delete QA models


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Kacy Cashatt
  • Kevin Chou
  • Todd Everett
  • David Mandell
  • Maria Obtera
  • Tiffany Swiderski


New Views

EAH-GradWorkPeriodDetail-View

BIA and the Grad Division is excited to release the EAH-GradWorkPeriodDetail-View.   This view is a subset of data from the EAH-Workforce-View that is focused on employees with Graduate and Grad Academic Titles - which could include undergrads. 

This view will be part of the EAH Core views and include row level security.  This view will be going to Production in August 2024.

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

SNOW tickets addressed: CS1902856

Fields include:

  • Calendar Quarter (Q)
  • Calendar Type
  • Calendar Type Code
  • Calendar Year (YYYY)
  • Employee ID
  • Employee Name Current
  • Employee PPS ID Current
  • Employee Record
  • Employee Work Days Per Period
  • Employee Work Days Per Period Prorated
  • Identity Student PID Current
  • Job Code
  • Job Code Description
  • Job Code Tuition Eligible Count
  • Job Code Tuition Eligible Flag
  • Job FTE
  • Term
  • Term Code
  • Union
  • Union Code
  • Work Days Per Period
  • Work Days Per Period Prorated
  • Work Period End Date
  • Work Period Job End Date
  • Work Period Job Start Date
  • Work Period Start Date

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 a month.

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

SNOW tickets addressed:  CS1174422

Unique fields include: 

  • Approval Comments
  • 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 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


View Your Requested Enhancements

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

Employee Name Last Updated Date, Employee Pronoun

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

SNOW ticket(s) addressed:  CS2069705CS2114866

Added the following new fields:

  • Employee Name Last Updated Date = This will return the most recent date when any part of the Employee Name has changed (first, middle, last, lived or legal).  Will also return a date in cases where there is no prior value( i.e. name is first established).
  • Employee Pronouns Current = The current self-reported employee pronoun value in UCPath.
  • Employee Pronouns Code Current = The code for the current self-reported employee pronoun value in UCPath.
  • Employee Pronouns Last Updated Date = This will return the most recent date when the Employee Pronoun has changed.  A prior value MUST exist.  Does not display future dates.

Views updated with these new fields:

  • EAH-EmployeeDemographics-View
  • EAH-WorkforceAllRows-View
  • EAH-Workforce-View

EAH-PositionBudgetDistribution-View

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

SNOW ticket(s) addressed:  CS2068335

Added the following new fields:

  • LL Employee CBR Rate
  • LL Employee CBR Rate Code
  • LL Employee CBR Rate Group
  • Position Budget Distribution Line CCOA TASK
  • Position Budget Distribution Line CCOA TASK Code
  • Position Budget Distribution Position Effective Status
  • Position Budget Distribution Position Effective Status Code


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.