Remote Subscriber Database (RSD) SQL guide (Compass 1): Difference between revisions

From Discovery Data Service
Jump to navigation Jump to search
No edit summary
No edit summary
Line 2: Line 2:
= Introduction =
= Introduction =


This outlines the steps we take to create the patient selection for analysis from the Discovery database.
This article decribes the steps we take to create, and analyse, patient data selections from the Discovery database.


To add this data to a report, we create datasets. Each dataset represents the result set from running a combination of SQL commands and stored procedures on a data source.
To add this data to a report, we create datasets. Each dataset represents the result set from running a combination of SQL commands and stored procedures on a data source.


The following diagram shows the algorithm that is followed to generate these datasets.
The following diagram shows the algorithm that is followed to generate these datasets:


[[File:Dataset algorithm.jpg|600x600px|The algorithm followed to generate datasets]]
[[File:Dataset algorithm.jpg|600x600px|The algorithm followed to generate datasets]]
Line 12: Line 12:
= Creating the Patient Cohort =
= Creating the Patient Cohort =


This is the first step when we receive a list of patients marked for observational study. This comes into LHS usually in the form of pseudonymised personal data. Using the pseudo identifier or the pseudo NHS identifier we can obtain additional information about the patient from our Discovery database.
The first step, when we receive a list of patients marked for observational study, is to create a patient cohort. Patient data comes usually comes into the DDS in the form of pseudonymised personal data. Using the pseudo identifier or the pseudo NHS identifier we can obtain additional information about the patient from the Discovery database.


== General Patient Cohort Fig 2.1 Entity diagram showing the relationships between patient and organization ==
The following entity diagram shows the relationships between patient and organisation:


 
[[File:Genral patient cohort.jpg|RTENOTITLE]]
 
We link the patients to the Discovery database by using their pseudo identifiers. However, if only the pseudo NHS numbers are provided then we can derive the corresponding pseudo identifiers from the Link Distributor table. We filter the patients by their organisation ODS codes to ensure only patients of the required GP practices are selected


 
 

Revision as of 14:35, 1 May 2020

Introduction

This article decribes the steps we take to create, and analyse, patient data selections from the Discovery database.

To add this data to a report, we create datasets. Each dataset represents the result set from running a combination of SQL commands and stored procedures on a data source.

The following diagram shows the algorithm that is followed to generate these datasets:

The algorithm followed to generate datasets

Creating the Patient Cohort

The first step, when we receive a list of patients marked for observational study, is to create a patient cohort. Patient data comes usually comes into the DDS in the form of pseudonymised personal data. Using the pseudo identifier or the pseudo NHS identifier we can obtain additional information about the patient from the Discovery database.

The following entity diagram shows the relationships between patient and organisation:

RTENOTITLE

We link the patients to the Discovery database by using their pseudo identifiers. However, if only the pseudo NHS numbers are provided then we can derive the corresponding pseudo identifiers from the Link Distributor table. We filter the patients by their organisation ODS codes to ensure only patients of the required GP practices are selected

 

Retrieved from ‘https://wiki.discoverydataservice.org/index.php?title=Remote_Subscriber_Database_(RSD)_SQL_guide_(Compass_1)&oldid=175’