Remote Subscriber Database (RSD) SQL guide (Compass 1): Difference between revisions
From Voror_Wiki
(Created page with " = Introduction = This outlines the steps we take to create the patient selection for analysis from the Discovery database. To add this data to a report, we create datasets....") |
No edit summary |
||
| Line 5: | Line 5: | ||
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. | |||
[[File:Dataset algorithm.jpg|600x600px|The algorithm followed to generate datasets]] | [[File:Dataset algorithm.jpg|600x600px|The algorithm followed to generate datasets]] | ||
= 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. | |||
== General Patient Cohort Fig 2.1 Entity diagram showing the relationships between patient and organization == | |||
| |||
| | ||
Revision as of 13:26, 1 May 2020
Introduction
This outlines the steps we take to create the patient selection for analysis 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.
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.
General Patient Cohort Fig 2.1 Entity diagram showing the relationships between patient and organization