To configure the Code Validation filter to use a table which describes a number of coding systems, the filter requires:

  • The name of the table.
  • The column which holds the identifiers.
  • The column in the table which holds the Coding System's names.

Tables which describe multiple coding systems should have indexes on the combination of columns Identifier, Coding System Name.

Example

This use case uses a single table called MultipleA. When multiple coding systems are described in a single database table the configuration must contain both the column which contains the identifiers and the column which contains the coding systems.

Database Table MultipleA

System

Identifier

CS 1

A

CS 2

A

CS 2

B

CS 1

C

Configuration

Property

Value

Table Name

MultipleA

Identifier Column

Identifier

Description Column


Coding System


Version


Coding System Column

System

Version Column


Example Message (OK)

Coding System Name

CS 2

Identifier

B

Example Message (Identifier Wrong)

Coding System Name

CS 2

Identifier

C

Example Message (Coding System Wrong)

Coding System Name

CS 3

Identifier

B