Key Payroll and Pensions BI Dashboards - ESR Hub
This dashboard is designed to provide the user with intelligence around payroll data, specifically deductions and allowances. Analyses are available which detail information regarding net pay comparison, gross and net pay of assignments over a period of time, age analysis, rehires, assignments not worked, minimum wage, recalled leavers, payslip messages, pay balances, payment methods, BIK and many more.
Click this link to go to the BI user guide: Payroll Dashboard BI user guide
This dashboard is designed to provide the user with intelligence around employees pension information. Multiple analyses are available which show Assignments opted IN to the NHS Pension Scheme, Pension Data Extract Matching, Pension Banding information, Local Pension elements and IAT Pension Override Dates.
Click this link to go to the BI user guide: Pensions Dashboard
The Change Event Log dashboard enables users to audit changes made in ESR. The dashboard returns the values changed along with who made the change and on which date. Tabs are available which report changes including employee, assignment, online payslip views, element entry, pay as well as NI and Pensions.
Click this link to go to the BI user guide: Change Event Log Dashboard
This dashboard is designed to provide the user with intelligence around Element Entries. The dashboard includes analyses on Element Entries by Assignment, Element Entry combinations, Payments due to expire, Element Entry Updates and Batch Element Entry Messages.
Click this link to go to the BI user guide: Element Entries Dashboard
This dashboard is designed to contain analyses relating to all types of absence analysis. Analyses are available which show information relating to absence trends within organisations, absence entry, maternity leave, employees approaching half or nil pay and many more.
Click this link to go to the BI user guide: Absence Analysis Dashboard
This dashboard is designed to provide users with intelligence on the pay bill of their workforce. Analyses are available which detail the Pay Bill Summary, as well as the Total Monthly Pay Bill showing a simple total pay bill grouped by month for the organisation, and a Monthly Pay Bill analysis showing the monthly pay bill grouped by either pay band or element group.
Click this link to go to the BI user guide: Pay Bill Dashboard
This dashboard is designed to provide users with an analysis of Payroll Run Results at a range of levels within the organisation, including grouped by Staff Group, Organisation and Element Name and Individual Assignments.
Click this link to go to the BI user guide: Payroll Run Analysis Dashboard
This dashboard is based on the Accounting Period time dimension and provides a range of Payroll Costing Measures. Summary and Detail tabs are available as well as an analysis which returns the Cumulative Gross Cost value as a whole for each assignment.
Click this link to go to the BI user guide: Financial Cost Analysis Dashboard
This dashboard is designed to provide users with intelligence around a number of Data Quality tests. Includes analyses such as Final Process Date should not be null, Employee 80 years or older, Open-Ended Absence greater than 12 months, Adjacent sickness absence for same employee with same reason, Bank Assignment Status of Inactive Not Worked > 12 months, Home Address Line 1 is recorded incorrectly etc.
Click this link to go to the BI user guide: Data Quality Dashboard
This dashboard is designed to contain analyses relating to all types of absence. Summary and Detail analyses are available as well as Absence Triggers, Long Term and Short-Term Sickness, Days lost in period, Individual Absence Records, Annual Leave Balances and others.
Click this link to go to the BI user guide: Absence Dashboard