# Injury Inpatient Hospital Discharge Query Module Configuration Selection

#### 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.#### ICD-9 Injury Data

This IBIS-PH module queries injury data only. Data in this module are consistent with the injury case definitions found in the Consensus Recommendations for Using Hospital Discharge Data for Injury Surveillance (2003) developed by the State and Territorial Injury Program Directors Association (STIPDA) Injury Surveillance Workgroup, available at http://ibis.health.utah.gov/pdf/resource/query/STIPDA.pdf (see pages 7-11).- Count of Hospital Visits
#### Count

This module returns the number of hospitalization discharges. - 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. - 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.- Total Charges (sum)
#### 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. - Average Charge
#### 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. #### 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.Median Charge#### 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.

- Total Length of Stay (sum)
#### 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. - Average Length of Stay
#### 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. #### 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.Median Length of Stay#### 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.

- Number of In-hospital Deaths
#### Count

This module returns the number of 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. - Age-adjusted In-hospital Mortality Rate

- Count of Hospital Visits
#### Count

This module returns the number of hospitalization discharges. - 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. - 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.- Total Charges (sum)
#### 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. - Average Charge
#### 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. #### 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.Median Charge#### 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.

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

- Number of In-hospital Deaths
#### Count

This module returns the number of 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.- Age-adjusted In-hospital Mortality Rate

- Count of Hospital Visits
#### Count

This module returns the number of hospitalization discharges. #### 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.- 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.#### 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.#### 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.#### 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.

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

- Number of In-hospital Deaths
#### Count

This module returns the number of 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.- Age-adjusted In-hospital Mortality Rate