Overview

Tip: First Time Users - It is recommended that you visit MU: Introduction to Determining Medicaid Volume using the OP Software for a step-by-step process to determine how to best configure your Meaningful Use Volume to match the State Group SQL selections in the table below.

The State Group SQL table provides you with a list of States and the associated attestation links to SQL reports that you can run to obtain provider attestation results.

Note: There is only one level of security in Database Viewer. That level of security is permission access. A staff member who has access to the Database Viewer can theoretically run any report that contains any data. This includes data concerning medications, diagnoses, lab results, and other sensitive areas of a patient's chart. Therefore, your practice should limit Database Viewer/SQL access only to individuals at your practice who would normally have access to this information. You will need to have the proper access to utilize your OP Database Viewer in order to utilize the SQL codes in this library. See Providing Access in OP Database Viewer Basics for more information.

For brief instructions and an animated image on how to quickly clip and save SQL code, click here.

Note: The Database Viewer accesses the same database as the OP software. If you run a query that filters a lot of data, your database could become sluggish and affect your users. It is recommended to run queries during hours when users are not running the OP software.

The Database Viewer is a powerful tool for aggregating data into a single file, which can prove to be a double-edged sword if placed in the wrong hands. This is even more relevant if your practice does not follow other best practices. For example, a practice may store unencrypted credit card numbers in the Patient Register. That is an ill-advised risk. The reason it is a risk is because the Database Viewer makes it very easy to download all of those credit card numbers into a single Excel file if using the proper SQL code. So, please only grant individuals at your practice the use of this powerful tool if they would normally have access to that sensitive information.

State Group SQL Table

Please visit State Assumptions to find the logic behind each grouping. It is each practice’s responsibility to confirm with your state’s Medicaid agency that the assumptions made are current for the reporting year as of the date of the practice’s attestation. Export, save, and print all results for audit purposes at the time you run them for actual volume validation.

Note: To quickly find the form you want in this table:

Filter: Enter your full state name into the filter bar. As you enter characters in the filter bar, the rows not containing those characters will become hidden. The visible rows display are based upon the characters in the row that match the characters in the filter bar. The more characters you enter, the more the table will be filtered. Please use correct spelling. Avoid state abbreviations.
Sort: You can sort A - Z and Z - A by clicking on a column header.

Java must be enabled in order to use the search and sort capability. Otherwise, just scroll through the table to find your state.

