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
Schedule
Friday, August 8: release enhancements to User Acceptance Testing
Thursday, August 15 end of day: release enhancement to Production
Friday, August 16, end of day: delete QA models
Thank You Report Developers!
Special thanks to the report developers who submitted enhancement requests.
- Kacy Cashatt
- Kevin Chou
- Todd Everett
- David Mandell
- Tiffany Swiderski
New Views
EAH-GradWorkPeriodDetail-View
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: - EAHE-3174Getting issue details... STATUS
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-ApprovalPayPathDetail-View
In conjunction with the UCPath Reporting Team, BIA is excited to release the EAH-ApprovalPayPathDetail-View. This new view will allow visibility into the pay path approval workflow transactions.
This view will be part of the EAH Core views and uses row level security. This view will remain in UAT for a month.
Epic: - EAHE-3026Getting issue details... STATUS
SNOW tickets addressed: CS1174422
Unique fields include:
- Approval Comments
- PayPath Academic Duration Appointment
- PayPath Academic Duration Appointment Code
- PayPath Business Unit
- PayPath Business Unit Code
- PayPath Cubicle
- PayPath Department
- PayPath Department Code
- PayPath Effective Date
- PayPath Effective Sequence Number
- PayPath Employee Class
- PayPath Employee Class Code
- PayPath Employee ID
- PayPath Employee Record
- PayPath Employee Relations
- PayPath Employee Relations Code
- PayPath ERIT End Date
- PayPath FLSA Status
- PayPath FLSA Status Code
- PayPath FTE
- PayPath Job Action
- PayPath Job Action Code
- PayPath Job Action Reason
- PayPath Job Action Reason Code
- PayPath Job Automatically End Count
- PayPath Job Automatically End Flag
- PayPath Job Code
- PayPath Job Code Description
- PayPath Job Comments
- PayPath Job Compensation Frequency
- PayPath Job Compensation Frequency Code
- PayPath Job Compensation Rate
- PayPath Job Earnings Distribution Type
- PayPath Job Earnings Distribution Type Code
- PayPath Job Expected End Date
- PayPath Job FTE
- PayPath Job Leave Of Absence End Date
- PayPath Job Standard Hours Frequency Code
- PayPath Last Updated By User ID
- PayPath Location
- PayPath Location Code
- PayPath Location Use End Date
- PayPath Location Use Type Code
- PayPath Mail Drop
- PayPath Position
- PayPath Position Action
- PayPath Position Action Code
- PayPath Position Action Reason
- PayPath Position Action Reason Code
- PayPath Position Class
- PayPath Position Class Code
- PayPath Position Number
- PayPath Position Pool
- PayPath Position Pool ID
- PayPath Probation End Date
- PayPath Probation Status
- PayPath Probation Status Code
- PayPath Reports To Position Number
- PayPath Representation
- PayPath Representation Code
- PayPath Salary Grade
- PayPath Salary Grade Code
- PayPath Salary PlanPay
- Path Salary Plan Code
- PayPath Salary Step Number
- PayPath Standard Hours
- PayPath Standard Hours Frequency
- PayPath Transaction Category
- PayPath Transaction Category Code
- PayPath Trial Employment End Date
- PayPath Union
- PayPath Union Code
- PayPath Workflow Status
- PayPath Workflow Status Code
View Your Requested Enhancements
Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.
Employee Name Last Updated Date, Employee Pronoun
Epic: - EAHE-3239Getting issue details... STATUS
SNOW ticket(s) addressed: CS2069705, CS2114866
Added the following new fields:
- Employee Name Last Updated Date = This will return the most recent date when any part of the Employee Name has changed (first, middle, last, lived or legal). Will also return a date in cases where there is no prior value( i.e. name is first established).
- Employee Pronouns Current = The current self-reported employee pronoun value in UCPath.
- Employee Pronouns Code Current = The code for the current self-reported employee pronoun value in UCPath.
- Employee Pronouns Last Updated Date = This will return the most recent date when the Employee Pronoun has changed. A prior value MUST exist. Does not display future dates.
Views updated with these new fields:
- EAH-EmployeeDemographics-View
- EAH-WorkforceAllRows-View
- EAH-Workforce-View
UAT - Customer Service Reminder
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
- 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.