Versions Compared

Key

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

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

Table of Contents


Schedule

  • Friday, July 5: release enhancements to User Acceptance Testing

  • Thursday, July 11 end of day: release enhancement to Production

  • Friday, July 12, end of day: delete QA models


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests. 

  • Kacy Cashatt
  • David Mandell
  • Raul Navarro Rodriguez
  • Tiffany Swiderski
  • Eva Thiveos


New Views

EAH-GradWorkPeriodDetail-View - UAT will continue through August

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: 

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHE-3174

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-LLOriginalCombo-View - New Plan: Instead of creating a new view, the data in this view will be blending into the existing Labor Ledger views.

In conjunction with the UCPath Reporting Team, BIA is excited to release the EAH-LLOriginalCombo-View.   This new view will allow the Payroll team to research cases where employee labor accounting is not what was expected.

This view will be part of the EAH Core views and does not use row level security.  This view will NOT be going to Production.

Epic:  

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHE-3146

SNOW tickets addressed: CS1924743

Unique fields include: 

  • LL CCOA
  • LL CCOA Activity Code
  • LL CCOA Budget Reference OTC Indicator Code
  • LL CCOA Entity Code
  • LL CCOA FinU Code
  • LL CCOA FND SRC Code
  • LL CCOA Funct Code
  • LL CCOA Fund Code
  • LL CCOA Location Code
  • LL CCOA Program Code
  • LL CCOA Project Code
  • LL CCOA TASK Code
  • LL CCOA Work Study Indicator Code
  • LL GLVal Edit Error Message
  • LL GLVal Edit Error Type Code
  • LL GLVal Primary Key Hash Code
  • LL Original Budget Reference OTC Indicator Code
  • LL Original Business Unit Code
  • LL Original CCOA
  • LL Original CCOA Activity
  • LL Original CCOA Activity Code
  • LL Original CCOA Entity
  • LL Original CCOA Entity Code
  • LL Original CCOA FinU
  • LL Original CCOA FinU Code
  • LL Original CCOA FND SRC
  • LL Original CCOA FND SRC Code
  • LL Original CCOA Funct
  • LL Original CCOA Funct Code
  • LL Original CCOA Fund
  • LL Original CCOA Fund Code
  • LL Original CCOA Location
  • LL Original CCOA Location Code
  • LL Original CCOA Program
  • LL Original CCOA Program Code
  • LL Original CCOA Project
  • LL Original CCOA Project Code
  • LL Original CCOA TASK
  • LL Original CCOA TASK Code
  • LL Original Department
  • LL Original Department Code
  • LL Original Earnings End Date
  • LL Original Pay Run Code
  • LL Original Work Study Indicator Code



    View Your Requested Enhancements

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

    EAH-LLSalaryDetail-View

    Epic:  

    Jira Legacy
    serverITS PRO
    serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
    keyEAHE-3211

    SNOW ticket(s) addressed:  CS1924743

    Added the following new fields:

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

    EAH-LLFringeDetail-View, EAH-LLSalaryDetail-View & EAH-LLSalaryFringeDetail-View

    Epic:  

    Jira Legacy
    serverITS PRO
    serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
    keyEAHE-3178

    SNOW ticket(s) addressed:  CS1988976

    Added the following new fields:

    • Last Closed Accounting Period Flag

    • Last Closed Accounting Period Count

    • Last Opened Accounting Period Flag

    • Last Opened Accounting Period Count


    EAH-LLSalaryFringeDetail-View

    Epic:  

    Jira Legacy
    serverITS PRO
    serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
    keyEAHE-3209

    SNOW ticket(s) addressed:  CS1924743

    Added the following new fields:

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

    EAH-PersonTraining-View

    Epic:  

    Jira Legacy
    serverITS PRO
    serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
    keyEAHE-3207

    SNOW ticket(s) addressed:  CS2000190 

    Updated the following logic:  Name of the Training

    • Original logic = Training Activity will show the original name of the training.
    • New logic = Training Activity will show the updated name of the training.

    EAH-Workforce-View & EAH-WorkforceAllRows-View

    Epic:  

    Jira Legacy
    serverITS PRO
    serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
    keyEAHE-3213

    SNOW ticket(s) addressed:

    Added the following new fields:

    • Union Code End Date

    • Union Code Start Date



    UAT - Customer Service Reminder

    Warning

    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

    Tip
    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.