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.

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.
ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.
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.
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

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

New View: EAH-PositionBudgetComparisonSummary-View

BIA and CBO is excited to release a new view that will allow report building against the position budgeting subsystem: https://blink.ucsd.edu/finance/budget/oracle-planning-and-budget.html

Per our regular release for new views, EAH-PositionBudgetComparisonSummary-View will remain in UAT for an extended period and go to Production in our June release.

Ui expand

title	EAH-PositionBudgetComparisonSummary-View

EAH-PositionBudgetComparisonSummary-View

Fields included in this view are:

Accounting Period
Activity Code
Employee ID
Entity Code
Financial Unit Code
Fiscal Accounting Period
Fiscal Month (MM)
Fiscal Period End Date
Fiscal Year (YYYY)
Function Code
Fund Code
LL Fringe Monetary Amount Total
LL Job FTE Total
LL Salary Gross Earnings Total
Location Code
Payroll Projection Benefit Amount Total
Payroll Projection Salary Amount Total
Position
Position Budget Actual Pay Distribution Total
Position Budget Data Load Cube Name
Position Budget Fiscal Year
Position Budget Fiscal Year (YYYY)
Position Budget Month
Position Budget One Time Benefits Amount Total
Position Budget One Time Salary Amount Total
Position Budget Period Budgeted FTE Total
Position Budget Plan Element
Position Budget Recurring Benefits Amount Total
Position Budget Recurring Salary Amount Total
Position Budget Scenario
Position Budget Type
Position Budget Version
Position Number
Program Code
Project Code

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.

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.
ITS-BIA will allow a transition period for report developers to repoint their reports at the new fields / views.
ITS-BIA will remove the data from the old fields / views and allow a second transition period. *Any reports or data integrations using these fields as filters or joins will break.
ITS-BIA will deprecate the fields / views. Any reports the have not transitioned by this point will break. *Any reports or data integrations using these fields will break.

We'll be using this strategy on the following items that require name changes. Step #3 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

title	*Impacted 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

title	Deprecation 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	Completed
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

will be replaced by Employee Statement Of Economic Interests Count AsOfEVerify Flag Current will be replaced by Employee EVerify

EVerify Flag Current
EVerify Count Current
EVerify Date Current
EVerify Exemption Flag Current
EVerify Exemption Count Current

will be replaced by Employee EVerify

EVerify Exemption Date Current
I9 Completion Flag Current
I9 Completion Count Current

EVerify

I9 Completion Date Current

will be replaced by Employee EVerify

Ui expand

title	EAH-EmployeeDemographics-View

EAH-EmployeeDemographics

Statement Of Economic Interests 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

title	Impacted 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

title	Deprecation Calendar

DateStatusApril 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

CompletedApril 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 ProgressMay 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.

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

Ui expand

title	EAH-EmployeeDemographics-View

EAH-EmployeeDemographics-View

Epic:

Jira Legacy

server	ITS PRO
serverId	ebe8394f-6d75-344c-8d9c-717cb778a1eb
key	EAHMAINT-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

title	EAH-LLSalaryDetail-View

EAH-LLSalaryDetail-View

Epic:

Jira Legacy

server	ITS PRO
serverId	ebe8394f-6d75-344c-8d9c-717cb778a1eb
key	EAHMAINT-2266

Added the following fields:

LL Salary Earnings Category Code
LL Salary Earnings Category

Ui expand

title	EAH-PayrollProjectionPerMonth-View

EAH-PayrollProjectionPerMonth-View

Epic:

Jira Legacy

server	ITS PRO
serverId	ebe8394f-6d75-344c-8d9c-717cb778a1eb
key	EAHMAINT-2254

SNOW ticket(s) addressed: CS1027722 and CS0981910

Added the following fields:

Job End Date
Job Expected End Date
Position Funding Award Number
Position Funding Award Title
Position Funding End Date

Ui expand

title	EAH-PositionFunding-View

EAH-PositionFunding-View

Epic:

Jira Legacy

server	ITS PRO
serverId	ebe8394f-6d75-344c-8d9c-717cb778a1eb
key	EAHMAINT-2253

Added the following fields:

Pay Group Regular Earnings Effort Bearing Count
Pay Group Regular Earnings Effort Bearing Flag
Pay Group Regular Earnings Type
Pay Group Regular Earnings Type Code

Ui expand

title	EAH-Workforce-View & EAH-WorkforceRestricted-View & EAH-WorkforceRestrictedPerMonth-View

EAH-Workforce-View & EAH-WorkforceRestricted-View & EAH-WorkforceRestrictedPerMonth-View

Epic:

Jira Legacy

server	ITS PRO
serverId	ebe8394f-6d75-344c-8d9c-717cb778a1eb
key	EAHMAINT-22522251

SNOW ticket(s) addressed: CS0782752

Added the following new fieldsfield:

