Oregon Office of Family Health: Construction of a Data Mart, Phase I

Oregon Office of Family Health: Construction of a Data Mart

Oregon's Office of Family Health (OFH) is building an integrated Maternal and Child Health web-based data warehouse that will serve as both the repository for standardized client and provider information across programs as well as a tool for coordinating client care across providers, programs and agencies.  The OFH vision includes decision support based on program guidelines with alerts and reminders to clients and providers to reinforce compliance with those guidelines.  The data warehouse will enable discrete functionality in legacy operational systems to be replaced with streamlined and standardized web-based data capture that can then update the legacy files.  The data warehouse will provide tools to identify the client and provider, enable program staff to map legacy data elements to standard terms, create screening and other web forms, manage user permissions, define program eligibility requirements and service roster, and query and report data. With time, the data warehouse will supplant the legacy systems with a more robust, cost-effective, accessible and reliable information management tool that has the capacity to exchange data with partners and other agencies to eliminate duplicate data entry. 

Figure 1: FamilyNet Data Warehouse Roles, Functionality and Data Exchange:  Phase 1