Skip to main content

XML Organisation Data Products

This page contains background information and a range of supporting materials for the XML Organisation Reference Data Products.

ANANA XML Test Dataset now available – September 2019

From 1 April 2020 onwards new organisation codes will conform to a single uniform structure of five alternating alphabetic and numeric characters with a format of ANANA.  Please refer to detailed guidance on this change at our information portal.  An XML dataset including representative ANANA codes covering all organisation types in scope is now available for consumers to use for testing and assurance purposes.  The content is based on the August 2019 data release.  A spreadsheet containing the ANANA codes which appear in the data is also available below. 

Please read our products guide before accessing any of the other files.

The move to XML is one part of a wider programme of changes to Organisation Reference Data. Full details are available within an Information Standard.

The standard has been updated to inform consumers that daily updates to the Health and Social Care Organisation Reference Data are now available via Application Programming Interfaces (APIs) – please see APIs for the Organisation data Service.

XML products

Version information

Release item Full live file Archive file
Schema version 2-0-0 2-0-0
Publication date 25 October 2019 25 October 2019
Publication sequence number 604 605
File name HSCOrgRefData_Full_20191022 HSCOrgRefData_Archive_20191023 

XML files are only available to download from TRUD under the 'Organisation Data Services and Spine Directory Service' download group.

TRUD Pack In zip Contains file(s)
HSCOrgRefDataXML_Data fullfile.zip HSCOrgRefData_Full_yyyymmdd.xml
archive.zip HSCOrgRefData_Archive_yyyymmdd.xml

XML support products

In zip File(s) Version date
  HSCOrgRefData_Technical Specification 27 Sep 2017
refmodel HSCOrgRefData_ObjectModel
*Please read the README.txt file within the zip before opening the model*
28 Feb 2019
ancillary HSCOrgRefData_XMLProductScopeTimetable.pdf 28 Sep 2018
HSCOrgRefData.xsd 19 May 2017
HSCOrgRefData_DataItemCatalogue.pdf 6 November 2019
HSCOrgRefData_ChangeLog_DICandObjModel.pdf 6 November 2019
XMLRelationshipRules.xlsx  6 November 2019

XML support tools

In zip File(s) Version date
validate Schemavalidator (folder) 15 Feb 2017
HCSOrgRefData_ValidatorSupportDocumentation.pdf 15 Feb 2017
transform HSCOrgRefData_xslt (zip)
Contains the following transforms:
  • XML to CSV
  • Primary Role Constrain
  • **NEW** XMLtoCSV_database_schema_DDL 

Java and .NET platforms are now supported for the above transforms

30 Nov 2018
HSCOrgRefData_XMLtoCSVSupportDocumentation.pdf 30 Nov 2018
HSCOrgRefData_PrimaryRoleConstrainSupportDocumentation.pdf 28 Sep 2018


The XML support products and tools are also available to download via TRUD, within pack HSCOrgRefDataXML_Support.

Last edited: 5 November 2019 4:37 pm