These measures describe the charge and length of stay averages for the state. The measures are separated by individual MS-DRG numbers and they can all be grouped under measure group id 149.
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.
- Median Charge Measures
- Average Length of Stay Measures
- Median Length of Stay Measures
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)