# Application Tools

# FTP Configuration

FTP is a mature protocol but requires a degree of expertise when setting up and supporting. The EsrGo Interface supports debugging the FTP installation by non-technical staff. To do this, the individual steps are exposed in a configuration tool. This was written in WPF.

# Competency Mapping

The Competencies data stream contains a mixture of staff member credentials such as skills, qualifications, police checks, right-to-work, professional memberships. Some of these are entered into ESR in soft fields, which means

• the scope and the terms (identifying string values) used can vary by NHS Trust
• the soft tables can contain multiple target types
• the column names are generic, and don’t give a lot of information about the content
• some of the records in the table are not of interest

An external XML mapping file was used to specify conversions. A mapping entry consists of a Selector string value and multiple field mappings which define the categorization codes to be used in HealthRoster.

<!-- Selection to be based on ESR field "InformationType" -->
<Selector Value="NHS CRB and Vetting Checklist" />
<FieldMappings>
    <Mapping GatewayName="CompetenceCluster" Value="Police Check" />
    <Mapping GatewayName="CompetenceType" Value="CRB" />
    <Mapping GatewayName="CompetenceName" Value="CRB" />
</FieldMappings>

# Data Profiling

For every client installation the data in the soft tables will be different and needs to be examined to find out what mappings are required. A Data Profiling report provided a breakdown of the identifying string values in the table and identifies the type, value range, and outlying values of remaining columns.