Inpatient Hospital Discharge Query Module Configuration Selection

Overview

Overview

Click on either the Quick Selection or Advanced Selection bar to see a list of measures available. Use the hierarchical folder tree to navigate to the query module that will meet your needs. To see folder contents, click on the folder icon. Clicking on the folder again will hide the menu folder contents. When you click on the text link, it will take you to the query module. For further explanation on the modules, click on the "Help" button to the right.
Quick Selection (Click here for most commonly used measures)

Select measure to query by County and Local Health District. For Small Areas and maps use the Advanced Selection below. 

Hospital Discharges
Hospital Charges

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Sum of Charges or Length of Stay

Sum of Charges (sum):Sum of all hospital charges for selected inpatient hospitalizations or ED encounters.

Total Length of Stay (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.
Total Charges (sum)

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Average Charges or Average Length of Stay

Average Charges: Sum of total charges divided by number of releases or encounters.

Average Length of Stay: Average number of days each individual was hospitalized for selected cause.
Average Charge

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Median

The median is the midpoint value of a specific dataset. For example, the median age - or the age at which half the population is older and half is younger - is an indicator of the age composition of a population.

When to Use Median

The median is a measure of central tendency that is not sensitive to extreme values. For instance, with hospital charges, there is a fixed "floor" value of zero, but on the other end, there will be a few very large values that will drive up the mean. The median is the 50th percentile, and is not sensitive to extreme values, so with data like charges, the median is a better measure of central tendency.
Median Charge
Hospital Length of Stay
In-hospital Deaths
Advanced Selection (Click here for Small Area)

Select the Geographic Area 

County and Local Health District, 1992 and later
Hospital Discharges
Count of Hospital Visits
Crude Rates

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted Rates
Hospital Charges

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Sum of Charges or Length of Stay

Sum of Charges (sum):Sum of all hospital charges for selected inpatient hospitalizations or ED encounters.

Total Length of Stay (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.
Total Charges (sum)

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Average Charges or Average Length of Stay

Average Charges: Sum of total charges divided by number of releases or encounters.

Average Length of Stay: Average number of days each individual was hospitalized for selected cause.
Average Charge

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Median

The median is the midpoint value of a specific dataset. For example, the median age - or the age at which half the population is older and half is younger - is an indicator of the age composition of a population.

When to Use Median

The median is a measure of central tendency that is not sensitive to extreme values. For instance, with hospital charges, there is a fixed "floor" value of zero, but on the other end, there will be a few very large values that will drive up the mean. The median is the 50th percentile, and is not sensitive to extreme values, so with data like charges, the median is a better measure of central tendency.
Median Charge
Hospital Length of Stay
In-hospital Deaths

Inpatient Death Data

Inpatient death information comes from the /"discharge status/" field on the UB92 (nationally standardized billing form). It includes those persons who were admitted to the hospital alive and left deceased. Those deaths should also be represented in the mortality data. Other discharge statuses include /"released to a nursing home/" and /"released to self care./"
Number of In-hospital Deaths
Crude Rate for In-hospital Deaths

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted In-hospital Death Rates
Utah's 61 Small Areas, 1992-present
Hospital Discharges

Count

This module returns the number of hospitalization discharges.
Count of Hospital Visits
Crude Rates

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted Rates
Hospital Charges

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Sum of Charges or Length of Stay

Sum of Charges (sum):Sum of all hospital charges for selected inpatient hospitalizations or ED encounters.

Total Length of Stay (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.
Total Charges (sum)

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Average Charges or Average Length of Stay

Average Charges: Sum of total charges divided by number of releases or encounters.

Average Length of Stay: Average number of days each individual was hospitalized for selected cause.
Average Charge

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.

Median

The median is the midpoint value of a specific dataset. For example, the median age - or the age at which half the population is older and half is younger - is an indicator of the age composition of a population.

When to Use Median

The median is a measure of central tendency that is not sensitive to extreme values. For instance, with hospital charges, there is a fixed "floor" value of zero, but on the other end, there will be a few very large values that will drive up the mean. The median is the 50th percentile, and is not sensitive to extreme values, so with data like charges, the median is a better measure of central tendency.
Median Charge
Hospital Length of Stay
In-hospital Deaths

Inpatient Death Data

Inpatient death information comes from the /"discharge status/" field on the UB92 (nationally standardized billing form). It includes those persons who were admitted to the hospital alive and left deceased. Those deaths should also be represented in the mortality data. Other discharge statuses include /"released to a nursing home/" and /"released to self care./"
Number of In-hospital Deaths
Crude Rate for In-hospital Deaths

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted Rate for In-hospital Deaths
Injury Selection (Click here for UDOH Injury Categories and Custom E-Codes)

Select the Geographic Area 

County and Local Health District, 1992 and later
Hospital Discharges

Count

This module returns the number of hospitalization discharges.
Count of Hospital Visits
Crude Rates

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted Rates

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.
Hospital Charges
Hospital Length of Stay
In-hospital Deaths

Count

This module returns the number of deaths.
Number of In-hospital Deaths
Crude In-hospital Mortality Rate

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted In-hospital Mortality Rate
Utah's 61 Small Areas, 1992-present
Hospital Discharges

Count

This module returns the number of hospitalization discharges.
Count of Hospital Visits
Crude Rates

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted Rates

Charges, Costs, Expenditures

Charges are what is on the hospital bill. Not all charges get paid. For instance, oftentimes, Medicaid or an insurance company will pay a certain percentage of the charges, and then the hospital has to write off the rest. Charges are what is on the UB92 billing form, and is the only piece of information we have access to. Costs are harder to measure and not available. Expenditures are bound to be less than charges.
Hospital Charges
Hospital Length of Stay
In-hospital Deaths

Count

This module returns the number of deaths.
Number of In-hospital Deaths
Crude In-hospital Mortality Rate

Crude Rate

A crude rate is a fraction, in which the numerator is the number of people in whom an event occurred during a certain period of time, and the denominator is the total number of people in the population at risk for the same period of time.
Data table and chart

Quartile Map

A "Quartile" map assigns areas to four groups. Each group includes the SAME NUMBER of areas. For instance, for local health districts, each group includes three areas. Group membership and map color are based on the rank order of area rates, from the lowest rate to the highest. The first quartile is colored white and consists of areas with the lowest rates. Areas with the darkest color have the highest rates. Percentile maps such as this assign 25% of the areas to the "highest" category, even when area rates are very close. In other words, just because an area is in the "highest" category doesn't necessarily mean that the rate is significantly high.
Data table and Quartile Map

High-Low-Same Map

A "High-Low-Same" map assigns areas to three groups. Group membership and map color are based on whether each area's rate is significantly different (higher or lower) from the state rate. An area's rate is considered significantly different if the overall state rate falls outside (above or below) the confidence interval for that area. Maps such as this one may lack color variation if the area rates are based on very few cases and have wide confidence intervals. In other words, just because an area's rate is statistically the "same" as the state rate doesn't necessarily mean that the rate is not meaningfully high or low.
Data table and High-Low-Same Map
Age-adjusted In-hospital Mortality Rate
Center for Health Data, Utah Department of Health, Salt Lake City, UT 84114-2101, Telephone: 801-538-9191, Fax: 801-538-9346, Email: chdata@utah.gov
The information provided above is from the Utah Department of Health's Center for Health Data IBIS-PH web site (http://ibis.health.utah.gov). The information published on this website may be reproduced without permission. Please use the following citation: "Retrieved Sat, 07 November 2009 11:06:33 from Utah Department of Health, Center for Health Data, Indicator-Based Information System for Public Health Web site: http://ibis.health.utah.gov".

Content updated: Wed, 20 Feb 2008 02:35:28 MST