Re-engineering Vital Statistics by Integrating Registration, Analysis and Data Dissemination

1. Re-engineering Vital Statistics by Integrating Registration, Analysis and Data Dissemination NAPHSIS Annual Meeting June 5 - 9 Cincinnati, OH SC Vital Record Reengineering Project Team Office of Public Health Statistics and Information Services South Carolina Dept. of Health and Environmental Control

2. Uncertain Relationships Info Low Confidentiality Internet Long-term Goals Strategic Level ? - Leading Health indicators - Information Uncertainties Dynamic Level Statistics/Data Warehouse No - Core Health Statistics - AggregatedDynamic Models Yes Strategic Goals Process Level Health Thematic Maps Disease - Major public health layers - Major Health Care Layers - Major Environmental Layers - Social/Economic Layers Vital Events Health Care Outcomes Population Environmental Real World Enterprise GIS/DBMS Ozone Action/Intervention - Public Health Activities HOSPITAL Research/Survey Data High Confidentiality Accurate Details Geographic Integration (A Hierarchical Model)

3. Web Death GIS Web Marriage Divorce Web Fetal Death Server Components Web Fee SSA Web Birth VRSIIS CORE South Carolina Vital Statistics Reengineering Infrastructure GIS GIS GIS GIS GIS IMR Pregnancy Birth Death Fetal Death PRAMS Cancer Injury SCAN (2000 – now) GIS Dissemination GIS Data Analysis SAS DW SAS DW Analysis (2002 – now) GIS Registration GIS SCVRSIIS (2003 – now) GIS Integration

4. Reengineering I (2002-current): SCVRSIIS (South Carolina Vital Record and Statistics Integrated Information System) for Vital Event Registration, Geo-coding, Issuance, Tracking, Reporting and Fee Accounting

5. RFP Web Birth Web Death DHEC Web Fetal Death Project Kickoff Web Fee Web Death Thin Clients Web Marriage Divorce SSA 2003 2004 2005 2006 SCVRSIIS Milestones and Timelines Results: Web Birth: All 2004 to current BCs, 100% geo-coded Web Fee: By May 31 over 80% of counties deployed Web Death: All 2005 DCs in system, partially geo-coded SSA FDT: 90% Verified and Transferred

6. > 90 Users @ 46 County DCRs > 50 Users @ DHEC VR > 100 Users @ 50 Birth Hospitals > 80 Users @ 46 Counties Web Death > 60 Users @ 46 Counties > 200 Users @ 46 Coroners Web Marriage Divorce Web Fetal Death > 80 Users @ DHEC VR Office > 20 Users @ Other Facilities > 500 Users @ 13,300 Drs. > 300 Users @ 510 FHs Implemented In Development SC VRSIIS System Components > 50 Users @ DHEC VR Office SSA Web Fee SSA Web Birth VRSIIS CORE Reports/ Extracts/ Exports CHESS > ?? Users Current:600 Users: Potential:> 1600 Users Version 2.0 as of 5/31/05 For update contact: zhaog@dhec.sc.gov

7. Web Death Web Marriage Divorce Web Fetal Death Real Time Geo-coding Function in SCVRSIIS Server Components Web Fee SSA GIS GIS Web Birth GIS VRSIIS CORE GIS

8. Results of Geo-coding • Approx. 55,000 births a year in SC

9. Reengineering II (2002-2004): SAS Data Mart with GIS (Vital Statistics SAS Data Mart Integrated with GIS Spatial Data Engine) for Vital Statistics Data Quality, Control, Provisional and Annual Statistics Processing, Spatial/Statistical Analysis and Modeling, Epidemiological Research, and Reporting.

