Managing Reference Data

This section walks you through reference data and codeset management.

  • Reference data management is done via Reference Data Manager. It enables you to create database like structure to maintain all your reference data. You can add reference data in a reference table from a spreadsheet, manually or via a DB scan. These reference tables can be validated using SQL queries for data quality tests. You can also version, publish (to environments like production, development, test etc.), and link the reference tables to relevant mappings.
  • Codeset management is done via Codeset Manager. The Codeset Manager enables you to create, manage, and map codesets. It has two sections Enterprise Codesets and Codeset Mappings.
    • The Enterprise Codesets section enables you to import legacy codesets through its upload and database scanning capabilities. In this section, you can categories codesets, define code values, version codesets, and publish codesets to various environments.
    • The Codeset Mappings section enables you to create and manage code crosswalks (mappings). You can categorize code mappings, define code crosswalks, version code crosswalks, and publish code crosswalks to various environments.