Page Comparison

These measures describe the average total payments for a procedurea 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, bstructive Chronic Obstructive Pulmonary Disease without complications or comorbidities (MS-DRG 192). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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 (MS-DRG 195). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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, lure Heart Failure with Multiple Complications (MS-DRG 291). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	AVGtotPAYMENT_MSDRG_291
14301	292	Average Total Payments for MS-DRG 292, lure with Complications (MS-DRG 292). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.Heart Failure with Complications	AVGtotPAYMENT_MSDRG_292
14302	293	Average Total Payments for MS-DRG 293, lure Heart Failure without complications or comorbidities (MS-DRG 293). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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, n Chest Pain without complications or comorbidities (MS-DRG 313). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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, Disorders (MS-DRG 392). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.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, er Gallbladder Removal By Laparoscope without complications or comorbidities (MS-DRG 419). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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, nt Replacement (MS-DRG 470). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.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 DRG 603, s ( MS-DRG 603). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees., 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, Disorders (MS-DRG 641). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.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, ract Infections (MS-DRG 690). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.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, a Septicemia with Multiple Complications (MS-DRG 871). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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 DRG 885, ( MS-DRG 885). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees., Psychoses	AVGtotPAYMENT_MSDRG_885
14352	897	Average Total Payments for MS-DRG 897, rug Abuse (MS-DRG 897). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.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, s Bronchitis and Asthma without complications or comorbidities (MS-DRG 203). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.	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