KEDA - Reference & Master Data Management

Reference Data

Within the Enterprise Common Data Framework, there will be tables that contain standardized data that should not change over the foreseeable future (i.e., state abbreviations, county codes, etc). This data is classified as ‘reference data’. The data for these particular tables will be available within the ECDF along with the table structures. Any additions or modifications to these datasets for enterprise consideration will need to be submitted through standard governance procedures. Agencies will be able to enter new codes into their local database and enterprise IDs and definitions can be vetted after the fact.

Master Data Management

A future offshoot of the ECDF will be the creation of a centralized Master Data Warehouse (MDW) for standardized common data elements, to be considered the ‘best standard’ for the Enterprise. This warehouse will be populated from the most reliable sources of information for each data area (citizen, business, physical address, etc.). This Master Data will then be available for agencies to receive updates ‘near real-time’ or via batch on an agreed schedule (nightly, weekly, monthly, etc.). Over time, these update processes can be replaced by the creation of services that will validate information against the Master Data Warehouse real-time to assure system input accuracy. This MDW will contribute to the elimination of redundancy and further improve data quality throughout the enterprise.