202309 EAH Release Notes

Hello EAH Developers - The below fields are now available for you in Hana Production.

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


Table of Contents

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


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Joseph File
  • David Mandell
  • Jordyn Ohashi


New View: EAH-ApprovalFundingEntryDetail-View

BIA and the UC Path Reporting team are excited to introduce the EAH-ApprovalFundingEntryDetail-View.  This new view is a combination of elements from EAH-Workforce-View and Approval Funding.

Per our standard process, this view will remain in UAT for a full month and go to Production in September.  Please email busintel@ucsd.edu if you have any feedback on this new view.

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

SNOW ticket addressed: CS1532995

Does not include row-level security.

Pre-joined with most EAH-Workforce fields.  Unique fields in this view include:

  • Funding Entry Budget Amount
  • Funding Entry Budget Sequence Number
  • Funding Entry CCOA Activity
  • Funding Entry CCOA Activity Code
  • Funding Entry CCOA Entity
  • Funding Entry CCOA Entity Code
  • Funding Entry CCOA FinU
  • Funding Entry CCOA FinU Code
  • Funding Entry CCOA FND SRC
  • Funding Entry CCOA FND SRC Code
  • Funding Entry CCOA Funct
  • Funding Entry CCOA Funct Code
  • Funding Entry CCOA Fund
  • Funding Entry CCOA Fund Code
  • Funding Entry CCOA Location
  • Funding Entry CCOA Location Code
  • Funding Entry CCOA Program
  • Funding Entry CCOA Program Code
  • Funding Entry CCOA Project
  • Funding Entry CCOA Project Code
  • Funding Entry CCOA TASK
  • Funding Entry CCOA TASK Code
  • Funding Entry Combination Code
  • Funding Entry Department Code
  • Funding Entry Distribution Percent
  • Funding Entry Earnings Sequence Number
  • Funding Entry Earnings Type
  • Funding Entry Earnings Type Code
  • Funding Entry Effective Date
  • Funding Entry Effective Sequence Number
  • Funding Entry End Date
  • Funding Entry Fiscal Year
  • Funding Entry OTC Indicator Code
  • Funding Entry Position Number
  • Funding Entry Request Status
  • Funding Entry Request Status Code
  • Funding Entry SetID
  • Funding Entry Submitted Date

New View: EAH-PayrollEarningsTransactionDetail-View

Looking for more detail related to Payroll Earnings?  BIA and the UC Path Reporting team are excited to introduce the EAH-PayrollEarningsTransactionDeatil-View.  This new view builds on the EAH-PayrollEarningsDetail-View by adding more transactional details.

Per our standard process, this view will remain in UAT for a full month and go to Production in October.  Please email busintel@ucsd.edu if you have any feedback on this new view.

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

SNOW ticket(s) addressed: CS1437862

Includes row-level security.

Pre-joined with most EAH-Workforce fields + EAH-PayrollEarningsDetail-View.  Unique fields in this view include:

  • Pay Calendar Check Date
  • Pay Check Additional Earnings Number
  • Pay Check Company Code
  • Pay Check Earnings
  • Pay Check Earnings Add To Gross Pay Count
  • Pay Check Earnings Add To Gross Pay Flag
  • Pay Check Earnings Business Unit
  • Pay Check Earnings Business Unit Code
  • Pay Check Earnings Department
  • Pay Check Earnings Department Code
  • Pay Check Earnings Employee Record
  • Pay Check Earnings Hourly Rate
  • Pay Check Earnings Hours
  • Pay Check Earnings Job Code
  • Pay Check Earnings Job Code Description
  • Pay Check Earnings Paysheet Source
  • Pay Check Earnings Paysheet Source Code
  • Pay Check Earnings Position
  • Pay Check Earnings Position Number
  • Pay Check Earnings Rate Used
  • Pay Check Earnings Rate Used Code
  • Pay Check Earnings Record Source
  • Pay Check Earnings Time Reference Number
  • Pay Check Earnings Time Source
  • Pay Check Earnings Time Source Code
  • Pay Check Separate Check Number



New View: EAH-TimeReported-View

EcoTime has provided some technical challenges for reports, but working with the UC Path Reporting team and our ITS partner team, an adjacent data source has been identified so that we can bring you the EAH-TimeReported-View. 

Per our standard process, this view will remain in UAT for a full month and go to Production in October.  Please email busintel@ucsd.edu if you have any feedback on this new view.

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

SNOW ticket(s) addressed: CS1587329

Includes row-level security.

Pre-joined with many EAH-Workforce-View fields.  Fields unique to this view:

  • Reported Time
  • Reported Time Business Unit
  • Reported Time Business Unit Code
  • Reported Time Code
  • Reported Time Combination Code
  • Reported Time DateTime Created
  • Reported Time DateTime Modified
  • Reported Time Last Updated By User ID
  • Reported Time Last Updated DateTime
  • Reported Time Position
  • Reported Time Position Number
  • Reported Time Quantity
  • Reported Time Sequence Number
  • Reported Time Status
  • Reported Time Status Code
  • Reported Time Work Date


View Your Requested Enhancements

EAH-ApprovalDirectRetroDetail-View

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

SNOW ticket(s) addressed:  CS1618082

Added the following new fields:

  • Direct Retro High Risk By Award End Date Count
  • Direct Retro High Risk By Award End Date Flag
  • Direct Retro High Risk By Federal Fund Increase Count
  • Direct Retro High Risk By Federal Fund Increase Flag
  • Direct Retro High Risk By Federal Fund Maximum Increase Amount = The maximum Federal Fund Amount increase for the Direct Retro. The maximum is needed because there might be more than one Federal Fund which has an increased amount on the Direct Retro. 
  • Direct Retro High Risk By Federal Fund Maximum Increase Code
  • Direct Retro High Risk By UCPath Approval Count
  • Direct Retro High Risk By UCPath Approval Flag = Y' when there are multiple steps in the Direct Retro Approval OR The Direct Retro is Approved 120 Days after Earnings have been earned (Earnings End Date). Null when the Direct Retro has not been routed for approval. 

EAH-WorkforceAllRows-View, EAH-Workforce-View, EAH-WorkforceRestricted-View, EAH-WorkforceRestrictedPerMonthSnapShot-View, EAH-WorkforceRestrictedPerMonth-View

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

SNOW ticket(s) addressed:  CS1580911

Added the following new fields:

  • Position Fund Sponsored Source Count

  • Position Fund Sponsored Source Flag