Versions Compared

Old Version 1

changes.mady.by.user Saparnell

Saved on

compared with

New Version Current

changes.mady.by.user Saparnell

Saved on

Key

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

Hello EAH Developers - The below fields are now available for you in UAT.  If you find an issue, please email busintel@ucsd.edu right away with the subject line “EAH UAT due September 15” so we can address it prior to the Thursday, September 16 release to Production. 

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


Table of Contents

Table of Contents


View Your Requested Enhancements

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


Ui expand
titleEAH-AdditionalPayDetail-View

EAH-AdditionalPayDetail-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1850

Added the following fields:

  • Additional Pay Add To Gross Pay Count
  • Additional Pay Add To Gross Pay Flag
  • Additional Pay Derived Active Count Current
  • Additional Pay Derived Active Flag Current



Ui expand
titleEAH-EmployeeDemographics-View

EAH-EmployeeDemographics-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1760

Added the following fields:

  • Identity Affiliate Bar Code Current
  • Identity Affiliate ID Card Issue Number Current
  • Identity Affiliate ID Card Number Current
  • Identity Faculty Bar Code Current
  • Identity Faculty ID Card Issue Number Current
  • Identity Faculty ID Card Number Current
  • Identity Staff Bar Code Current
  • Identity Staff ID Card Issue Number Current
  • Identity Staff ID Card Number Current
  • Identity Student Bar Code Current
  • Identity Student ID Card Issue Number Current
  • Identity Student ID Card Number Current
  • Statement of Economic Interests Count Current
  • Statement of Economic Interests Date Current
  • Statement of Economic Interests Flag Current



Ui expand
titleEAH-LLFringeDetail-View

EAH-LLFringeDetail-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1814

Added the following field:

  • LL Fringe Original Transaction Reference
  • Managerial Reporting Account Hierarchy L1
  • Managerial Reporting Account Hierarchy L1 Code
  • Managerial Reporting Account Hierarchy L1 Code and Name
  • Managerial Reporting Account Hierarchy L2
  • Managerial Reporting Account Hierarchy L2 Code
  • Managerial Reporting Account Hierarchy L2 Code and Name
  • Managerial Reporting Account Hierarchy L3
  • Managerial Reporting Account Hierarchy L3 Code
  • Managerial Reporting Account Hierarchy L3 Code and Name
  • Managerial Reporting Account Hierarchy L4
  • Managerial Reporting Account Hierarchy L4 Code
  • Managerial Reporting Account Hierarchy L4 Code and Name
  • Managerial Reporting Account Hierarchy L5
  • Managerial Reporting Account Hierarchy L5 Code
  • Managerial Reporting Account Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L1
  • Managerial Reporting Fund Hierarchy L1 Code
  • Managerial Reporting Fund Hierarchy L1 Code and Name
  • Managerial Reporting Fund Hierarchy L2
  • Managerial Reporting Fund Hierarchy L2 Code
  • Managerial Reporting Fund Hierarchy L2 Code and Name
  • Managerial Reporting Fund Hierarchy L3
  • Managerial Reporting Fund Hierarchy L3 Code
  • Managerial Reporting Fund Hierarchy L3 Code and Name
  • Managerial Reporting Fund Hierarchy L4
  • Managerial Reporting Fund Hierarchy L4 Code
  • Managerial Reporting Fund Hierarchy L4 Code and Name
  • Managerial Reporting Fund Hierarchy L5
  • Managerial Reporting Fund Hierarchy L5 Code
  • Managerial Reporting Fund Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L6
  • Managerial Reporting Fund Hierarchy L6 Code
  • Managerial Reporting Fund Hierarchy L6 Code and Name



Ui expand
titleEAH-LLSalaryDetail-View

EAH-LLSalaryDetail-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1816

