All-payer Charges and Length of Stay (Hospital) (MS-DRG)

Owned by Alex Laird (Unlicensed)
Last updated: Oct 30, 2014 by Joseph Gulotta

These measures describe the charge and length of stay averages for the state. The measures are separated by individual MS-DRG numbers.

If total charge was excessively low (total charges < $0) or high ( > $1 million), then the sample was excluded from the median/mean calculation.

If length of stay was excessively high (> 365 days), then the sample was excluded from the median/mean calculation.

In samples where the length of stay was excluded, so was the total charge.

In samples where the total charge was excluded, so was the length of stay.

 

 

Queries

Acquiring data on Median Charges

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 = 14


Acquiring data on both Median Length of Stay

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 = 15


Acquiring data on both Median LOS and Median Charges

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 in (14,15)