To configure the Code Validation Filter to use a table which describes a number of coding systems, but restricts the validation to a single coding system, 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.
  • The name of the coding system.

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

Example

This example is a twist on using a table which describes multiple coding systems. Although the table contains multiple coding systems, this example only uses one of the coding systems in the table. Configuration is a combination of how a Single Coding System Table and a Multiple Coding System Table is configured. Both a Coding System Name and a column for a Coding System Name, is provided in the configuration.

Configuration

Property

Value

Table Name

MultipleA

Identifier Column

Identifier

Description Column


Coding System

CS 2

Version


Coding System Column

System

Version Column


Example Message (OK)

Coding System Name

CS 2

Identifier

B

Example Message (Coding System Wrong)

Coding System Name

CS 1

Identifier

C