Discovery Data Service Updates
| Release Date | Summary | Reason | Benefit |
|---|---|---|---|
| 11 March 2021 | The TPP Gateway moves completed extracts into an archive folder, once it has a new extract to download, which is usually every 24 hours. The DDS uploader then checks the archive folder for new extracts, where they are uploaded to the DDS for processing. An in-depth investigation was carried out on how this 24-hour period could be reduced, and it was found that the DDS uploader could check for, and upload complete files contained in both the root directory and the archive folder, instead of just the archive folder.
Changes were developed, tested, and deployed to the DDS uploader, so that it can check for and move completed extracts from the root to the archive folder. By not relying on the TPP Gateway to move these files, this has reduced the process timeline by 24 hours. |
Fix/Enhancement | Implemented as to improve the time lag of data availability to the DDS and subsequent subscribers. TPP data is now made available to the DDS 24 hours earlier. |
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