m (JoshuA moved page RSD release management to Release Information without leaving a redirect) |
No edit summary |
||
| Line 1: | Line 1: | ||
== patient_address_match == | == Discovery Data Service Updates == | ||
{| border="1" style="border-collapse:collapse; text-align: left; vertical-align:top; width:80%;" | |||
|- style="background-color:#90A4AE; color: white; vertical-align: top;" | |||
! scope="col" width="10%" |Release Date | |||
! scope="col" width="30%" |Summary | |||
! scope="col" width="10%" |Reason | |||
! scope="col" width="30%" |Benefit | |||
|- | |||
|test | |||
|test | |||
|test | |||
|test | |||
|- | |||
|} | |||
== Remote Subscriber Databases (RSD) == | |||
=== patient_address_match === | |||
'''Type of change -''' Commissioned Change | '''Type of change -''' Commissioned Change | ||
Revision as of 13:57, 11 March 2021
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