# 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.
{{style color:red
!*!*!*!*!*!*!*POPULATION DATA ALERT!*!*!*!*!*!*!*[[br]]
On September 15, 2023, population estimates for 2020 and later have been updated to IBIS Version 2022. For more information,
go to [http://ibis.health.utah.gov/query/PopEst.html].
}}

- 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. - 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 in Days

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

Total Length of Stay in Days (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.#### 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 Charge#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### 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.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.

#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.Total Length of Stay in Days (sum)#### Sum of Charges or Length of Stay in Days

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

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

Total days stayed in hospital form the date of admission to the date of discharge.Average Length of Stay in Days#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### 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 in Days#### 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
#### 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." - Inpatient Hospital Death Rates
#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

- 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. - 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 in Days

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

Total Length of Stay in Days (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.#### 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 Charge#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### 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.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.

#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### Sum of Charges or Length of Stay in Days

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

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

Total days stayed in hospital form the date of admission to the date of discharge.#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### 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
#### 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." - Inpatient Hospital Death Rates
#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

- 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. - 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 in Days

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

Total Length of Stay in Days (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.#### 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 in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### 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.

#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### Sum of Charges or Length of Stay in Days

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

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

Total days stayed in hospital form the date of admission to the date of discharge.#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### 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
#### 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." - Inpatient Hospital Death Rates
#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

- Count of Hospital Visits
#### Count

This module returns the number of hospitalization discharges. - Crude Rates
- 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 in Days

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

Total Length of Stay in Days (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.#### 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 in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### 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.

#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### Sum of Charges or Length of Stay in Days

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

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

Total days stayed in hospital form the date of admission to the date of discharge.#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### Length of Stay in Days

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

#### 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."#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

- Count of Hospital Visits
#### Count

This module returns the number of hospitalization discharges. - Crude Rates
- 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 in Days

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

Total Length of Stay in Days (sum): Sum of all days persons were hospitalized for selected inpatient hospitalizations.#### 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 in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### 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.

#### Length of Stay in Days

Total days stayed in hospital form the date of admission to the date of discharge.#### Sum of Charges or Length of Stay in Days

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

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

Total days stayed in hospital form the date of admission to the date of discharge.#### Average Charges or Average Length of Stay in Days

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

Average Length of Stay in Days: Average number of days each individual was hospitalized for selected cause.#### Length of Stay in Days

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

#### 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."#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

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

#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.

#### Inpatient Hospital Death Rate

Inpatient hospital death rate is calculated by the number of inpatients who died in the hospital divided by the total number of hospitalizations. For example, the death rate for septicemia is calculated by dividing the number of inpatients hospitalized for septicemia who died during their hospitalization by the total number of hospitalizations for septicemia. The rate is reported per 100 hospitalizations in this report but could also be reported as a percentage.