Query Builder for Injury Inpatient Hospital Discharge Query Module for Utah Counties and Local Health Districts - Total Charges (sum)

Step: 1. |2. |3. |4. |5. |6. |7. |8. |9. | Finish 
Overview

Overview

The inpatient discharge data in this IBIS-Q query module come from all Utah licensed hospitals. The database is maintained by the Utah Department of Health, Office of Health Care Statistics.

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://www.stipda.org/documents/hdd.pdf (see pages 7-11).

Getting Started

Follow the steps to narrow your query and display your results. When you are done forming your query, click "Submit" bottom of the screen (last step) to get your query result.
Step 1: Select year (Single Years, 2006) Step 2: Select reason for hospitalization (UDOH Injury Causes)

Predefined Causes of ED Encounters/Hospitalizations

There are several predefined causes to choose from. If causes on the predefined list does not meet your needs, you may enter your own ICD codes by selecting, User-defined causes.
First choose a coding scheme to use for causes of Hospitalization. (Default is all causes.)

UDOH injury causes
User-defined causes (Enter ECode)





Step 3: Select injury intention

Select from list of intentions

Step 4: Select age (Age Adjustment Age Groups)

First choose a coding scheme to use for age groups.(Default is age adjustment age groups, all ages.)

Age adjustment age groups (less than 1, 1-4, 5-14, 15-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75-84, 85+)
14 age groups (0-28 days, 29-365 days, 1-4, 5-9, 10-14, 15-17, 18-19, 20-24, 25-34, 35-44, 45-54, 55-64, 65-74, 75+)
Step 5: Select sex

Would you like to include only males or only females in the results? Default includes both sexes.

Both male and female
Male
Female
Step 6: Select primary payer
Medicare
Medicaid
Other Government
Blue Cross/Blue Shield
Other Commercial
Managed Care
Self Pay
Charity/Unclassified
Industrial and Worker's Compensation
CHIP
Step 7: Select discharge status
to home or self care, routine discharge
to another short-term general hospital
to skilled nursing facility
to an intermediate care
to another type of institution
to home under care of home health service
left against medical advice
to home under care of home IV provider
expired
Step 8: Select geographic area (Utah Residence Status, Utah Residence)

First choose a geography type. Default is all Utah residents, regardless of place of hospitalization.

Utah resident status
Utah Residence
Non Utah Residence/Unknown
Local health district
County
Step 9: Select how to display the results

Use the drop down list options below to specify how to display the numerical data values on the query results page. If both a Row Values Grouped By and a Column Values Grouped By are specified, then a two dimensional table will be presented in the query results. Regardless of what is selected, a standard data list table will be presented as well as meta data that describes the data sources, data issues, and any data notes. Select the Chart Graphic Type option below if you want a chart graphic to be shown.
Specify how to display the numerical data values.

Column Values Grouped By:
 
Row Values Grouped By:
 Total Charges (sum) data values
 

Chart Graphic Type:

Finish: Submit the defined query

Utah Department of Health IBIS Query System, Data Use Agreement

The data and information provided through the IBIS-PH Query System are intended to support any individuals or entities engaged in activities designed solely to enhance the well-being of a specific community, which may include the State of Utah. Activities include informing evidence-based decision making in Utah to plan and improve health service delivery, evaluate health care interventions and systems, and inform health policy decisions. Other uses are not permissible.

As an IBIS-PH Query System user, I AGREE TO:
  1. Use the data for statistical reporting and analysis only.
  2. Avoid any attempt to identify or contact individual(s) represented in the IBIS-PH query system data.
  3. Avoid disclosure or use of the identity of any individual(s) discovered inadvertently.
  4. Avoid linkage of IBIS-PH query system data with other data that, after linkage, might allow identification of an individual represented in the IBIS-PH query system data.
  5. Use appropriate safeguards to prevent the inappropriate use or disclosure of individual(s) represented in the data, including when disclosing IBIS-PH Query System data to others.
  6. Report IMMEDIATELY any inadvertent or intentional identity disclosures or violations of this agreement of which I become aware to the Director of the Center for Public Health Data, Utah Department of Health.

I understand that failure to adhere to the above stated agreement items will result in loss of access to UDOH Internet databases, and I may be subject to legal penalties. Any use, release, or publication of health data contrary to the provisions stated is a class B misdemeanor, with subsequent violations being class A misdemeanors punishable by a fine of up to $5,000 per offense (Chapter 23, Title 26, Utah Code Annotated). If I am a Utah state government employee, this may be grounds for immediate dismissal.

Office of Health Care Statistics, Center for Health Data, Utah Department of Health, Salt Lake City, UT 84114-4004, Telephone: 801-538-7048, Fax: 801-538-9916, Website: www.health.utah.gov/hda, Email: HEALTHCARESTAT@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 Mon, 08 September 2008 10:05:58 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: Thu, 19 Jun 2008 09:57:53 MDT