Added the following field:

  • LL Salary Original Transaction Reference
  • Managerial Reporting Account Hierarchy L1
  • Managerial Reporting Account Hierarchy L1 Code
  • Managerial Reporting Account Hierarchy L1 Code and Name
  • Managerial Reporting Account Hierarchy L2
  • Managerial Reporting Account Hierarchy L2 Code
  • Managerial Reporting Account Hierarchy L2 Code and Name
  • Managerial Reporting Account Hierarchy L3
  • Managerial Reporting Account Hierarchy L3 Code
  • Managerial Reporting Account Hierarchy L3 Code and Name
  • Managerial Reporting Account Hierarchy L4
  • Managerial Reporting Account Hierarchy L4 Code
  • Managerial Reporting Account Hierarchy L4 Code and Name
  • Managerial Reporting Account Hierarchy L5
  • Managerial Reporting Account Hierarchy L5 Code
  • Managerial Reporting Account Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L1
  • Managerial Reporting Fund Hierarchy L1 Code
  • Managerial Reporting Fund Hierarchy L1 Code and Name
  • Managerial Reporting Fund Hierarchy L2
  • Managerial Reporting Fund Hierarchy L2 Code
  • Managerial Reporting Fund Hierarchy L2 Code and Name
  • Managerial Reporting Fund Hierarchy L3
  • Managerial Reporting Fund Hierarchy L3 Code
  • Managerial Reporting Fund Hierarchy L3 Code and Name
  • Managerial Reporting Fund Hierarchy L4
  • Managerial Reporting Fund Hierarchy L4 Code
  • Managerial Reporting Fund Hierarchy L4 Code and Name
  • Managerial Reporting Fund Hierarchy L5
  • Managerial Reporting Fund Hierarchy L5 Code
  • Managerial Reporting Fund Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L6
  • Managerial Reporting Fund Hierarchy L6 Code
  • Managerial Reporting Fund Hierarchy L6 Code and Name



Ui expand
titleEAH-LLSalaryFringeDetail-View

EAH-LLSalaryFringeDetail-View

Epic: EAHMAINT-1724

Added the following field:

Last Enrolled Term

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1818

Added the following field:

  • LL Original Transaction Reference
  • LL Salary Payment Type
  • LL Salary Payment Type Code
  • Managerial Reporting Account Hierarchy L1
  • Managerial Reporting Account Hierarchy L1 Code
  • Managerial Reporting Account Hierarchy L1 Code and Name
  • Managerial Reporting Account Hierarchy L2
  • Managerial Reporting Account Hierarchy L2 Code
  • Managerial Reporting Account Hierarchy L2 Code and Name
  • Managerial Reporting Account Hierarchy L3
  • Managerial Reporting Account Hierarchy L3 Code
  • Managerial Reporting Account Hierarchy L3 Code and Name
  • Managerial Reporting Account Hierarchy L4
  • Managerial Reporting Account Hierarchy L4 Code
  • Managerial Reporting Account Hierarchy L4 Code and Name
  • Managerial Reporting Account Hierarchy L5
  • Managerial Reporting Account Hierarchy L5 Code
  • Managerial Reporting Account Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L1
  • Managerial Reporting Fund Hierarchy L1 Code
  • Managerial Reporting Fund Hierarchy L1 Code and Name
  • Managerial Reporting Fund Hierarchy L2
  • Managerial Reporting Fund Hierarchy L2 Code
  • Managerial Reporting Fund Hierarchy L2 Code and Name
  • Managerial Reporting Fund Hierarchy L3
  • Managerial Reporting Fund Hierarchy L3 Code
  • Managerial Reporting Fund Hierarchy L3 Code and Name
  • Managerial Reporting Fund Hierarchy L4
  • Managerial Reporting Fund Hierarchy L4 Code
  • Managerial Reporting Fund Hierarchy L4 Code and Name
  • Managerial Reporting Fund Hierarchy L5
  • Managerial Reporting Fund Hierarchy L5 Code
  • Managerial Reporting Fund Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L6
  • Managerial Reporting Fund Hierarchy L6 Code
  • Managerial Reporting Fund Hierarchy L6 Code and Name



Ui expand
titleEAH-PositionFunding-View

EAH-PositionFunding-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-1478

Added the following field:

  • Additional Pay Add To Gross Pay Count
  • Additional Pay Add To Gross Pay Flag ='No' indicates non-monetary compensation
  • Additional Pay Current Goal Balance
  • Additional Pay Derived Active Count Current
  • Additional Pay Derived Active Flag Current
  • Additional Pay Earnings End Date
  • Additional Pay Earnings Type
  • Additional Pay Earnings Type Code
  • Additional Pay Goal Amount
  • Additional Pay Other Pay
  • Additional Pay Period First Count
  • Additional Pay Period First Flag
  • Additional Pay Period Second Count
  • Additional Pay Period Second Flag
  • Additional Pay Period Third Count
  • Additional Pay Period Third Flag
  • Additional Pay Reason
  • Additional Pay Reason Code
  • Additional Pay Sequence Number
  • Additional Pay Start Date
  • Award EVerify Count
  • Award EVerify Flag
  • Derived Monthly Rate = Includes monthly and monthly for biweekly pay
  • Managerial Reporting Fund Hierarchy L1
  • Managerial Reporting Fund Hierarchy L1 Code
  • Managerial Reporting Fund Hierarchy L1 Code and Name
  • Managerial Reporting Fund Hierarchy L2
  • Managerial Reporting Fund Hierarchy L2 Code
  • Managerial Reporting Fund Hierarchy L2 Code and Name
  • Managerial Reporting Fund Hierarchy L3
  • Managerial Reporting Fund Hierarchy L3 Code
  • Managerial Reporting Fund Hierarchy L3 Code and Name
  • Managerial Reporting Fund Hierarchy L4
  • Managerial Reporting Fund Hierarchy L4 Code
  • Managerial Reporting Fund Hierarchy L4 Code and Name
  • Managerial Reporting Fund Hierarchy L5
  • Managerial Reporting Fund Hierarchy L5 Code
  • Managerial Reporting Fund Hierarchy L5 Code and Name
  • Managerial Reporting Fund Hierarchy L6
  • Managerial Reporting Fund Hierarchy L6 Code
  • Managerial Reporting Fund Hierarchy L6 Code and Name
  • Position Funding Derived Base Salary Count
  • Position Funding Derived Base Salary Flag
  • Row Source = Position Funding or Additional Pay
  • Row Source Code



