10 likes | 107 Views
National Records of Scotland (NRS). ‘Current combined’ file twice yearly; Scotland large and small user postcodes, both live and deleted. ONS quarterly England & Wales pc file (no details). Other databases (eg Prescribing Information System, linked to geography via postcode on CHI).
E N D
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)