Page History

...

The report is based on patients, so you match fields that contain common data in both tables. Because both tables contain patient ID, you match the field containing the patient ID in the Patients table (patient_data.pid) with the patient ID field in the ADT table (adt_data.pid), as shown in the image below:

Image Modified

In database terminology, you are matching the primary key in one table (Patients) with a foreign key in the other table (ADT).

...

Anchor
#customQuery #customQuery

Create Your Own SQL Query

When you create a report using the DrCloudEHR report generator, you create are actually creating a SQL query that retrieves the data you want to include from the DrCloudEHR database. However, if you have the skills and have knowledge of the database schema, you can create your own SELECT query directly, instead of using the report generator.

...