EsrGo Interface

EsrGo Payroll to Rostering Interface

Project Summary

Project type

  • C#, .Net 4.5, WPF with MVVM, Entity Framework v5
  • A standalone application to collate and preprocess ESR data for
  • HealthRoster
  • Principal analyst programmer

Key challenges

  • Handling temporal data, i.e. records with validity dates
  • Capturing transform events to provide audit trail
  • Mapping of soft fields to strongly typed data
  • FTP transfer protocol
  • Aggregation of daily update feeds to repository
  • Different csv formats for UK and Australia

component-overview
(click to enlarge)

Application Outline

EsrGo is an automated interface between Electronic Staff Records payroll system and Allocate Software’s HealthRoster rostering system. Person details including Assignments and Credentials (competencies, qualifications, professional registrations, background checks) are transferred in, along with associated master data such as Organization and Position.

This application has two main responsibilities:

  • To record data from ESR and ensure a faithful copy

    • collate daily change data into a local repository
    • monthly to refresh the whole data set completely
    • track data file sequence numbers and request a refresh when out of sync

  • To produce data streams in a fit state for HealthRoster

    • check for missing data items and reference data and tag records accordingly
    • ensure lifetime validity dates are consistent and complete
    • shape the data to be suitable for the HealthRoster Gateway data loader

Data Volumes

The data volume at the trial NHS site, a medium-sized site, was 100,000 records for a full file. This was processed once a month with small daily change files of about 200 records in between. Process time for 100,000 records was 19 seconds.