Existing Open Dental customers can run queries to determine eligibility for the EHR Incentive Program or to provide supporting documentation during EHR Attestation for an incentive payment. See Query Favorites.
The queries below can be found be found on the Query Examples page.
To run a query, copy the query text (Ctrl + C), then paste it into the Query window. You may need to change information such as date range, NPI number, carrier, etc. It may be useful to export query results to Excel so you can format the results the way you want.
Hint: To add identifying header information to query results, first save the query to your Query Favorites, then enter a Title that includes all identifying information (e.g. title, date ranges, provider). Then run the query again. If you change report criteria, make sure to change the query's title also.
Percentage of patient encounters by insurance carrier, for a date range, by NPI. Use to determine Medicaid patient volume for a specific time frame. The percentage may add up to over 100% if a single patient has multiple carriers on the same day of service.
Percentage of patient encounters by insurance carrier, for a date range, for all providers. Use to determine Medicaid patient volume for a specific time frame. The percentage may add up to over 100% if a single patient was seen by multiple carriers on the same day of service.
For providers who had a recent data conversion. Percentage of patient encounters by insurance carrier, for a date range, for all providers. Use to determine Medicaid patient volume for a specific time frame. The percentage may add up to over 100% if a single patient was seen by multiple carriers on the same day of service.
Claim details for a date range, by NPI. Use with a Percentage of Patient Encounters query to see patient claim information.
Claim details for a date range for all providers. Use with a Percentage of Patient Encounters query to see patient claim information.
For providers who had a recent data conversion. Claim details for a date range, for all providers. Use with a Percentage of Patient Encounters after a Conversion query to see patient claim information.
For EHR providers who must provide supporting documentation for patient volume when attesting with Texas Medicaid.
