Raw Population Data Report

For offices utilizing Public Health features, the Raw Population Data report produces a list of patients who had treatment during a specific date range.

In Standard Reports, in the Public Health area, click Raw Population Data.

This report is for offices utilizing Public Health. It produces a list of patients who had treatment during a specific date range. The resulting data is presented as a single table, with each patient shown on one row.

Filters

Set the report filters before running the report.

Calendar: Select the date range to include in the report. Select the start date in the left calendar and the end date on the right calendar. Filters by patients with completed procedures in the date range.

Adjustments types for broken appointments: Select the Broken Appointmentadjustment type used by the practice. Ctrl + click to select multiple select multiple types. At least one must be selected. This will be used to calculated NumberBroken on the report and will also include patients who had a broken appointment, even if there were no completed procedures in the date range.

Report Query

After setting the report criteria, click OK to see generate the results in the User Query window.

Below is an example of the report and explanation of the report columns.

The data is intended to be saved to a text file and sent to a centralized office where it gets loaded into one larger table containing data from many locations. For instance, all data for an entire state could be sent to a central office once per month. The data format makes it easy to automate grouping and reporting.