Group	State	SQL Code Attestation Type	Variable Note
Group 1	Alabama	Individual
Group 1	Alabama	Group
Group 1	Alabama	Drill Down
Group 1	Alaska	Individual
Group 1	Alaska	Group
Group 1	Alaska	Drill Down
Group 1	Arizona	Individual
Group 1	Arizona	Group
Group 1	Arizona	Drill Down
Group 1	Arkansas	Individual
Group 1	Arkansas	Group
Group 1	Arkansas	Drill Down
Group 1	California	Individual
Group 1	California	Group
Group 1	California	Drill Down
Group 1	Colorado	Individual
Group 1	Colorado	Group
Group 1	Colorado	Drill Down
Group 1	Connecticut	Individual
Group 1	Connecticut	Group
Group 1	Connecticut	Drill Down
Group 1	Washington DC	Individual
Group 1	Washington DC	Group
Group 1	Washington DC	Drill Down
Group 1	Delaware	Individual
Group 1	Delaware	Group
Group 1	Delaware	Drill Down
Group 1	Florida	Individual
Group 1	Florida	Group
Group 1	Florida	Drill Down
Group 1	Hawaii	Individual
Group 1	Hawaii	Group
Group 1	Hawaii	Drill Down
Group 1	Idaho	Individual
Group 1	Idaho	Group
Group 1	Idaho	Drill Down
Group 1	Iowa	Individual
Group 1	Iowa	Group
Group 1	Iowa	Drill Down
Group 1	Kansas	Individual
Group 1	Kansas	Group
Group 1	Kansas	Drill Down
Group 1	Kentucky	Individual
Group 1	Kentucky	Group
Group 1	Kentucky	Drill Down
Group 1	Maine	Individual
Group 1	Maine	Group
Group 1	Maine	Drill Down
Group 1	Michigan	Individual
Group 1	Michigan	Group
Group 1	Michigan	Drill Down
Group 1	Minnesota	Individual
Group 1	Minnesota	Group
Group 1	Minnesota	Drill Down
Group 1	Mississippi	Individual
Group 1	Mississippi	Group
Group 1	Mississippi	Drill Down
Group 1	Missouri	Individual
Group 1	Missouri	Group
Group 1	Missouri	Drill Down
Group 1	Nebraska	Individual
Group 1	Nebraska	Group
Group 1	Nebraska	Drill Down
Group 1	Nevada	Individual
Group 1	Nevada	Group
Group 1	Nevada	Drill Down
Group 1	New Hampshire	Individual
Group 1	New Hampshire	Group
Group 1	New Hampshire	Drill Down
Group 1	New York	Individual
Group 1	New York	Group
Group 1	New York	Drill Down
Group 1	North Carolina	Individual
Group 1	North Carolina	Group
Group 1	North Carolina	Drill Down
Group 1	North Dakota	Individual
Group 1	North Dakota	Group
Group 1	North Dakota	Drill Down
Group 1	Ohio	Individual
Group 1	Ohio	Group
Group 1	Ohio	Drill Down
Group 1	Oklahoma	Individual
Group 1	Oklahoma	Group
Group 1	Oklahoma	Drill Down
Group 1	Pennsylvania	Individual
Group 1	Pennsylvania	Group
Group 1	Pennsylvania	Drill Down
Group 1	Rhode Island	Individual
Group 1	Rhode Island	Group
Group 1	Rhode Island	Drill Down
Group 1	South Carolina	Individual
Group 1	South Carolina	Group
Group 1	South Carolina	Drill Down
Group 1	Tennessee	Individual
Group 1	Tennessee	Group
Group 1	Tennessee	Drill Down
Group 1	Texas	Individual
Group 1	Texas	Group
Group 1	Texas	Drill Down
Group 1	Utah	Individual
Group 1	Utah	Group
Group 1	Utah	Drill Down
Group 1	Vermont	Individual
Group 1	Vermont	Group
Group 1	Vermont	Drill Down
Group 1	Wyoming	Individual
Group 1	Wyoming	Group
Group 1	Wyoming	Drill Down
Group 2	Georgia	Individual	Depends on county and provider type
Group 2	Georgia	Group	Depends on county and provider type
Group 2	Georgia	Drill Down	Depends on county and provider type
Group 2	Indiana	Individual	2.52%
Group 2	Indiana	Group	2.52%
Group 2	Indiana	Drill Down	2.52%
Group 2	Massachusetts	Individual	Look up in attestation tool
Group 2	Massachusetts	Group	Look up in attestation tool
Group 2	Massachusetts	Drill Down	Look up in attestation tool
Group 2	New Jersey	Individual	Different for each attesting NPI
Group 2	New Jersey	Group	Different for each attesting NPI
Group 2	New Jersey	Drill Down	Different for each attesting NPI
Group 2	New Mexico	Individual	Depends on county
Group 2	New Mexico	Group	Depends on county
Group 2	New Mexico	Drill Down	Depends on county
Group 2	Oregon	Individual	4.40%
Group 2	Oregon	Group	4.40%
Group 2	Oregon	Drill Down	4.40%
Group 2	Washington	Individual	5%
Group 2	Washington	Group	5%
Group 2	Washington	Drill Down	5%
Group 2	Wisconsin	Individual	Changes annually
Group 2	Wisconsin	Group	Changes annually
Group 2	Wisconsin	Drill Down	Changes annually
Group 3	Louisiana	Individual
Group 3	Louisiana	Group
Group 3	Louisiana	Drill Down
Group 3	Maryland	Individual
Group 3	Maryland	Group
Group 3	Maryland	Drill Down
Group 3	South Dakota	Individual
Group 3	South Dakota	Group
Group 3	South Dakota	Drill Down
Group 4	Illinois	Individual
Group 4	Illinois	Group
Group 4	Illinois	Drill Down
Group 4	West Virginia	Individual
Group 4	West Virginia	Group
Group 4	West Virginia	Drill Down
Group 5	Montana	See Note in next column	Please contact your state Medicaid office to determine its rules. Also, if you can share your findings with us,we can help you find the correct attestation report(s).
Group 5	Virginia	See Note in next column	Please contact your state Medicaid office to determine its rules. Also, if you can share your findings with us,we can help you find the correct attestation report(s).

MU: State Group SQL Table function sendEmail() {var title = 'MU: State Group SQL Table'.replace("'","\'").replace("'", "\'");window.location = 'mailto:?subject=' + title + '&body=' + window.location;} Link copied!

Overview

State Group SQL Table

Related Articles

MU: State Group SQL Table
Link copied!