These measures describe the average total payments for a procedure. 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 DRG 192, bstructive 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 DRG 195, 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 DRG 291, lure 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 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. | AVGtotPAYMENT_MSDRG_292 |
| 14302 | 293 | Average Total Payments for DRG 293, lure 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 DRG 313, n 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 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. | 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 DRG 419, er 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 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. | 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. | 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 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. | 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 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. | 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 DRG 871, a 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. | AVGtotPAYMENT_MSDRG_885 |
| 14352 | 897 | Average Total Payments for 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. | 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 DRG 203, s 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 |