Reengineering Vital Statistics by Integrating Registration Analysis and

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

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

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

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

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

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

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

Results of Geo-coding • Approx. 55, 000 births a year in SC ACTIVITY Percentage Approx. Number Geo-coding at Hospital 60% ~ 33, 000 Geo-coding by C# App 18% ~9, 900 Automatic geo-coding 78% ~42, 900 Automatic geo-coding 3% ~1, 650 Interactive geo-coding 9% ~4, 950 Zip code level 10% ~5, 500 Street Map USA Subtotal 22% ~12, 100 TOTAL 100% ~55, 000 births/year. STREETMAP USA

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.

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

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

SCAN AVR Functions Table Confidence Interval Trend lines Chart Interactive GIS Maps Cluster Delineation

Draft DHEC Enterprise System Integration Architecture VR-MCHIS ORS Hearing Metabolic HAN MPI AIMS Birth/Fetal Death Registries Newborn Screening VLBW/Birth Defect Physician’s Billing Sys PVS BD Birth (100% IMZ) (~16% of IMZ) SNS VDRS S C C C R M/D T B I SCBOS EFIS Death Record IMZ ASPEN VRSIIS Core Demographic DG IMZ Items Billing? PAIS Fetal Death ? Physicians (~84% of IMZ) VLBW Fee LIMS HF LR TIMS STD PM 2 NBS Restaurant HNSN PM 1 HARS CHESS Arc. GIS Server F S S Home Health B C N CRS W C S E P S D T W I C I M Z ? ? Web Server DG/SCD/RM CARES CBARS Arc. SDE Confirmed Connection (by standard interoperability) Connection to be confirmed (by standard interoperability) Connection should be established (by standard interoperability) RDBMS April 28, 2005 Version 1. 0

Draft DHEC Enterprise Data Integration Architecture Operational Systems Data Mart Data Warehouse Dimensional Stores Data and Reports Corporate Information AIMS PAIS BCN Qlik View Home Health CARES CHESS DM Arc. GIS Server CHESS IR PW Protected Other possible solution? TBI SCCCR VRSIIS VR-MCHIS DM SCAN SCVDRS First Sound Evaluations Training EFIS CIQ Health Facility SAS DW Restaurant LIMS SCAN CIQ – Community Information Query CHIP ASPEN Community Assessment and Performance Evaluation Metabolic SCAN CHIP – Community Health Improvement Programs (e. g. OMB, SCORES, GHI) April 28, 2005 Version 1. 0 DHEC Data and Statistics Portal CHESS

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, Arc. IMS / Arc. SDE & maintains GIS MPH, MDs, Ph. D. , Dr. PH, MAs, BAs