Versions Compared

Old Version 1

changes.mady.by.user Saparnell

Saved on

compared with

New Version 2

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 May 11” so we can address it prior to the Thursday, May 12, 2022 release to Production.

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


Table of Contents

Table of Contents


Renaming & Deprecating

As we've adapted the EAH views to your needs, we have found changing field names is painful for both report developers and our team due to the name change breaking reports, data integrations and packages / data sources.  In an effort to avoid this pain, we are going to introduce a new name change strategy. 

  1. ITS-BIA will release new fields with the revised field name in the views that contain the field to be renamed, or where a view is to be renamed ITS-BIA will release as a new view the view with the revised name.
  2. ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.
  3. ITS-BIA will remove the data from the old fields / views and allow a second transition period.  This will not break the report but will highlight where the fields / views are still in use as they will become blank.
  4. ITS-BIA will deprecate the fields / views.  Any reports the have not transitioned by this point will break.

We'll be using this strategy on the following items that require name changes.  Step #1 is starting for the following fields:

  • EVerify Flag AsOf will be replaced by Employee EVerify Flag AsOf
  • EVerify Count AsOf will be replaced by Employee EVerify Count AsOf
  • EVerify Date AsOf will be replaced by Employee EVerify Date AsOf
  • EVerify Exemption Flag AsOf will be replaced by Employee EVerify Exemption Flag AsOf
  • EVerify Exemption Count AsOf will be replaced by Employee EVerify Exemption Count AsOf
  • EVerify Exemption Date AsOf will be replaced by Employee EVerify Exemption Date AsOf
  • I9 Completion Flag AsOf will be replaced by Employee I9 Completion Flag AsOf
  • I9 Completion Count AsOf will be replaced by Employee I9 Completion Count AsOf
  • I9 Completion Date AsOf will be replaced by Employee I9 Completion Date AsOf
  • Statement Of Economic Interests Date AsOf will be replaced by Employee Statement Of Economic Interests Date AsOf
  • Statement Of Economic Interests Flag AsOf will be replaced by Employee Statement Of Economic Interests Flag AsOf
  • Statement Of Economic Interests Count AsOf will be replaced by Employee Statement Of Economic Interests Count AsOf
  • EVerify Flag Current will be replaced by Employee EVerify Flag Current
  • EVerify Count Current will be replaced by Employee EVerify Count Current
  • EVerify Date Current will be replaced by Employee EVerify Date Current
  • EVerify Exemption Flag Current will be replaced by Employee EVerify Exemption Flag Current
  • EVerify Exemption Count Current will be replaced by Employee EVerify Exemption Count Current
  • EVerify Exemption Date Current will be replaced by Employee EVerify Exemption Date Current
  • I9 Completion Flag Current will be replaced by Employee I9 Completion Flag Current
  • I9 Completion Count Current will be replaced by Employee I9 Completion Count Current
  • I9 Completion Date Current will be replaced by Employee I9 Completion Date Current
  • Statement Of Economic Interests Date Current will be replaced by Employee Statement Of Economic Interests Date Current
  • Statement Of Economic Interests Flag Current will be replaced by Employee Statement Of Economic Interests Flag Current
  • Statement Of Economic Interests Count Current will be replaced by Employee Statement Of Economic Interests Count Current


Ui expand
titleImpacted Views and Column Groups

Impacted Views

  • EAH-EmployeeDemographic-View
  • EAH-EmployeeDemographicRestricted-View
  • EAH-PositionFunding-View
  • EAH-Workforce-View
  • EAH-WorkforceRestricted-View

Impacted Column Groups

  • EAH Position Funding Basic
  • EAH Workforce Information Extended

Ui expand
titleDeprecation Calendar


Date
Status
April 8, 2022