10. Point feature class SDEDATA01.SDEDATA.VIEW_AIRPORTS Table sdedata01.dbo.evacstatus Line feature class SDEDATA01.SDEDATA.VIEW_ALLROADS Table sdedata01.dbo.GeoRestauran t_manual Polygon feature class SDEDATA01.SDEDATA.VIEW_CITY_BOUNDARIES Table sdedata01.dbo.hlthUpdate Polygon feature class SDEDATA01.SDEDATA.VIEW_COUNTYGEN Table sdedata01.dbo.import_restau rant Point feature class SDEDATA01.SDEDATA.VIEW_CRITICALDATASHEE TS Table sdedata01.dbo.manualUpdate Polygon feature class SDEDATA01.SDEDATA.VIEW_EVACAREA Table sdedata01.dbo.OutputNewGD T Line feature class SDEDATA01.SDEDATA.VIEW_EVACUATIONROUTE Table sdedata01.dbo.restau_test Polygon feature class SDEDATA01.SDEDATA.VIEW_FASTSURGE Table sdedata01.dbo.restaurantUpd Point feature class ate SDEDATA01.SDEDATA.VIEW_HLTHDEPARTMENT Table sdedata01.dbo.VRTempGISU Polygon feature class pload SDEDATA01.SDEDATA.VIEW_HLTHDIST Table Point feature class sdedata01.sdedata.Results SDEDATA01.SDEDATA.VIEW_HLTHFAC Point feature class SDEDATA01.SDEDATA.VIEW_HOSPITALS Table sdedata01.SDEDATA.sc1999_ name Point feature class SDEDATA01.SDEDATA.VIEW_HURRICANE_SHELTE RS2003 Table sdedata01.SDEDATA.Sum_Ou tput Line feature class SDEDATA01.SDEDATA.VIEW_INTERSTATES Point feature class Table SDEDATA01.SDEDATA.VIEW_LIBRARIES sdedata01.sdedata.users Polygon feature class SDEDATA01.SDEDATA.VIEW_NORMALSURGE Table sdedata01.dbo.table Point feature class SDEDATA01.SDEDATA.VIEW_PRIVATESCHOOL Table Point feature class SDEDATA01.SDEDATA.VIEW_PUBLICSCHOOL Point feature class SDEDATA01.SDEDATA.VIEW_RESTAURANT Table Point feature class SDEDATA01.SDEDATA.VIEW_SECUREDHLTHFAC Table sdedata01.dbo.table Table Table Table Table sdedata01.sdedatarestaurantUpdate Allow Prec- Field name Data type nulls Default value Domain ision Scale Length COU_CODE String No 2 PC_CODE String No 3 PERMIT_NUMBER String No 10 NAME String Yes 30 MAILING_ADDRESS String Yes 30 CITY String Yes 20 STATE String Yes 2 ZIPCODE String Yes 9 LOCATION String Yes 30 CLOSE_CODE String Yes Point feature class sdedata01.SDEDATA.libraries Point feature class sdedata01.SDEDATA.privschl Point feature class sdedata01.SDEDATA.pubschls Point feature class Locations of all Licensed sdedata01.SDEDATA.Restaurant Restaurants Simple feature class Geometry Point Contains M values No sdedata01.SDEDATA.Restaurant Contains Z values No Allow Prec- Field name Data type nulls Default value Domain ision Scale Length OBJECTID_1 Object ID COU_CODE String Yes 15 12 0 PC_CODE String Yes 15 WATER String Yes 11 SEWAGE String Yes 11 PERMIT_NUM String Yes 20 REFUSE String Yes 11 NAME String Yes 43 PHONE String Yes 12 FAX String Yes 12 MAILING_AD String Yes 42 GPS_LOCATI String Yes 18 CITY String Yes 27 AREA_CODE String Yes 12 FACILITY String Yes 9 STATE String Yes 9 TYPE_FACIL String Yes 15 LOCATION String Yes 39 IDENTIFIER String Yes 16 AV_CITY String Yes 27 ZIPCODE String Yes 11 AV_STATE String Yes 9 PLUS4 String Yes 11 AV_ADD String Yes 42 AV_SCORE Double Yes 10 0 CLOSE_CODE String Yes 15 AV_ZIP String Yes 11 CAPACITY Double Yes 12 0 XIN String Yes 5 3 WATER String Yes 11 PERMIT_NUMBER String No 10 SEWAGE String Yes 11 NAME String Yes 30 MAILING_ADDRESS String Yes 30 REFUSE String Yes 11 CITY String Yes 20 PHONE String Yes 12 STATE String Yes 2 FAX String Yes 12 ZIPCODE String Yes 9 GPS_LOCATI String Yes 18 LOCATION String Yes 30 AREA_CODE String Yes 12 CLOSE_CODE String Yes 1 FACILITY String Yes 9 CAPACITY Double Yes 10 0 WATER String Yes 3 TYPE_FACIL String Yes 15 SEWAGE String Yes 3 IDENTIFIER String Yes 16 REFUSE String Yes 3 AV_CITY String Yes 27 PHONE String Yes 10 FAX String Yes 10 GPS_LOCATION String Yes 20 AREA_CODE String Yes 3 FACILITY String Yes 30 TYPE_FACILITY String Yes 1 DA_ACTIVITY_DATE Date Yes 0 0 36 SCORE String Yes 3 ODD ODD ODD ODD Reengineered Vital/Health Geospatial and Statistics Data Architecture ( 2002 – now) Analysis Tools Data Access DATAUSER USER SCHEMA SDEDATA USER SCHEMA Feature Dataset Birth Feature Dataset Cancer Analysis Tools Data Access Feature Dataset Death SDE VIEW SAS Bridge Feature Dataset Lead Feature Dataset Flood Hazard Feature Dataset EnvironInfo DTS Analysis Tools Data Access Feature Dataset Census Feature Dataset Restricted sdedata01.dbo.table 1 3 3 3 sdedata01.dbo.table 3 1 sdedata01.dbo.table 3 DTS sdedata01.dbo.table sdedata01.dbo.table Feature Dataset Roads sdedata01.dbo.table Real Time Update Of Location Data embeded Java program/ SDE JAVA API CAPACITY Double Yes 10 WATER String Yes SEWAGE String Yes REFUSE String Yes PHONE String Yes 10 FAX String Yes 10 GPS_LOCATION String Yes 20 AREA_CODE String Yes FACILITY String Yes 30 h TYPE_FACILITY String Yes GEOCODE AND DA_ACTIVITY_DATE Date Yes 36 SCORE String Yes INSERT FEATURES INSERT Feature Dataset Detail Store Boundary Summary Store Feature Dataset COMPARE Zipcodes Feature Dataset Places 2 Point feature class 2 Locations of Funeral homes DELETE 7 sdedata01.SDEDATA.FuneralHomes 7 0 Locations of all Libraries Locations of all Private Schools Table Pre sdedata01.sdedata.DelFrmRestaurant Locations of all Public Schools Allo c- w isio Scal Lengt Field name Data type nulls Default value Domain n e Long OBJECTID_1 No 10 integer COU_CODE String Yes 15 PC_CODE String Yes 15 PERMIT_NUM String Yes 20 NAME String Yes 43 Info Mart MAILING_AD String Yes 42 CITY String Yes 27 STATE String Yes 9 LOCATION String Yes 39 ZIPCODE String Yes 11 PLUS4 String Yes 11 CLOSE_CODE String Yes 15 CAPACITY Double Yes Table sdedata01.sdedata.import_restaurant Allow Prec- Field name Data type nulls Default value Domain ision Scale Length COU_CODE String No 2 PC_CODE String No STAT String Yes 5 UTM_E Double Yes 14 UTM_N Double Yes 14 LONGITUDE Double Yes 25 LATITUDE Double Yes 25 ACTIVITY_DATE Date Yes 36 0 SCORE String Yes 3 Long DTS Shape Yes 10 integer SAS Data Warehouse AV_STATE String Yes 9 AV_ADD String Yes 42 AV_SCORE Double Yes 10 0 AV_ZIP String Yes 11 XIN String Yes 5 STAT String Yes 5 UTM_E Double Yes 14 2 UTM_N Double Yes 14 2 LONGITUDE Double Yes 25 7 LATITUDE Double Yes 25 7 SHAPE Geometry Yes

