HI IQs Health Information Integrated Query System

1
HI IQsHealth Information Integrated Query System

2
Purpose

• Develop a web-based data query system using
  existing software to allow public access to
  treatment,needs assessment andperformance
  improvement data

3
System Requirements

• Use existing software
• Use existing hardware
• Use existing staff skills
• minimal new skills to be learned
• Use existing staff for maintenance,
  modifications, and updates
• Produce products at a minimal cost
• Internet accessible to public

4
System Requirements

• Must be useable by persons with different
  skill/knowledge levels
• Fast response
• Tips/Help must be provided
• Flexible
• Add new data elements and measures easily

5
Project Team

• Ray Bottger, Data Analyst
• Steve Davis, Director of DSS
• Jan Duiker, Data Analyst
• Tracy Leeper, Grant Projects Manager
• Kevin Marble, Application Dev. Manager
• Becki Moore, Statistical Analyst
• Mark A. Reynolds, Data Projects Manager
• Trea Robbins, Programmer Analyst II

6
Software/Hardware

• Software/Language
• MS SQL
• Java Script
• Adobe Acrobat
• Crystal Reports
• Internet Browser
• Active Server Pages (ASP)
• Hardware
• Current production server (MS SQL Server)

7
Products

• Simple Reports
• Pre-produced report in a PDF format
• Basic Query
• Returns a single result
• Advanced Query
• Returns multiple results

8
Cost

• Approximately 20,000 (staff time)
• Zero dollars software/hardware

9
Simple Reports

• Data available for all three programs provided by
  DMHSAS
• Domestic Violence
• Mental Health
• Substance Abuse
• Includes prevalence of
• Domestic Violence
• Adults with Serious Mental Illness
• Alcohol or Illicit Drug Use
• Persons in need of substance abuse treatment

10
Simple Reports

• 1,583 reports in PDF format
• Data available for
• Statewide
• Regional
• County
• Agency
• of persons served and units of service

11
Basic Query

• Counts of Admitted Persons Served
• Mental Health
• Substance Abuse
• Domestic Violence/Sexual Assault
• All
• Number of Admissions
• Mental Health
• Substance Abuse
• Domestic Violence/Sexual Assault
• All
• Number of Discharges
• Mental Health
• Substance Abuse

12
Basic Query

• 412,642 rows of data on a MS SQL Server
• Most results returned to screen in under 2
  seconds
• Uses Java Script and stored procedures to access
  data

13
Advanced Queries

• Counts of Admitted Persons Served
• Mental Health
• Substance Abuse
• Domestic Violence/Sexual Assault
• All

14
Advanced Queries

• 1,332,935 rows of data
• System can return a result set of 5,000 rows in
  under 6 seconds
• Uses Java Script and stored procedures to access
  data

15
Data process for Basic and Advanced Query
MS SQL Server
Start
Active Server Page (ASP)
Stored Procedure (SQL Program)
HTML file created