EHR Eligibility Queries

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.

• Percentage of Patient Encounters Queries. These queries give a percentage of patient encounters by insurance carrier, for a date range. Use to determine Medicaid patient volume for a specific time frame.
  • Percentage of Patient Encounters, by NPI (for a specific provider)
  • Percentage of Patient Encounters for all Providers
  • Percentage of Patient Encounters Recent Conversion (for all providers after a recent data conversion)
• Claim Detail Queries. These reports give claim details for a date range. Use with a Percentage of Patient Encounters query to see patient claim information.
  • Claim Details by NPI (for a specific provider)
  • Claim Details for all Providers
  • Claim Details Recent Conversion (for all providers after a recent data conversion)
• Texas Medicaid Patient Volume Query. For EHR providers who must provide supporting documentation for patient volume when attesting with Texas Medicaid.
  • EHR Texas Medicaid Patient Volume

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.

1. Percentage of Patient Encounters, by NPI: # 973
   

   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.

2. Percentage of Patient Encounters for all Providers: # 974
   

   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.

3. Percentage of Patient Encounters - Recent Conversion: #975
   

   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.

4. Claim Details by NPI: # 976
   

   Claim details for a date range, by NPI. Use with a Percentage of Patient Encounters query to see patient claim information.

5. Claim Details for all Providers: #977
   

   Claim details for a date range for all providers. Use with a Percentage of Patient Encounters query to see patient claim information.

6. Claim Details - Recent Conversion: #978
   

   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.

7. Texas Medicaid Patient Volume Query: #979
   

   For EHR providers who must provide supporting documentation for patient volume when attesting with Texas Medicaid.