Update Rule's Code for 2016 measures

[leebc]

Update Rule's Code for 2016 measures.

[leebc]

From Lana: 2016 PQRS Individual Measures Supported by SuncoastRHIO PQRS Registry No longer in use for 2016: Measures # 33, 40, 81, 82, 163, 172, 173, 193, 194 and 349

1, 5, 6, 7, 8, 12, 14, 19, 21, 22, 23, 24, 32, 39, 41, 43, 44, 46, 47, 48, 50, 51, 52, 53, 54, 65, 66, 67, 68, 69, 70, 71, 72, 76, 91, 93, 99, 100, 102, 104, 109, 110, 111, 112, 113, 116, 117, 118, 119, 121, 122, 126, 127, 128, 130, 131, 134, 137, 138, 140, 141, 143, 144, 145, 146, 147, 154, 155, 156, 164, 178, 181, 182, 185, 187, 191, 192, 195, 204, 205, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 236, 238, 243, 249, 250, 251, 254, 255, 257, 258, 259, 260, 261, 262, 263, 264, 265, 268, 270, 271, 274, 275, 303, 304, 317, 320, 322, 323, 324, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 342, 343, 344, 345, 346, 347, 348, 358, 370, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402,

New Measures for 2016: 403, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434, 435, 436, 437, 438, 439 Total 198 Individual Measures

2016 Measures Groups Supported by SuncoastRHIO PQRS Registry The Measures Supported in Each Measures Group Acute Otitis Externa (AOE): 91, 93, 130, 131, 154, 155, 226, 317

Asthma: 53, 110, 128, 130, 226, 402

(NEW!) Cardiovascular Prevention: 130, 204, 226, 236, 317, 438

Cataracts: 130, 191, 192, 226, 303, 304, 388, 389

Chronic Kidney Disease (CKD): 47, 110, 121, 122, 130, 226

Chronic Obstructive Pulmonary Disease (COPD): 47, 51, 52, 110, 111, 130, 226

Coronary Artery Bypass Graft (CABG): 43, 44, 164, 165, 166, 167, 168

Coronary Artery Disease (CAD): 6, 7, 128, 130, 226, 242