The following fields will be release for UAT

  • Employee EVerify Flag AsOf
  • Employee EVerify Count AsOf
  • Employee EVerify Date AsOf
  • Employee EVerify Exemption Flag AsOf
  • Employee EVerify Exemption Count AsOf
  • Employee EVerify Exemption Date AsOf
  • Employee I9 Completion Flag AsOf
  • Employee I9 Completion Count AsOf
  • Employee I9 Completion Date AsOf
  • Employee Statement Of Economic Interests Date AsOf
  • Employee Statement Of Economic Interests Flag AsOf
  • Employee Statement Of Economic Interests Count AsOf
  • Employee EVerify Flag Current
  • Employee EVerify Count Current
  • Employee EVerify Date Current
  • Employee EVerify Exemption Flag Current
  • Employee EVerify Exemption Count Current
  • Employee EVerify Exemption Date Current
  • Employee I9 Completion Flag Current
  • Employee I9 Completion Count Current
  • Employee I9 Completion Date Current
  • Employee Statement Of Economic Interests Date Current
  • Employee Statement Of Economic Interests Flag Current
  • Employee Statement Of Economic Interests Count Current

These fields will be migrated to production on April 14

Completed
April 8, 2022 - May 5, 2022

Report developers will repoint their reports

  • EVerify Flag AsOf will be replaced by Employee EVerify Flag AsOf
  • EVerify Count AsOf will be replaced by Employee EVerify Count AsOf
  • EVerify Date AsOf will be replaced by Employee EVerify Date AsOf
  • EVerify Exemption Flag AsOf will be replaced by Employee EVerify Exemption Flag AsOf
  • EVerify Exemption Count AsOf will be replaced by Employee EVerify Exemption Count AsOf
  • EVerify Exemption Date AsOf will be replaced by Employee EVerify Exemption Date AsOf
  • I9 Completion Flag AsOf will be replaced by Employee I9 Completion Flag AsOf
  • I9 Completion Count AsOf will be replaced by Employee I9 Completion Count AsOf
  • I9 Completion Date AsOf will be replaced by Employee I9 Completion Date AsOf
  • Statement Of Economic Interests Date AsOf will be replaced by Employee Statement Of Economic Interests Date AsOf
  • Statement Of Economic Interests Flag AsOf will be replaced by Employee Statement Of Economic Interests Flag AsOf
  • Statement Of Economic Interests Count AsOf will be replaced by Employee Statement Of Economic Interests Count AsOf
  • EVerify Flag Current will be replaced by Employee EVerify Flag Current
  • EVerify Count Current will be replaced by Employee EVerify Count Current
  • EVerify Date Current will be replaced by Employee EVerify Date Current
  • EVerify Exemption Flag Current will be replaced by Employee EVerify Exemption Flag Current
  • EVerify Exemption Count Current will be replaced by Employee EVerify Exemption Count Current
  • EVerify Exemption Date Current will be replaced by Employee EVerify Exemption Date Current
  • I9 Completion Flag Current will be replaced by Employee I9 Completion Flag Current
  • I9 Completion Count Current will be replaced by Employee I9 Completion Count Current
  • I9 Completion Date Current will be replaced by Employee I9 Completion Date Current
  • Statement Of Economic Interests Date Current will be replaced by Employee Statement Of Economic Interests Date Current
  • Statement Of Economic Interests Flag Current will be replaced by Employee Statement Of Economic Interests Flag Current
  • Statement Of Economic Interests Count Current will be replaced by Employee Statement Of Economic Interests Count Current
In Progress
May 5, 2022

The following will display blank values in Hana QA for UAT

  • EVerify Flag AsOf will display blank values
  • EVerify Count AsOf will display blank values
  • EVerify Date AsOf will display blank values
  • EVerify Exemption Flag AsOf will display blank values
  • EVerify Exemption Count AsOf will display blank values
  • EVerify Exemption Date AsOf will display blank values
  • I9 Completion Flag AsOf will display blank values
  • I9 Completion Count AsOf will display blank values
  • I9 Completion Date AsOf will display blank values
  • Statement Of Economic Interests Date AsOf will display blank values
  • Statement Of Economic Interests Flag AsOf will display blank values
  • Statement Of Economic Interests Count AsOf will display blank values
  • EVerify Flag Current will display blank values
  • EVerify Count Current will display blank values
  • EVerify Date Current will display blank values
  • EVerify Exemption Flag Current will display blank values
  • EVerify Exemption Count Current will display blank values
  • EVerify Exemption Date Current will display blank values
  • I9 Completion Flag Current will display blank values
  • I9 Completion Count Current will display blank values
  • I9 Completion Date Current will display blank values
  • Statement Of Economic Interests Date Current will display blank values
  • Statement Of Economic Interests Flag Current will display blank values
  • Statement Of Economic Interests Count Current will display blank values

