Average Medicare Payment Measures

These measures describe the average total payments for a medical or surgical inpatient admission. The measures are separated by individual MS-DRG numbers and they can all be grouped under measure group id 56.

Queries

Acquiring data on CMS Average Total Payments

select a.* from entity_values as a, measure_groups_measures as b

where a.measure_id = b.measure_id

and a.entity_id = ######

and b.measure_group_id = 56

measure_id	drg	description_friendly	author_measure_id
14264	039	Average Total Payments for Extracranial procedures w/o CC/MCC	AVGtotPAYMENT_MSDRG_039
14265	057	Average Total Payments for Degenerative nervous system disorders w/o MCC	AVGtotPAYMENT_MSDRG_057
14266	064	Average Total Payments for Intracranial hemorrhage or cerebral infarction w MCC	AVGtotPAYMENT_MSDRG_064
14267	065	Average Total Payments for Intracranial hemorrhage or cerebral infarction w CC	AVGtotPAYMENT_MSDRG_065
14268	066	Average Total Payments for Intracranial hemorrhage or cerebral infarction w/o CC/MCC	AVGtotPAYMENT_MSDRG_066
14269	069	Average Total Payments for Transient ischemia	AVGtotPAYMENT_MSDRG_069
14270	074	Average Total Payments for Cranial & peripheral nerve disorders w/o MCC	AVGtotPAYMENT_MSDRG_074
14271	101	Average Total Payments for Seizures w/o MCC	AVGtotPAYMENT_MSDRG_101
14272	176	Average Total Payments for Pulmonary embolism w/o MCC	AVGtotPAYMENT_MSDRG_176
14273	177	Average Total Payments for Respiratory infections & inflammations w MCC	AVGtotPAYMENT_MSDRG_177
14274	178	Average Total Payments for Respiratory infections & inflammations w CC	AVGtotPAYMENT_MSDRG_178
14275	189	Average Total Payments for Pulmonary edema & respiratory failure	AVGtotPAYMENT_MSDRG_189
14276	190	Average Total Payments for Chronic obstructive pulmonary disease w MCC	AVGtotPAYMENT_MSDRG_190
14277	191	Average Total Payments for Chronic obstructive pulmonary disease w CC	AVGtotPAYMENT_MSDRG_191
14278	192	Average Total Payments for MS-DRG 192, Chronic Obstructive Pulmonary Disease without complications or comorbidities	AVGtotPAYMENT_MSDRG_192
14279	193	Average Total Payments for Simple pneumonia & pleurisy w MCC	AVGtotPAYMENT_MSDRG_193
14280	194	Average Total Payments for Simple pneumonia & pleurisy w CC	AVGtotPAYMENT_MSDRG_194
14281	195	Average Total Payments for MS-DRG 195, Pneumonia without complications or comorbidities	AVGtotPAYMENT_MSDRG_195
14282	202	Average Total Payments for Bronchitis & asthma w CC/MCC	AVGtotPAYMENT_MSDRG_202
14283	207	Average Total Payments for Respiratory system diagnosis w ventilator support 96+ hours	AVGtotPAYMENT_MSDRG_207
14284	208	Average Total Payments for Respiratory system diagnosis w ventilator support <96 hours	AVGtotPAYMENT_MSDRG_208
14285	238	Average Total Payments for Major cardiovasc procedures w/o MCC	AVGtotPAYMENT_MSDRG_238
14286	243	Average Total Payments for Permanent cardiac pacemaker implant w CC	AVGtotPAYMENT_MSDRG_243
14287	244	Average Total Payments for Permanent cardiac pacemaker implant w/o CC/MCC	AVGtotPAYMENT_MSDRG_244
14288	246	Average Total Payments for Perc cardiovasc proc w drug-eluting stent w MCC or 4+ vessels/stents	AVGtotPAYMENT_MSDRG_246
14289	247	Average Total Payments for Perc cardiovasc proc w drug-eluting stent w/o MCC	AVGtotPAYMENT_MSDRG_247
14290	249	Average Total Payments for Perc cardiovasc proc w non-drug-eluting stent w/o MCC	AVGtotPAYMENT_MSDRG_249
14291	251	Average Total Payments for Perc cardiovasc proc w/o coronary artery stent w/o MCC	AVGtotPAYMENT_MSDRG_251
14292	252	Average Total Payments for Other vascular procedures w MCC	AVGtotPAYMENT_MSDRG_252
14293	253	Average Total Payments for Other vascular procedures w CC	AVGtotPAYMENT_MSDRG_253
14294	254	Average Total Payments for Other vascular procedures w/o CC/MCC	AVGtotPAYMENT_MSDRG_254
14295	280	Average Total Payments for Acute myocardial infarction, discharged alive w MCC	AVGtotPAYMENT_MSDRG_280
14296	281	Average Total Payments for Acute myocardial infarction, discharged alive w CC	AVGtotPAYMENT_MSDRG_281
14297	282	Average Total Payments for Acute myocardial infarction, discharged alive w/o CC/MCC	AVGtotPAYMENT_MSDRG_282
14298	286	Average Total Payments for Circulatory disorders except AMI, w card cath w MCC	AVGtotPAYMENT_MSDRG_286
14299	287	Average Total Payments for Circulatory disorders except AMI, w card cath w/o MCC	AVGtotPAYMENT_MSDRG_287
14300	291	Average Total Payments for MS-DRG 291, Heart Failure with Multiple Complications	AVGtotPAYMENT_MSDRG_291
14301	292	Average Total Payments for MS-DRG 292, Heart Failure with Complications	AVGtotPAYMENT_MSDRG_292
14302	293	Average Total Payments for MS-DRG 293, Heart Failure without complications or comorbidities	AVGtotPAYMENT_MSDRG_293
14303	300	Average Total Payments for Peripheral vascular disorders w CC	AVGtotPAYMENT_MSDRG_300
14304	301	Average Total Payments for Peripheral vascular disorders w/o CC/MCC	AVGtotPAYMENT_MSDRG_301
14305	303	Average Total Payments for Atherosclerosis w/o MCC	AVGtotPAYMENT_MSDRG_303
14306	308	Average Total Payments for Cardiac arrhythmia & conduction disorders w MCC	AVGtotPAYMENT_MSDRG_308
14307	309	Average Total Payments for Cardiac arrhythmia & conduction disorders w CC	AVGtotPAYMENT_MSDRG_309
14308	310	Average Total Payments for Cardiac arrhythmia & conduction disorders w/o CC/MCC	AVGtotPAYMENT_MSDRG_310
14309	312	Average Total Payments for Syncope & collapse	AVGtotPAYMENT_MSDRG_312
14310	313	Average Total Payments for MS-DRG 313, Chest Pain without complications or comorbidities	AVGtotPAYMENT_MSDRG_313
14311	314	Average Total Payments for Other circulatory system diagnoses w MCC	AVGtotPAYMENT_MSDRG_314
14312	315	Average Total Payments for Other circulatory system diagnoses w CC	AVGtotPAYMENT_MSDRG_315
14313	329	Average Total Payments for Major small & large bowel procedures w MCC	AVGtotPAYMENT_MSDRG_329
14314	330	Average Total Payments for Major small & large bowel procedures w CC	AVGtotPAYMENT_MSDRG_330
14315	372	Average Total Payments for Major gastrointestinal disorders & peritoneal infections w CC	AVGtotPAYMENT_MSDRG_372
14316	377	Average Total Payments for G.I. hemorrhage w MCC	AVGtotPAYMENT_MSDRG_377
14317	378	Average Total Payments for G.I. hemorrhage w CC	AVGtotPAYMENT_MSDRG_378
14318	389	Average Total Payments for G.I. obstruction w CC	AVGtotPAYMENT_MSDRG_389
14319	390	Average Total Payments for G.I. obstruction w/o CC/MCC	AVGtotPAYMENT_MSDRG_390
14320	391	Average Total Payments for Esophagitis, gastroent & misc digest disorders w MCC	AVGtotPAYMENT_MSDRG_391
14321	392	Average Total Payments for MS-DRG 392, Digestive Disorders	AVGtotPAYMENT_MSDRG_392
14322	394	Average Total Payments for Other digestive system diagnoses w CC	AVGtotPAYMENT_MSDRG_394
14323	418	Average Total Payments for Laparoscopic cholecystectomy w/o c.d.e. w CC	AVGtotPAYMENT_MSDRG_418
14324	419	Average Total Payments for MS-DRG 419, Gallbladder Removal By Laparoscope without complications or comorbidities	AVGtotPAYMENT_MSDRG_419
14325	460	Average Total Payments for Spinal fusion except cervical w/o MCC	AVGtotPAYMENT_MSDRG_460
14326	469	Average Total Payments for Major joint replacement or reattachment of lower extremity w MCC	AVGtotPAYMENT_MSDRG_469
14327	470	Average Total Payments for MS-DRG 470, Major Joint Replacement	AVGtotPAYMENT_MSDRG_470
14328	473	Average Total Payments for Cervical spinal fusion w/o CC/MCC	AVGtotPAYMENT_MSDRG_473
14329	480	Average Total Payments for Hip & femur procedures except major joint w MCC	AVGtotPAYMENT_MSDRG_480
14330	481	Average Total Payments for Hip & femur procedures except major joint w CC	AVGtotPAYMENT_MSDRG_481
14331	491	Average Total Payments for Back & neck proc exc spinal fusion w/o CC/MCC	AVGtotPAYMENT_MSDRG_491
14332	552	Average Total Payments for Medical back problems w/o MCC	AVGtotPAYMENT_MSDRG_552
14333	602	Average Total Payments for Cellulitis w MCC	AVGtotPAYMENT_MSDRG_602
14334	603	Average Total Payments for MS-DRG 603, Cellulitis w/o MCC	AVGtotPAYMENT_MSDRG_603
14335	638	Average Total Payments for Diabetes w CC	AVGtotPAYMENT_MSDRG_638
14336	640	Average Total Payments for Nutritional & misc metabolic disorders w MCC	AVGtotPAYMENT_MSDRG_640
14337	641	Average Total Payments for MS-DRG 641, Metabolic Disorders	AVGtotPAYMENT_MSDRG_641
14338	682	Average Total Payments for Renal failure w MCC	AVGtotPAYMENT_MSDRG_682
14339	683	Average Total Payments for Renal failure w CC	AVGtotPAYMENT_MSDRG_683
14340	684	Average Total Payments for Renal failure w/o CC/MCC	AVGtotPAYMENT_MSDRG_684
14341	689	Average Total Payments for Kidney & urinary tract infections w MCC	AVGtotPAYMENT_MSDRG_689
14342	690	Average Total Payments for MS-DRG 690, Urinary Tract Infections	AVGtotPAYMENT_MSDRG_690
14343	698	Average Total Payments for Other kidney & urinary tract diagnoses w MCC	AVGtotPAYMENT_MSDRG_698
14344	699	Average Total Payments for Other kidney & urinary tract diagnoses w CC	AVGtotPAYMENT_MSDRG_699
14345	811	Average Total Payments for Red blood cell disorders w MCC	AVGtotPAYMENT_MSDRG_811
14346	812	Average Total Payments for Red blood cell disorders w/o MCC	AVGtotPAYMENT_MSDRG_812
14347	853	Average Total Payments for Infectious & parasitic diseases w O.R. procedure w MCC	AVGtotPAYMENT_MSDRG_853
14348	870	Average Total Payments for Septicemia or severe sepsis w MV 96+ hours	AVGtotPAYMENT_MSDRG_870
14349	871	Average Total Payments for MS-DRG 871, Septicemia with Multiple Complications	AVGtotPAYMENT_MSDRG_871
14350	872	Average Total Payments for Septicemia or severe sepsis w/o MV 96+ hours w/o MCC	AVGtotPAYMENT_MSDRG_872
14351	885	Average Total Payments for MS-DRG 885, Psychoses	AVGtotPAYMENT_MSDRG_885
14352	897	Average Total Payments for MS-DRG 897, Alcohol/Drug Abuse	AVGtotPAYMENT_MSDRG_897
14353	917	Average Total Payments for Poisoning & toxic effects of drugs w MCC	AVGtotPAYMENT_MSDRG_917
14354	918	Average Total Payments for Poisoning & toxic effects of drugs w/o MCC	AVGtotPAYMENT_MSDRG_918
14355	948	Average Total Payments for Signs & symptoms w/o MCC	AVGtotPAYMENT_MSDRG_948
14356	439	Average Total Payments for Disorders of pancreas except malignancy w CC	AVGtotPAYMENT_MSDRG_439
14357	203	Average Total Payments for MS-DRG 203, Bronchitis and Asthma without complications or comorbidities	AVGtotPAYMENT_MSDRG_203
14358	379	Average Total Payments for G.I. hemorrhage w/o CC/MCC	AVGtotPAYMENT_MSDRG_379
14359	563	Average Total Payments for Fx, sprn, strn & disl except femur, hip, pelvis & thigh w/o MCC	AVGtotPAYMENT_MSDRG_563
14360	482	Average Total Payments for Hip & femur procedures except major joint w/o CC/MCC	AVGtotPAYMENT_MSDRG_482
14361	536	Average Total Payments for Fractures of hip & pelvis w/o MCC	AVGtotPAYMENT_MSDRG_536
14362	305	Average Total Payments for Hypertension w/o MCC	AVGtotPAYMENT_MSDRG_305
14363	149	Average Total Payments for Dysequilibrium	AVGtotPAYMENT_MSDRG_149

Pellucid

Average Medicare Payment Measures

Analytics

Queries

Related content