1 / 1

Geographic Data Processing for Healthcare Analytics

Explore NRS files providing postcodes for Scotland user data, ONS files for England and Wales, and databases linked to postcode information. Includes SMR validation and geographical metadata processing for healthcare analytics.

mulan
Télécharger la présentation

Geographic Data Processing for Healthcare Analytics

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. National Records of Scotland (NRS) ‘Current combined’ filetwice yearly; Scotland large and small user postcodes, both live and deleted ONSquarterly England & Wales pc file (no details) Other databases(eg Prescribing Information System, linked to geography via postcode on CHI) NSS/ISD processing of postcode files: PROCEDURE FROM 2013_1 Postcode list for SMR validationin hospitals, incl E&W pcs MNUL(manual additions) MGS1/APEXP(Oracle DB). Includes postcodes split across council areas – A, B and C parts. Most recent version. Geography fields added to unlinked SMR00, SMR01, SMR04 monthly. Part A only. MRL file SMR01, SMR04 copy L_GEOGRAPHY in Corporate WarehouseProduced every week. Only part A – each pc assigned to one CA.Metadata added, eg LA names. ‘Single record’ file = Latestpcinfowithlinkpc.sav(twice yearly, Scotland, only part A – each pc assigned to one CA) used in used in Deprivation and population lookup files etc Data marts eg ACaDMe Analyses and research (ISD analysts and wider)

More Related