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.
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
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
Daily updated ODS data fed from NHSD ODS ORD API
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
Read Code v2 and v3 as SCD back to 2012
SNOMED as SCD back to 2002
DM+D as SCD back to 2013
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)
NHS Occupation Codes
POMI Data Dictionary
Prescribed Specialised Services
Reference Costs codes
Register of Licence Holders
For more info see our entry on GCloud (https://www.digitalmarketplace.service.gov.uk/g-cloud/search?lot=cloud-software), 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.
All UKHD Clients renewed their licences for 2015/16. This means we have maintained a 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
Derby & Burton NHS FT
Doncaster & Bassetlaw Hospitals NHS FT
Dorset Healthcare NHS
Embed Health Consortium
Frimley Health NHS FT
Gloucestershire Hospitals NHS FT
Harrogate and District NHS FT
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
Taunton & Somerset NHS FT
University Hospitals of Leicester NHS Trust
"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