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.
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)