The fields will display blank values in Production starting May 12, 2022


May 12, 2022

End customers will see empty fields in reports that have not yet been repointed by report developers

Report developers will repoint their reports.

  • EVerify Flag AsOf will be replaced by Employee EVerify Flag AsOf
  • EVerify Count AsOf will be replaced by Employee EVerify Count AsOf
  • EVerify Date AsOf will be replaced by Employee EVerify Date AsOf
  • EVerify Exemption Flag AsOf will be replaced by Employee EVerify Exemption Flag AsOf
  • EVerify Exemption Count AsOf will be replaced by Employee EVerify Exemption Count AsOf
  • EVerify Exemption Date AsOf will be replaced by Employee EVerify Exemption Date AsOf
  • I9 Completion Flag AsOf will be replaced by Employee I9 Completion Flag AsOf
  • I9 Completion Count AsOf will be replaced by Employee I9 Completion Count AsOf
  • I9 Completion Date AsOf will be replaced by Employee I9 Completion Date AsOf
  • Statement Of Economic Interests Date AsOf will be replaced by Employee Statement Of Economic Interests Date AsOf
  • Statement Of Economic Interests Flag AsOf will be replaced by Employee Statement Of Economic Interests Flag AsOf
  • Statement Of Economic Interests Count AsOf will be replaced by Employee Statement Of Economic Interests Count AsOf
  • EVerify Flag Current will be replaced by Employee EVerify Flag Current
  • EVerify Count Current will be replaced by Employee EVerify Count Current
  • EVerify Date Current will be replaced by Employee EVerify Date Current
  • EVerify Exemption Flag Current will be replaced by Employee EVerify Exemption Flag Current
  • EVerify Exemption Count Current will be replaced by Employee EVerify Exemption Count Current
  • EVerify Exemption Date Current will be replaced by Employee EVerify Exemption Date Current
  • I9 Completion Flag Current will be replaced by Employee I9 Completion Flag Current
  • I9 Completion Count Current will be replaced by Employee I9 Completion Count Current
  • I9 Completion Date Current will be replaced by Employee I9 Completion Date Current
  • Statement Of Economic Interests Date Current will be replaced by Employee Statement Of Economic Interests Date Current
  • Statement Of Economic Interests Flag Current will be replaced by Employee Statement Of Economic Interests Flag Current
  • Statement Of Economic Interests Count Current will be replaced by Employee Statement Of Economic Interests Count Current

June 2, 2022

The following will be deleted from Hana QA.

  • EVerify Flag AsOf
  • EVerify Count AsOf
  • EVerify Date AsOf
  • EVerify Exemption Flag AsOf
  • EVerify Exemption Count AsOf
  • EVerify Exemption Date AsOf
  • I9 Completion Flag AsOf
  • I9 Completion Count AsOf
  • I9 Completion Date AsOf
  • Statement Of Economic Interests Date AsOf
  • Statement Of Economic Interests Flag AsOf
  • Statement Of Economic Interests Count AsOf
  • EVerify Flag Current
  • EVerify Count Current
  • EVerify Date Current
  • EVerify Exemption Flag Current
  • EVerify Exemption Count Current
  • EVerify Exemption Date Current
  • I9 Completion Flag Current
  • I9 Completion Count Current
  • I9 Completion Date Current
  • Statement Of Economic Interests Date Current
  • Statement Of Economic Interests Flag Current
  • Statement Of Economic Interests Count Current

June 9, 2022

