No edit summary |
m (JoshuA moved page RSD release management to Release Information without leaving a redirect) |
(No difference)
| |
Revision as of 13:49, 11 March 2021
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