Absence Analytics SCHRUG Alliance 2019 July 22 23

Absence Analytics SCHRUG Alliance 2019 July 22 - 23, 2019

Dan Webb, MBA Business Analyst II University of Texas System Administration System Information Services dwebb@utsystem. edu 2

Who is UT System Administration • One of the largest systems of higher education with 14 institutions that educate more than 235, 000 students • Award more than one-third of all undergraduate degrees in Texas and almost two-thirds of all health profession degrees • Is one of the largest employers in Texas • Among the top 10 “World’s Most Innovative Universities” according to Reuters • Ranks third in US in patent applications & No. 1 in Texas & No. 3 in the U. S. in federal research expenditures • Priority is to students and the patients 3

UT System Institutions UT System Academic Institutions • • The University of Texas at Arlington The University of Texas at Austin The University of Texas at Dallas The University of Texas at El Paso The University of Texas Permian Basin The University of Texas Rio Grande Valley The University of Texas at San Antonio The University of Texas at Tyler UT System Health Institutions • • • The University of Texas Southwestern Medical Center The University of Texas Medical Branch at Galveston The University of Texas Health Science Center at Houston The University of Texas Health Science Center at San Antonio The University of Texas M. D. Anderson Cancer Center The University of Texas Health Science Center at Tyler 4

What is Shared System Services • UT System created a shared services initiative to consolidate redundant information technology and business services for academic institutions • Purpose is to provide a collaborative environment to support Shared Services Application Implementation and participating members from multiple UT institutions • Encompasses the concept of shared governance • Overseen by both SIS and representatives of the participating campuses • Includes Operating and Functional Committees • Focus is Application Support as well as network and hardware, DBA, security, etc. 5

History of People. Soft HCM at UT System • May 2014 – Transitioned 7 academic institutions to People. Soft 9. 1 from legacy in-house • Absence Management was included in the HCM module scope • September 2018 – Implemented UTRGV from Oracle E-Business Suite to People. Soft 9. 2 • May 2019 – UTRGV progresses to People. Tools 8. 56 / PUM 28 -29 • June 2019 – UTShare upgrades to People. Soft 9. 2 • • Progressed to People. Tools 8. 56 / PUM 27 All Academic institutions now utilize People. Soft HCM 9. 2 6

Absence Analytics • New feature for UTShare / UTRGV for 9. 2 • All academic institutions support the same or similar configuration and processing in Absence Management • Overall effort is to align all institutions with a common reporting and approval approach • Allows Administrators and Supervisors based on campus business roles to analyze their absence data • Reduces the need for running queries and reports, provides enhanced data analytics to analyze absence and payroll results, and improves the efficiency of approving absence requests through UI 7

Absence Analytics Overview • Enable Absence Analytics, Payroll Analytics, and Pivot Grids options in ABM Installation Settings • Manage Pagelet Configuration for Dashboard pages • GP Analytics is updated through the Absence calculation process or ad-hoc • Configurable for open calendar groups and retro transactions • Allows supervisor approvals and notification workflow for EEs • Can be used for individual approvals or bulk mode approvals of leave requests • Displays drill-down functionality and enhanced high-level reporting & analysis

Absence Analytics Report Data • Configuration of Absence Pivots process details • Apply SQL Input Filters for Process configuration • UTSIS cascade model has separate Accumulators to display day-by-day cascading results to ABM Admin • Each cascade absence take type option must exclude any cascading Accumulator

Absence Analytics Dashboards for Admins Absence Analytics Dashboard • A one-stop location for the Absence Administrator to view statuses of their institution’s absence data before finalizing or sending the data to T&L/Payroll Absence Management Dashboard Pivot Grids • Absence Events Analysis • Absence Cost Analysis • Absence Liability & Trends • Periodic Absence Rate • Absence Take and Type • Employee with Negative Balance • Absence by Paid Unpaid Status • By Generated Positive Input 10

Absence Analytics Dashboards for Admins 11

Load Absence Analytics Data Ad-hoc • Before analyzing the absence data using the delivered absence analytics charts, prepare and load the absence data. • Use the Refresh Employee Information (HGA_EMPREF_RUNCNTL) page to update the employee information with the most current data. • Run the Load Absence Analytics Data (HGA_PG_RUNCNTL) process for a specified date range. 12

Absence Analytics Dashboard for Managers Absence Events Analysis on Manager Dashboard • A pagelet for the Supervisor to view statuses of their employee’s absence requests • Allows for drill down functionality of absence requests • Can be used for individual approvals or bulk mode approvals of leave requests 13

Absence Analytics Pivot Grids for Manager Dashboard • • Absence Events Analysis Pivot Grids Absence Events Analysis Absence Cost Analysis Absence Liability & Trends Periodic Absence Rate 14

Absence Analytics for Manager Self Service Absence Analytics Tile • A tile for the Supervisor to view statuses of their employee’s absence requests • Allows for drill down functionality of individual leave takes • Can be used for individual approvals or bulk mode approvals of leave requests • Includes notification workflow • Incorporates additional options for individual preference views of pivot grids 15

Absence Analytics Functionality for MSS • Actions prompts enable notifications to EEs, Absence approvals, and detailed absence event views • Prompts enable user to change the Analytics data by applying filters and options 16

Absence Analytics Approvals for MSS • Individual absence request approvals directly from analytics view • Bulk mode absence request approvals directly from analytics view 17

Absence Analytics Filters for MSS • Filters and prompts allow to self manage views of pivot grids and filtered data • Sort Options and Base Views allow for default reporting features • Once filters are changed, Views can be saved for later reporting 18

Simplified Analytics • Enables users to create contextual analytic reports • Create own reports based on pre-defined templates by selecting fields, prompt fields, layouts, and types of visualizations • Generate and publish reports to Pivot Grid users • Available for Fluid components only / Portal navigation • Can be added to Fluid related content pages 19

Simplified Analytics in My Team • Slide-out supplementary panels provide related information to help managers complete their transactions • Managers can use the My Analytics tab to create their own personalized analytics • Individualized configurable simplified analytics ondemand • Filtered views can be saved for later on-demand needs 20

Simplified Analytics in HR 21

Questions? Or send email to: dwebb@utsystem. edu