Dementia: 47, 134, 280, 281, 282, 283, 284, 286, 287, 288 (#285 was a “Measures Group Only” measure, but has now been retired from Measures Groups, replaced by #134)

Diabetes: 1, 110, 117, 119, 126, 226 (#163 retired, replaced by #126)

(NEW!) Diabetic Retinopathy: 1, 18, 19, 117, 130, 226, 317

General Surgery: 130, 226, 354, 355, 356, 357, 358

Heart Failure (HF): 5, 8, 47, 110, 130, 226

Hepatitis C: 84, 85, 87, 130, 183, 226, 390, 401

HIV/AIDS: 47, 134, 160, 205, 226, 338, 339, 340

Inflammatory Bowel Disease (IBD): 110, 111, 226, 270, 271, 274, 275

(NEW!) Multiple Chronic Conditions: 47, 110, 128, 130, 131, 134, 154, 155, 238

Oncology: 71, 72, 110, 130, 143, 144, 226

Optimizing Patient Exposure to Ionizing Radiation (OPEIR): 359, 360, 361, 362, 363, 364

Parkinson’s Disease: 47, 289, 290, 291, 292, 293, 294

Preventive Care: 39, 48, 110, 111, 112, 113, 128, 134, 226, 431 (#173 retired, replaced by #431)

Rheumatoid Arthritis (RA): 108, 128, 131, 176, 177, 178, 179, 180, 337 (#337 has been added)

Sinusitis: 130, 131, 226, 331, 332, 333

Sleep Apnea: 128, 130, 226, 276, 277, 278, 279

Total Knee Replacement (TKR): 130, 226, 350, 351, 352, 353

Total 25 Measures Groups

[leebc]

These measures should be completed first--

Suncoast RHIO's Most Commonly Used PQRS Measures in 2015

1, 5, 6, 8, 21, 22, 23, 32, 47, 48, 50, 51, 52, 54, 109, 110, 111, 113,
116, 117, 119, 121, 122, 126, 127, 128, 130, 131, 134, 143, 144, 145, 146,
156, 163, 182, 185, 187, 204, 225, 226, 238, 265, 274,275, 317, 320, 322,
323, 324, 325, 326, 331, 333, 334, 343, 358

[leebc]

I have added skeletons where needed and removed retired rules. Let me know if you run into a problem with something missing, but I think I got them all.

[leebc]

There appears to be something wrong with the queries for PQRS_0007, it runs, uses 100%CPU, and never quits. Reviewing the SQL query, this does not seem to me like a super complex query.

[aethelwulffe]

Double denominator with in-line code. I am tweaking it now.

On 2016-08-18 05:46 PM, leebc wrote:

There appears to be something wrong with the queries for PQRS_0007, it runs, uses 100%CPU, and never quits. Reviewing the SQL query, this does not seem to me like a super complex query.

— You are receiving this because you were assigned. Reply to this email directly, view it on GitHub https://github.com/SunCoastConnection/PQRS_Gateway/issues/13#issuecomment-240867390, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzF_2NPIY0DUwvgNko5YW-hUAcNrhwks5qhNLIgaJpZM4JdIRN.

[leebc]

@aethelwulffe if you can show me how to modify the queries to use a variable for the reporting period (year), I can try to go through and modify them.

[aethelwulffe]

" AND YEAR(fe.date) =? ". in the queries vs.

" AND YEAR(fe.date) ='2016' ".

$result = sqlFetchArray(sqlStatementNoLog($query, array($patient->id), $beginDate));

...unless we are looking for a date range from $beginDate and $endDate...

" AND fe.date >= ? ".

" AND fe.date <=? ".

...with...

$result = sqlFetchArray(sqlStatementNoLog($query, array($patient->id),$beginDate, $endDate));

This is assuming that the dates are simple variables, not arrays, and are being passed to this function. If you can log the echo of those two variables and make sure they are valid dates, then the above should work. I am pretty sure the php binding will work that way.

On 2016-09-02 08:06 AM, leebc wrote:

@aethelwulffe https://github.com/aethelwulffe if you can show me how to modify the queries to use a variable for the reporting period (year), I can try to go through and modify them.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/SunCoastConnection/PQRS_Gateway/issues/13#issuecomment-244357144, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzF5fHzmFN9w7e5NLaLKofV5uNoEt-ks5qmBFJgaJpZM4JdIRN.

[aethelwulffe]

Tell you what: If you are doing this, then I will hang for a bit until you can verify success (or get help from me to do so) before I push my rule modifications. That way I can play the changes on top of this across-the-board commit.

[leebc]

If you're ready to work on the queries, go ahead. I was just trying to find something I could work on that wouldn't have a huge learning curve.

[leebc]

Individual rule PQRS_0325 takes a very long time to run. Pegs mysqld at 99% for 45+ minutes. This measure is Age AND Diagnosis1 AND Encounter AND Pick Diagnosis from one of these codes. I think the code table I'm running against still has the ICD9 codes too, so that may be part of the problem.

[aethelwulffe]

45 minutes sound Waaay too long. A and B are not very many codes. C is about 320 codes with no ICD9 in it.

On 2016-09-02 01:16 PM, leebc wrote:

Individual rule PQRS_0325 takes a very long time to run. Pegs mysqld at 99% for 45+ minutes. This measure is Age AND Diagnosis1 AND Encounter AND Pick Diagnosis from one of these codes. I think the code table I'm running against still has the ICD9 codes too, so that may be part of the problem.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/SunCoastConnection/PQRS_Gateway/issues/13#issuecomment-244435084, or mute the thread https://github.com/notifications/unsubscribe-auth/AAhzF88WpYOy8bTzx-gHLVmHrLcb6TRlks5qmFnhgaJpZM4JdIRN.

[leebc]

Nevermind. The problem was a low timeout in /etc/php5/apache2/php.ini

[leebc]

@aethelwulffe : I've gone through measure queries and modified with the date changes as above.
I was about to make a pull request, but want to try to test it before committing to main and production.
Can just go ahead and proceed with out worrying separate about testing if you're ready to look at the queries.

[leebc]

Need code and query for PQRS_Group_Diabetes_0163, which was added for 2016.

[leebc]

Please work on Diabetes Measure 126 and Individual Measure 431 next in this task.

431 is new, and 126 is new to the Diabetes Group, so queries have not been written for these, they return 0 results. Preminger and Chang/Endocrine want to use these measures.

[aethelwulffe]

On it...err...actually I have alredy been there

[leebc]

:+1:

[aethelwulffe]

Started sequential check on all measures. Starting over, pulling all numerator exclusions out and placing them in the exclusion classes.

[leebc]

Calling this complete. There are additional measures being reviewed in #121 for slowness and some that were skipped int he review and that additional issues have been created for complete review and WTF.