The following will be deleted from PROD causing any un-touched reports and data integrations to break.

  • EVerify Flag AsOf
  • EVerify Count AsOf
  • EVerify Date AsOf
  • EVerify Exemption Flag AsOf
  • EVerify Exemption Count AsOf
  • EVerify Exemption Date AsOf
  • I9 Completion Flag AsOf
  • I9 Completion Count AsOf
  • I9 Completion Date AsOf
  • Statement Of Economic Interests Date AsOf
  • Statement Of Economic Interests Flag AsOf
  • Statement Of Economic Interests Count AsOf
  • EVerify Flag Current
  • EVerify Count Current
  • EVerify Date Current
  • EVerify Exemption Flag Current
  • EVerify Exemption Count Current
  • EVerify Exemption Date Current
  • I9 Completion Flag Current
  • I9 Completion Count Current
  • I9 Completion Date Current
  • Statement Of Economic Interests Date Current
  • Statement Of Economic Interests Flag Current
  • Statement Of Economic Interests Count Current



View Your Requested Enhancements

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


Ui expand
titleEAH-EmployeeDemographics-View

EAH-EmployeeDemographics-View

Ui expand
titleEAH Workforce EIAM Delta

EAH Workforce EIAM Delta

Epic:  

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

Added the following field:

  • Position Funding Default CCOA FinU
  • Position Funding Default CCOA FinU Code
  • Position Funding Default CCOA Project
  • Position Funding Default CCOA Project Code
  • Position Funding Default CCOA TASK
  • Position Funding Default CCOA TASK Code
Ui expand
titleEAH Workforce Delta

EAH Workforce Delta

Epic:  

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

