# Injury Emergency Department Encounter 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).#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Treat and Release Injury Encounters
- Crude Rates - ED Treat and Release Injury Encounters
#### 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 - ED Treat and Release Injury Encounters

#### 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) - ED Treat and Release Injury Encounters
#### 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 - ED Treat and Release Injury Encounters
#### 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 - ED Treat and Release Injury Encounters#### 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.

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count of In-patient Admissions from ED Injury Encounters
#### ED Inpatient Admissions versus HDDB Inpatients

The HDDB includes all inpatient hospital admissions, some of which come from the ED, and others do not. There is a subset of patients, those who come in through the ED and are later admitted as an inpatient, who are in both datasets. - Crude Rates - Admissions from ED Injury Encounters
#### 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 - Admissions from ED Injury Encounters

#### 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) - Admissions from ED Injury Encounters
#### 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 - Admissions from ED Injury Encounters
#### 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 - Admissions from ED Injury Encounters#### 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.

#### Length of Stay

Total days stayed in hospital form the date of admission to the date of discharge.- Total Length of Stay (sum) - Admissions from ED Injury Encounters
#### 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 - Admissions from ED Injury Encounters
#### 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 - Admissions from ED Injury Encounters#### 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.

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Injury Encounters
- Crude Rates - ED Injury Encounters
#### 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 - ED Injury Encounters

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

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Treat and Release Injury Encounters
#### 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 - ED Treat and Release Injury Encounters

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

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count of In-patient Admissions from ED Injury Encounters
#### ED Inpatient Admissions versus HDDB Inpatients

The HDDB includes all inpatient hospital admissions, some of which come from the ED, and others do not. There is a subset of patients, those who come in through the ED and are later admitted as an inpatient, who are in both datasets. #### 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 - Admissions from ED Injury Encounters

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

#### Length of Stay

Total days stayed in hospital form the date of admission to the date of discharge.#### 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.

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Injury Encounters
#### 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 - ED Injury Encounters

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

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Treat and Release Injury Encounters
#### 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 - ED Treat and Release Injury Encounters

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

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count of In-patient Admissions from ED Injury Encounters
#### ED Inpatient Admissions versus HDDB Inpatients

The HDDB includes all inpatient hospital admissions, some of which come from the ED, and others do not. There is a subset of patients, those who come in through the ED and are later admitted as an inpatient, who are in both datasets. #### 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 - Admissions from ED Injury Encounters

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

#### Length of Stay

Total days stayed in hospital form the date of admission to the date of discharge.#### 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.

#### ED Treat and Release, Inpatient Admissions, and All Ecounters

Treat and Release: A patient that visits the ED, but is not admitted to the hospital as an inpatient. The patient does not stay overnight and is not admitted to another department of the hospital.

Treat and Admit (Inpatient Admissions): An ED patient that later become and inpatient. An inpatient stay involves and overnight stay and admission to another department of the hospital, such as the ICU.

All ED Encounters: All ED encounters includes all treat and release patients and all inpatient admissions through the ED.- Count - ED Injury Encounters
#### 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 - ED Injury Encounters

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