Remote Subscriber Database (RSD) SQL guide (Compass 1)

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.