(Created page with "patient_address_match") |
No edit summary |
||
| Line 1: | Line 1: | ||
patient_address_match | == 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. | |||
{| class="wikitable" | |||
|'''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 | |||
Revision as of 14:50, 10 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