New UK Health Dimensions Database For Use by all NHS Organisations

Connect directly to our Azure server from SQL SSMS, MS Excel, Qlikview, Tableau, Power BI or anything else.

Overview

FJ McManus Ltd have developed a system for auto updating a SQL database once a week, that contains all of the following data with full Slowly Changing Dimension (SCD) history.

NHS Data Dictionary
A table for all the TRUD SDS datasets (GP Practice, Postcodes, etc) with SCD history back to 2009
NEW: Daily updated ODS Data
Postcode dataset includes all data from NHS Postcode Directory plus Longitude/Latitude co-ords
An extensive, detailed Date Dimension with one record per day for 1st Jan 1901 to 31st Dec 2199
A detailed Time Dimension with one record per second of the day
An age-band dimension
ICD10 tables, containing the ICD10 2000 version and the 4th edition that came out Apr 2012 as an SCD
Mental Health Metadata
OPCS4 tables, all versions since v4.5
PbR tables back to 2010/11
Public Health Fingertips metadata
Ordnance Survey tables (LSOAs, MSOAs) which are to be used for building maps of the UK, including Commissioner Map and GP Practice MAP
Read Code v2 and v3 as SCD back to 2012
SNOMED as SCD back to 2002
DM+D as SCD back to 2013
CQC
BNF, all versions since 68
Ambulance Quality Indicators Metadata
PROMs Data Dictionary
ODS Data Dictionary
CDS XSD Extracted Data
ECDS Technical Output Spec and ECDS A&E to SNOMED
MSDS Technical Output Spec
EBSX (Choose and Book codes)
IAPT Metadata
NHS111 Codes
Diagnostic Imaging
SHMI
NHS Occupation Codes
POMI Data Dictionary
Prescribed Specialised Services
QOF Indicators
Reference Costs codes
Register of Licence Holders

For more info see our entry on GCloud, search for Facts and Dimensions.

We are offering free, no obligation, trials of the service. Please contact us to request a login to download the latest release today.

UKHD Clients

Almost all UKHD Clients renewed their licences this year. This means we have maintained an almost perfect 0% churn rate, which goes a long way to proving the high quality and usefulness of UK Health Dimensions.

Ashford & St Peter’s Hospitals NHS FT
CACI Ltd
Derby & Burton NHS FT
Doncaster & Bassetlaw Hospitals NHS FT
Dorset Healthcare NHS
Dr Foster
Embed Health Consortium
Frimley Health NHS FT
Frimley ICS
Gloucestershire Health and Care NHS FT
Harrogate and District NHS FT
IQVIA
Mersey Care NHS Trust
Northampton NHS FT
NHS England and all CSUs, DSCROS and, indirectly, all CCGs.
Private Healthcare Information Network
Royal Surrey County Hospital NHS FT
SE Hampshire CCGs
Somerset Partnership NHS FT
South West Yourkshire Partnership NHS FT
Suffolk CCG
Suffolk ICS
Swansea University
Taunton & Somerset NHS FT
University Hospitals of Leicester NHS Trust

Testimonials

"I can confirm that we are now successfully submitting the SUS data using UK Health Dimensions, to meet the new Health Act data requirements for reporting by CCG. This has been a smooth transition to the using the UK HD reference data, during an otherwise involved implementation of CDS post-fix development changes.

Thanks for all your help"

J Nicholas, Information Manager, Heatherwood & Wexham NHS FT