Page History

...

For example, assume you want to generate a report the shows patient discharge data. You select the Patient Data table and the ADT Data table, which contains admit and discharge data., as shown in the image below:

Image Added 

1. Select each category you want to include from the Topics field. Tables within the category load in the Tables field.
2. Select the tables that contain the data you want to include in your report, and then click the arrow button to move them to the Selected Tables field.
3. After you move the tables containing the data to the Selected Tables field, click Show Fields to load the fields in the selected tables. The fields do not load in the current page; you must select Next to see the fields.
4. Click Next to see the fields in the Matching page.

...

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 Added

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

When you match fields, you specify how they relate to one another. In SQL terminology, you are performing a JOIN operation to combine data from two or more tables based on a common field. 

...

Select the fields you want to include in your report. The data is displayed in the report data based on the order of fields in the right column.
The label for a field is shown as the column header in the report. You can change the column header to a more readable name. For example, you can change pid to Patient ID., as shown in the image below:

Image Added

1. Select the fields you want to include in your report. Use the arrow keys to move fields into the right column.
2. Select a field, and then use the Up and Down keys to set the order.
3. Double click a field to add a display name to use as column header in report.
4. Enter the column name in Display Text dialog, and then click Change.
5. Click Next.

...

The report generator provides you with predefined filters that you can apply to table fields to refine results. For example, you might decide to use the Date Range filter, which adds a To and From filter to the report, to filter results retrieved from the adt_data.discharge field based on dates. , as shown in the image below:

Image Added

Filters you add appear at the top of the report.For  For best performance, do not include more than three filters in your report.

...

1. Select a field to filter on.
2. Select the operator to apply. 
3. Specify the text or number string to match, or click the calendar icon to specify a date.
4. Click Add.
5. Select AND or OR to include another filter.
6. Click Next.

The below image illustrates the example:

Image Added

Group Data

You can group common data together to limit data included in your report. For example, assume that you want to group all of the data for a single facility together in the report, rather than show multiple entries for the facility.

...

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.

...