Code type tables (code tables)

A type-driven approach is taken for many of the entities in the model to provide flexibility for you to define the different types of data you want to capture. Each type in InfoSphere® MDM has a corresponding code type table. The code type tables provide you with the ability to store reference data such as relationship types, identification types, and others.

We introduced Category and Type pattern for those code tables that have a complex type. You can define categories of the types from their different point of view, then define types under each category. For example, CDEVENTCAT and CDEVENTDEFTP.

InfoSphere MDM supports translation of code table values. You can choose the language or locale for your implementation of InfoSphere MDM, which enables the application to be deployed and used across various geographies. A single deployment can support multiple locales for code tables simultaneously. The installation allows the installer to select additional translations to be loaded into code tables, in addition to the default English language.

Almost all the code type tables in InfoSphere MDM have CD_LANG_TP as a second PK column. As a result, those code tables have two PK columns. Because of this, all the FK relations in the InfoSphere MDM data model for code tables are logical and show you the relation between the child tables and code tables. There is no real physical FK created for a code table’s child table.

In the InfoSphere MDM Code Table Framework, we defined 3 classes of code type tables, C1, C2 and C3. See the Platform and core features overview for information about common core framework.