Added the following field:

  • Identity Mail Drop Current
    • Department

    Epic:  

    Updated the logic for 'LL Deduction CCOA FinU' to point at FinU Description

    Ui expand
    titleEAH-LLSalaryDetail-View

    EAH-LLSalaryDetail-View

    Epic:  

    Updated the logic for 'LL Fringe CCOA FinU' to point at FinU Description

    Ui expand
    titleEAH-PayrollProjectionPerMonth-View

    EAH-PayrollProjectionPerMonth-View

    Epic:  

    Added the following fields:

    • Position CANRA Acknowledgement Count
    • Position CANRA Acknowledgement Flag
    • Position CLERY Act Count
    Ui expand
    titleEAH-PositionFunding-View

    EAH-PositionFunding-View

    Epic:  

    Updated the logic for 'Position Funding CCOA FinU' to point at FinU Description

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

    EAH-Workforce-View & EAH-WorkforceRestricted-View

    Epic:  

    Added the following field:

    • Position CANRA Acknowledgement Count
    • Position CANRA Acknowledgement Flag
    • Count
    • Position Professional License Or Certificate Verification Flag
    • Position Security Clearance Count
    • Position Security Clearance Flag
    • Position Statement Of Economic Interests Count
    • Position Statement Of Economic Interests Flag

    View Your Requested Column Group Enhancements

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

    SNOW ticket(s) addressed: CS0782752

    Added the following new fields:

    • Employee CANRA Acknowledgement Clearance Number Current                           
    • Employee CANRA Acknowledgement Count Current                             
    • Employee CANRA Acknowledgement Date Current                            
    • Employee CANRA Acknowledgement Flag Current                              
    • Employee CANRA Acknowledgement Sponsor Current
    • Employee CLERY Act Clearance Number Current                                       
    • Employee CLERY Act Count Current                                         
    • Employee CLERY Act Date Current                                        
    • Employee CLERY Act Flag Current                                          
    • Employee CLERY Act Sponsor Current
    • Employee Criminal Convictions Record Clearance Number Current                     
    • Employee Criminal Convictions Record Count Current                       
    • Employee Criminal Convictions Record Date Current                      
    • Employee Criminal Convictions Record Flag Current                        
    • Employee Criminal Convictions Record Sponsor Current
    • Employee DMV Driving Record Check Clearance Number Current                        
    • Employee DMV Driving Record Check Count Current                          
    • Employee DMV Driving Record Check Date Current                         
    • Employee DMV Driving Record Check Flag Current                           
    • Employee DMV Driving Record Check Sponsor Current
    • Employee Educational Degree Check Clearance Number Current                        
    • Employee Educational Degree Check Count Current                          
    • Employee Educational Degree Check Date Current                         
    • Employee Educational Degree Check Flag Current                           
    • Employee Educational Degree Check Sponsor Current
    • Employee EVerify Clearance Number Current                                         
    • Employee EVerify Count Current                                           
    • Employee EVerify Date Current                                          
    • Employee EVerify Exemption Clearance Number Current                               
    • Employee EVerify Exemption Count Current                                 
    • Employee EVerify Exemption Date Current                                
    • Employee EVerify Exemption Flag Current                                  
    • Employee EVerify Exemption Sponsor Current
    • Employee EVerify Flag Current                                            
    • Employee EVerify Sponsor Current
    • Employee Financial Disclosure Clearance Number Current                            
    • Employee Financial Disclosure Count Current                              
    • Employee Financial Disclosure Date Current                             
    • Employee Financial Disclosure Flag Current                               
    • Employee Financial Disclosure Sponsor Current
    • Employee I9 Completion Clearance Number Current                                   
    • Employee I9 Completion Count Current                                     
    • Employee I9 Completion Date Current                                    
    • Employee I9 Completion Flag Current                                      
    • Employee I9 Completion Sponsor Current
    • Employee Multiple Clearance Types Required Clearance Number Current               
    • Employee Multiple Clearance Types Required Count Current                 
    • Employee Multiple Clearance Types Required Date Current                
    • Employee Multiple Clearance Types Required Flag Current                  
    • Employee Multiple Clearance Types Required Sponsor Current
    • Employee NRC background Check Clearance Number Current                            
    • Employee NRC background Check Count Current                              
    • Employee NRC background Check Date Current                             
    • Employee NRC background Check Flag Current                               
    • Employee NRC background Check Sponsor Current
    • Employee Police Officer Background Check Clearance Number Current                 
    • Employee Police Officer Background Check Count Current                   
    • Employee Police Officer Background Check Date Current                  
    • Employee Police Officer Background Check Flag Current                    
    • Employee Police Officer Background Check Sponsor Current
    • Employee Previous Employer Reference Check Clearance Number Current               
    • Employee Previous Employer Reference Check Count Current                 
    • Employee Previous Employer Reference Check Date Current                
    • Employee Previous Employer Reference Check Flag Current                  
    • Employee Previous Employer Reference Check Sponsor Current
    • Employee Professional License Or Certificate Verification Clearance Number Current
    • Employee Professional License Or Certificate Verification Count Current  
    • Employee Professional License Or Certificate Verification Date Current 
    • Employee Professional License Or Certificate Verification Flag Current   
    • Employee Professional License Or Certificate Verification Sponsor Current
    • Employee Security Clearance Clearance Number Current                              
    • Employee Security Clearance Count Current                                
    • Employee Security Clearance Date Current                               
    • Employee Security Clearance Flag Current                                 
    • Employee Security Clearance Sponsor Current
    • Employee Statement Of Economic Interests Clearance Number Current                 
    • Employee Statement Of Economic Interests Count Current                   
    • Employee Statement Of Economic Interests Date Current                  
    • Employee Statement Of Economic Interests Flag Current                    
    • Employee Statement Of Economic Interests Sponsor Current



    Ui expand
    titleEAH-LLSalaryDetail-View

    EAH-LLSalaryDetail-View

    Epic:  

    Updated the logic for 'LL Fringe CCOA FinU' to point at FinU Description



    Ui expand
    titleEAH-PayrollProjectionPerMonth-View

    EAH-PayrollProjectionPerMonth-View

    Epic:  

    Added the following fields:

    • Position CANRA Acknowledgement Count
    • Position CANRA Acknowledgement Flag
    • Position CLERY Act Count



    Ui expand
    titleEAH-PositionFunding-View

    EAH-PositionFunding-View

    Epic:  

    Updated the logic for 'Position Funding CCOA FinU' to point at FinU Description



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

    EAH-Workforce-View & EAH-WorkforceRestricted-View

    Epic:  

    Added the following field:

    • Position CANRA Acknowledgement Count
    • Position CANRA Acknowledgement Flag
    • Count
    • Position Professional License Or Certificate Verification Flag
    • Position Security Clearance Count
    • Position Security Clearance Flag
    • Position Statement Of Economic Interests Count
    • Position Statement Of Economic Interests Flag



    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?