Employee CANRA Acknowledgement Clearance Number Current AsOf
Employee CANRA Acknowledgement Clearance Number Current
Employee CANRA Acknowledgement Count AsOf
Employee CANRA Acknowledgement Count Current
Employee CANRA Acknowledgement Date AsOf
Employee CANRA Acknowledgement Date Current
Employee CANRA Acknowledgement Flag AsOf
Employee CANRA Acknowledgement Flag Current
Employee CANRA Acknowledgement Sponsor AsOf
Employee CANRA Acknowledgement Sponsor Current
Employee CLERY Act Clearance Number AsOf
Employee CLERY Act Clearance Number Current
Employee CLERY Act Count AsOf
Employee CLERY Act Count Current
Employee CLERY Act Clearance Number Current Date AsOf
Employee CLERY Act Count Current Date Current
Employee CLERY Act Date Current Flag AsOf
Employee CLERY Act Flag Current
Employee CLERY Act Sponsor AsOf
Employee CLERY Act Sponsor Current
Employee Criminal Convictions Record Clearance Number AsOf
Employee Criminal Convictions Record Clearance Number Current
Employee Criminal Convictions Record Count AsOf
Employee Criminal Convictions Record Count Current
Employee Criminal Convictions Record Date AsOf
Employee Criminal Convictions Record Date Current
Employee Criminal Convictions Record Flag AsOf
Employee Criminal Convictions Record Flag Current
Employee Criminal Convictions Record Sponsor CurrentAsOf
Employee DMV Driving Record Check Clearance Number Current Criminal Convictions Record Sponsor Current
Employee DMV Driving Record Check Count Current Clearance Number AsOf
Employee DMV Driving Record Check Date Current Clearance Number Current
Employee DMV Driving Record Check Flag Current Count AsOf
Employee DMV Driving Record Check Sponsor Count 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

title	EAH-LLSalaryDetail-View

EAH-LLSalaryDetail-View

Epic:

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

Ui expand

title	EAH-PayrollProjectionPerMonth-View

EAH-PayrollProjectionPerMonth-View

Epic:

Added the following fields:

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

Ui expand

title	EAH-PositionFunding-View

EAH-PositionFunding-View

Epic:

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

Ui expand

