ISD's processing of postcode files - ISD Scotland

ISD's processing of postcode files - ISD Scotland

ISD processing of postcode file
Procedure used for 2013_2 NRS POSTCODE EXTRACT onwards
ONS

National Records of Scotland (NRS)

Quarterly
England, Wales &
Northern Ireland
pc file (no details)

Current combined file

Single record file

Complete file

twice yearly; Scotland large and small user
postcodes, Includes postcodes split across council
areas A, B and C parts. Most recent version.

twice yearly, Scotland,
only part A each pc
assigned to one CA

twice yearly; Scotland large
and small user postcodes, all
live and deleted, all split parts

ISD POSTCODE TABLE (TEST)
Oracle database stored on MGSREF
APEXT

QA by GPD
Team

Feed back
issues to
NRS

QA by GPD Team

Available on
request from
GPD Team for
specialist use

QA by GPD Team

MNUL
Manual
Additions

ISD POSTCODE TABLE
Oracle database stored on MGSREF
APEXP. Includes postcodes split
across council areas A, B and C
copy
parts. Most recent version.

Other
Databases
(e.g. Prescribing
Information System
(PIS), linked to
geography via
postcode on CHI)

L_GEOGRAPHY in NSS
Corporate Data
Warehouse (CDW)
Produced every week. Only part
A each pc assigned to one CA.
Metadata added, e.g. CA names.

Postcode list for
SMR validation
in hospitals, incl
E&W pcs

Geography fields
added to
unlinked SMR00,
SMR01, SMR04
monthly. Part A
only.

MRL
file

ISD Postcode
File

ISD Postcode
Deprivation Lookup files

in cl-out lookups

in cl-out lookups

External ISD
GPD website

SMR01,
SMR04

used in

Data marts e.g. ACaDMe
Used in analyses and research (ISD analysts and wider)

GPD team
email ISD to
inform of
update

Recently Viewed Presentations

  • Why Five? - Intergon

    Why Five? - Intergon

    1981 to 1990 Intergon Principal Consultant 1990 to 1992 KPMG Senior Consultant 1992 to 1995 CPG Corporate Quality Manager Consultant to Telstra Software Development Consultant to Telstra Data Centre Operations 1995 to 2007 Intergon Principal Consultant RMIT MBA student PhD...
  • Ancient Greek Culture - Mrs. Heidmann

    Ancient Greek Culture - Mrs. Heidmann

    Arial Arial Black Wingdings Calibri Glass Layers 1_Glass Layers Ancient Greek Contributions Slide 2 Slide 3 Philosophy Religion Greek Drama Architecture Pediment Sculptures Doric Columns Ionic Columns Corinthian Columns Idealized Sculpture Early Sculpture Idealized Sculpture- Elgin Marbles Red Black Pottery
  • Animal Behavior

    Animal Behavior

    Animal Behavior Elements of Behavior Behavior: the way an organism reacts to changes in its internal condition or external environment Stimulus: any kind of detectable sign that carries information Response: single, specific reaction to a stimulus Types of Stimuli Light...
  • R+J Argument Essay

    R+J Argument Essay

    Prompt #1: Should we continue to read and study Romeo and Juliet? Love it or hate it, R+J is a core text for High School Freshman…but, should it be? While addressing this prompt you will make the argument to either...
  • Value Function Approximation

    Value Function Approximation

    Outline Introduction Approximate policy iteration Value function approximation Laplacian eigenfunctions approximation Diffusion Wavelets approximation Experimental results Conclusions Introduction In MDP models, it is desirable/necessary to approximate the value function for a large state size or reinforcement learning situation.
  • IEEEXtreme 12.0 - 24-Hours Programming Competition

    IEEEXtreme 12.0 - 24-Hours Programming Competition

    What is IEEEXtreme? IEEEXtreme is IEEE's premier programming competition, bringing thousands of students from around the world together into a 24-hour event
  • Chapter 1 Computers and Digital Basics Computer Concepts

    Chapter 1 Computers and Digital Basics Computer Concepts

    010600 A megabyte is 1024 bits. 010700 Microprocessors are a type of integrated circuit. ... be defined as the worldwide economic interdependence of countries that occurs as cross-border commerce increases and as money flows more freely among countries ... Digital...
  • Computer Vision: filtering

    Computer Vision: filtering

    In the case of cross correlation: In the case of convolution: Note that the image and filter are infinite. Median filters A Median Filter operates over a window by selecting the median intensity in the window. What advantage does a...