Ui expand
titleEAH-Workforce-View and EAH-WorkforceRestricted-View

EAH-Workforce-View and EAH-WorkforceRestricted-View

Epic:

Jira Legacy
serverITS PRO
serverIdebe8394f-6d75-344c-8d9c-717cb778a1eb
keyEAHMAINT-
1709
1762

Added the following field:

  • Graduate Primary Degree Group AsOf
  • Graduate Primary Degree Group Current
  • Graduate Primary Major Code AsOf
  • Graduate Primary Major Code Current
  • Graduate Primary Major Department AsOf
  • Graduate Primary Major Department Code AsOf
  • Graduate Primary Major Department Code Current
  • Graduate Primary Major Department Current
  • Last Enrolled Term Code
  • Last Enrolled Term Code AsOf
  • Person Profile Graduate Student AsOf Count
  • Person Profile Graduate Student AsOf Flag
  • Person Profile Graduate Student Current Count
  • Person Profile Graduate Student Current Flag
  • Person Profile Graduate Student End Date AsOf
  • Person Profile Graduate Student End Date Current
  • Person Profile Graduate Student Enrolled Units AsOf
  • Person Profile Graduate Student Enrolled Units Current
  • Person Profile Graduate Student Start Date AsOf
  • Person Profile Graduate Student Start Date Current
  • Person Profile UG Student AsOf Count
  • Person Profile UG Student AsOf Flag
  • Person Profile UG Student Current Count
  • Person Profile UG Student Current Flag
  • Person Profile UG Student End Date AsOf
  • Person Profile UG Student End Date Current
  • Person Profile UG Student Enrolled Units AsOf
  • Person Profile UG Student Enrolled Units Current
  • Person Profile UG Student Start Date AsOf
    • Person Profile UG Student Start Date

    • Department L2
    • Department L2 Code
    • Department L2 Code And Name
    • Department L3
    • Department L3 Code
    • Department L3 Code And Name
    • Department L4
    • Department L4 Code
    • Department L4 Code And Name
    • Department L5
    • Department L5 Code
    • Department L5 Code And Name
    • Department Level
    • Employee UC Original Start Date
    • Identity Affiliate Bar Code Current
    • Identity Affiliate ID Card Issue Number Current
    • Identity Affiliate ID Card Number Current
    • Identity Faculty Bar Code Current
    • Identity Faculty ID Card Issue Number Current
    • Identity Faculty ID Card Number Current
    • Identity Staff Bar Code Current
    • Identity Staff ID Card Issue Number Current
    • Identity Staff ID Card Number Current
    • Identity Student Bar Code Current
    • Identity Student ID Card Issue Number Current
    • Identity Student ID Card Number Current
    • Statement of Economic Interests Count AsOf
    • Statement of Economic Interests Count Current
    • Statement of Economic Interests Date AsOf
    • Statement of Economic Interests Date Current
    • Statement of Economic Interests Flag AsOf
    • Statement of Economic Interests Flag Current



    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 Testing Steps

    Tip
    Please use this UAT time to adjust your reports as needed prior to the Production release when your customers will be able to see any issues these enhancements cause. 
    • In Cognos DEV open your report and replace the current package with the package of the same name from the Team Content > Employee Activity Hub > EAH Analytics Packages UAT folder.  Run the report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using the new package from the EAH Analytics Packages UAT folder will allow you to see the below enhancement.  EAH data is the same in Hana Prod and Hana QA.
    • Sign into Tableau Prod 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.  Replace the original data source with the –QA data source.  Using the –QA data source will allow you to see the below enhancements.  EAH data is the same in Hana Prod and Hana QA. 

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