Skip to main content

How to map ODS csv files to XML roles

The old ODS approach uses a large number of separate CSV files, with their content being constrained by organisation type. The new approach sees all types of organisation published within a single XML file, with new ‘role’ meta-data values to identify organisation type.

Published: 27 April 2018

Version: 1.1

An ability to identify records within the XML based on their role and the CSV file they used to be published in is likely to be a common requirement for users making the transition to the new approach.

An interactive object model has been developed to support transition for users of health and social care organisation data. The object model includes a diagram showing which primary and non-primary roles each of the published ODS .csv files relate to.

.csv to role mapping

The interactive object model can be downloaded from the refmodel .zip folder that can be found on
the ODS XML products page or via the XML supporting products pack on TRUD.

To access the object model:

  • open the folder
  • open the README.txt document (this explains how JavaScript must be enabled to allow the object model to be viewed)
  • double click on the ‘HSCOrgRefData_ObjectModel’ folder and then on the ‘Index’ file
  • this will take you to the navigation page of the model from where all other components of the model can be accessed
  • on the Navigation page, click on the grey tab for ‘.CSV to XML Mapping’ (see the image below)

Interactive Object Model screenshot

Example extract from the .csv to XML mapping diagram

For each ODS .csv file, the mapping diagram shows which XML role codes are required to replicate the content of that .csv. For example, to obtain the same list of organisations as published within Eauth.csv, the following XML Role Codes are required:

Example extract from the .csv to XML mapping diagram

Further information on XML role reference data can be found in a separate guide.

Last edited: 25 July 2019 3:14 pm