Project Newsletter Iowa Public Health Tracking, June 2013

The Data Warehouse Replacement Project includes updated County Health Snapshot reports. The snapshots provide an overview of key health indicators for local communities. They contain county-level measures that are organized into eight categories. The categories are asthma, cancer, health behaviors and outcomes, heart disease and other chronic conditions, infectious disease, mortality and injury prevention, population statistics and reproductive outcomes. The updated county health snapshots include almost forty new chronic disease indicators in addition to all of the indicators in the existing snapshots.There will be two different reports available in the Data Warehouse replacement system. One of the reports is a multi-year county health snapshot. This report has a similar format to the previous county health snapshot report in the current Data Warehouse. It will display multiple years of data for a single county. The data will be for the most current year available and the two years prior. The state values for the current year will also be included.

Central Stores Inventory: Employing the IBM 1410 Magnetic Tape Computer System

The Property and Equipment Department has a central supply of automotive parts, tools, and maintenance supplies. This central supply is used to supply the repair shop and also to supply parts to the various field garages and all departments of the Commission. The old procedure involved keeping track manually of all of the parts, which involved some 22,000 items. All records, billings, arid re-order points were kept manually. Mani times the re-order points were located by reaching into a bin and finding nothing there. Desiring to improve this situation, an inventory control system was established for use on the computer. A complete record of the supplies that are stored in the central warehouse was prepared and this information was used to make a catalog. Each time an item is issued or received, it is processed through the inventory program. When the re-order point is reached, a notice is given to reorder. The procedure for taking inventory has been improved. A voucher invoice is now prepared by the computer for all issues to departments. These are some of the many benefits that have been de rived from this system.