Release Information
Jump to navigation
Jump to search
Discovery Data Service Updates
Release Date | Summary | Reason | Benefit |
---|---|---|---|
test | test | test | test |
Remote Subscriber Databases (RSD)
patient_address_match
Type of change - Commissioned Change
Release date -
Summary - Included in our project to make patient data identifiable for the CEG Compass 2 database, we plan to make the following changes to the Compass 2 schema. During deployment we will rename the existing patient_address_match table to patient_address_match_backup, re-create patient_address_match using the new table definition then repopulate it from scratch.
Current status | After changes |
Add column uprn_ralf00 (foreign key that references patient_address_ralf) | |
address_match_id | Rename to id (primary key column) |
id | Rename to patient_address_id (foreign key that references patient_address table) |
classification | Rename to uprn_property_classification |
xcoordinate | Rename to uprn_xcoordinate |
ycoordinate | Rename to uprn_ycoordinate |
algorithm | Rename to match_rule |
epoc | Rename to epoch |
Benefits - Improve the relevance of the column names for UPRN
Requesting organisation - NEL STP
Who will be affected - All Compass V2 Databases
- NWL - WSIC
- NEL - CEG Compass 2
- SEL - SEL RSD
Action required by Remote Subscriber Database user - Amend queries relating to data in the patient_address_match table