11. Reengineering III (2000-Now): SCAN (South Carolina Community Assessment Network) for Vital Statistics Data Dissemination, Presentation, Statistical and Spatial Data Query and Descriptive Reporting

12. SCANAVR Functions Chart Table Trend lines Interactive GIS Maps Confidence Interval Cluster Delineation

13. HAN MPI Physician’s Billing Sys SCCCR ORS PAIS AIMS Home Health TBI CBARS CRS BCN CBARS Draft DHEC Enterprise System Integration Architecture VR-MCHIS Hearing Fee Death Metabolic VDRS Fetal VLBW VRSIIS Core M/D Birth BD SCBOS Birth/Fetal Death Death Registries Newborn Screening VLBW/Birth Defect ? EFIS Demographic Physicians Death Record (~84% of IMZ) DG IMZ Items Billing? LIMS HF (100% IMZ) PVS LR TIMS IMZ STD ASPEN NBS Restaurant HNSN PM2 SNS PM1 HARS (~16% of IMZ) CHESS ArcGIS Server FSS WCS EPSDT WIC IMZ ?? Web Server DG/SCD/RM CARES CRS ArcSDE RDBMS Confirmed Connection (by standard interoperability) Connection to be confirmed (by standard interoperability) Connection should be established (by standard interoperability) April 28, 2005 Version 1.0

14. Draft DHEC Enterprise Data Integration Architecture Operational Systems Data Mart Data Warehouse Dimensional Stores Data and Reports Qlik View Corporate Information CHESS DM Other possible solution? PW Protected VR-MCHIS DM ArcGIS Server DHEC Data and Statistics Portal SCAN SAS DW Community Assessment and Performance Evaluation CIQ CHIP SCAN CIQ – Community Information Query SCAN CHIP – Community Health Improvement Programs (e.g. OMB, SCORES, GHI) April 28, 2005 Version 1.0

15. A Team Work Managerial Support • Chief of Staff / Commissioner • PHSIS Director / Deputy Director • Biostatistics and Health GIS/VR Directors Biostatistics and Health GIS/Vital Record Staff Informatics/Biostatistics/Data Quality/Project Managers • Biostatisticians and Epidemiologists • Geographers and environmental sciencists. • Applications Analyst II (System Administrator) • Applications Analyst II – User Support • GIS Analyst –Specializes in BT/Emergency Response, Cartography/Geocoding/Statistics, Field/Mobile GIS/GPS, ArcIMS / ArcSDE & maintains GIS • MPH, MDs, Ph.D., Dr.PH, MAs, BAs