Remote Subscriber Database (RSD) SQL guide (Compass 1)
Jump to navigation
Jump to search
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