title	EAH-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 FlagDMV Driving Record Check Date AsOf
Employee DMV Driving Record Check Date Current
Employee DMV Driving Record Check Flag AsOf
Employee DMV Driving Record Check Flag Current
Employee DMV Driving Record Check Sponsor AsOf
Employee DMV Driving Record Check Sponsor Current
Employee Educational Degree Check Clearance Number AsOf
Employee Educational Degree Check Clearance Number Current
Employee Educational Degree Check Count AsOf
Employee Educational Degree Check Count Current
Employee Educational Degree Check Date AsOf
Employee Educational Degree Check Date Current
Employee Educational Degree Check Flag AsOf
Employee Educational Degree Check Flag Current
Employee Educational Degree Check Sponsor AsOf
Employee Educational Degree Check Sponsor Current
Employee EVerify Clearance Number AsOf
Employee EVerify Clearance Number Current
Employee EVerify Count AsOf
Employee EVerify Count Current
Employee EVerify Date AsOf
Employee EVerify Date Current
Employee EVerify Exemption Clearance Number AsOf
Employee EVerify Exemption Clearance Number Current
Employee EVerify Exemption Count AsOf
Employee EVerify Exemption Count Current
Employee EVerify Exemption Date AsOf
Employee EVerify Exemption Date Current
Employee EVerify Exemption Flag AsOf
Employee EVerify Exemption Flag Current
Employee EVerify Exemption Sponsor AsOf
Employee EVerify Exemption Sponsor Current
Employee EVerify Flag AsOf
Employee EVerify Flag Current
Employee EVerify Sponsor AsOf
Employee EVerify Sponsor Current
Employee Financial Disclosure Clearance Number AsOf
Employee Financial Disclosure Clearance Number Current
Employee Financial Disclosure Count AsOf
Employee Financial Disclosure Count Current
Employee Financial Disclosure Date AsOf
Employee Financial Disclosure Date Current
Employee Financial Disclosure Flag AsOf
Employee Financial Disclosure Flag Current
Employee Financial Disclosure Sponsor AsOf
Employee Financial Disclosure Sponsor Current
Employee I9 Completion Clearance Number AsOf
Employee I9 Completion Clearance Number Current
Employee I9 Completion Count AsOf
Employee I9 Completion Count Current
Employee I9 Completion Date AsOf
Employee I9 Completion Date Current
Employee I9 Completion Flag AsOf
Employee I9 Completion Flag Current
Employee I9 Completion Sponsor AsOf
Employee I9 Completion Sponsor Current
Employee Multiple Clearance Types Required Clearance Number AsOf
Employee Multiple Clearance Types Required Clearance Number Current
Employee Multiple Clearance Types Required Count AsOf
Employee Multiple Clearance Types Required Count Current
Employee Multiple Clearance Types Required Date AsOf
Employee Multiple Clearance Types Required Date Current
Employee Multiple Clearance Types Required Flag AsOf
Employee Multiple Clearance Types Required Flag Current
Employee Multiple Clearance Types Required Sponsor AsOf
Employee Multiple Clearance Types Required Sponsor Current
Employee NRC background Check Clearance Number AsOf
Employee NRC background Check Clearance Number Current
Employee NRC background Check Count AsOf
Employee NRC background Check Count Current
Employee NRC background Check Date AsOf
Employee NRC background Check Date Current
Employee NRC background Check Flag AsOf
Employee NRC background Check Flag Current
Employee NRC background Check Sponsor AsOf
Employee NRC background Check Sponsor Current
Employee Police Officer Background Check Clearance Number AsOf
Employee Police Officer Background Check Clearance Number Current
Employee Police Officer Background Check Count AsOf
Employee Police Officer Background Check Count Current
Employee Police Officer Background Check Date AsOf
Employee Police Officer Background Check Date Current
Employee Police Officer Background Check Flag AsOf
Employee Police Officer Background Check Flag Current
Employee Police Officer Background Check Sponsor AsOf
Employee Police Officer Background Check Sponsor Current
Employee Previous Employer Reference Check Clearance Number AsOf
Employee Previous Employer Reference Check Clearance Number Current
Employee Previous Employer Reference Check Count AsOf
Employee Previous Employer Reference Check Count Current
Employee Previous Employer Reference Check Date AsOf
Employee Previous Employer Reference Check Date Current
Employee Previous Employer Reference Check Flag AsOf
Employee Previous Employer Reference Check Flag Current
Employee Previous Employer Reference Check Sponsor AsOf
Employee Previous Employer Reference Check Sponsor Current
Employee Professional License Or Certificate Verification Clearance Number AsOf
Employee Professional License Or Certificate Verification Clearance Number Current
Employee Professional License Or Certificate Verification Count AsOf
Employee Professional License Or Certificate Verification Count Current
Employee Professional License Or Certificate Verification Date AsOf
Employee Professional License Or Certificate Verification Date Current
Employee Professional License Or Certificate Verification Flag AsOf
Employee Professional License Or Certificate Verification Flag Current
Employee Professional License Or Certificate Verification Sponsor AsOf
Employee Professional License Or Certificate Verification Sponsor Current
Employee Security Clearance Clearance Number AsOf
Employee Security Clearance Clearance Number Current
Employee Security Clearance Count AsOf
Employee Security Clearance Count Current
Employee Security Clearance Date AsOf
Employee Security Clearance Date Current
Employee Security Clearance Flag AsOf
Employee Security Clearance Flag Current
Employee Security Clearance Sponsor AsOf
Employee Security Clearance Sponsor Current
Employee Statement Of Economic Interests Clearance Number AsOf
Employee Statement Of Economic Interests Clearance Number Current
Employee Statement Of Economic Interests Count AsOf
Employee Statement Of Economic Interests Count Current
Employee Statement Of Economic Interests Date AsOf
Employee Statement Of Economic Interests Date Current
Employee Statement Of Economic Interests Flag AsOf
Employee Statement Of Economic Interests Flag Current
Employee Statement Of Economic Interests Sponsor AsOf
Employee Statement Of Economic Interests Sponsor Current
Pay Group Regular Earnings Effort Bearing Count
Pay Group Regular Earnings Effort Bearing Flag
Pay Group Regular Earnings Type
Pay Group Regular Earnings Type Code

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?

Versions Compared

Old Version 2

New Version Current

Key

Renaming & Deprecating

New View: EAH-PositionBudgetComparisonSummary-View

EAH-PositionBudgetComparisonSummary-View

Renaming & Deprecating

View Your Requested Enhancements

View Your Requested Enhancements

EAH-EmployeeDemographics-View

EAH-LLSalaryDetail-View

EAH-PayrollProjectionPerMonth-View

EAH-PositionFunding-View

EAH-Workforce-View & EAH-WorkforceRestricted-View & EAH-WorkforceRestrictedPerMonth-View

EAH-LLSalaryDetail-View

EAH-PayrollProjectionPerMonth-View

EAH-PositionFunding-View

EAH-Workforce-View & EAH-WorkforceRestricted-View

Customer Service Reminder

Follow our Enhancement Testing Steps

Page Comparison

Versions Compared

Old Version 2

New Version Current

Key

Renaming & Deprecating

New View: EAH-PositionBudgetComparisonSummary-View

EAH-PositionBudgetComparisonSummary-View

Renaming & Deprecating

View Your Requested Enhancements

View Your Requested Enhancements

EAH-EmployeeDemographics-View

EAH-LLSalaryDetail-View

EAH-PayrollProjectionPerMonth-View

EAH-PositionFunding-View

EAH-Workforce-View & EAH-WorkforceRestricted-View & EAH-WorkforceRestrictedPerMonth-View

EAH-LLSalaryDetail-View

EAH-PayrollProjectionPerMonth-View

EAH-PositionFunding-View

EAH-Workforce-View & EAH-WorkforceRestricted-View

Customer Service Reminder

Follow our Enhancement Testing Steps