To configure the Code Validation filter to use a table which describes a single coding system, the filter requires:

  • The name of the table.
  • The column in the table which holds the identifiers.
  • The name of the coding system.

Tables which describe a single coding system should have indexes on their Identifier column.

Example

This is a very simple example. There is a single table (CodingSystemA) containing a list of identifiers in the database. The name of the coding system described by CodingSystemA is defined in the Coding System parameter in the configuration.

Database Table CodingSystemA

Value

A

B

C

D

Configuration

Property

Value

Table Name

CodingSystemA

Identifier Column

Value

Description Column

 

Coding System

TestCodingSystem1

Version

 

Coding System Column

 

Version Column

 

Example Message (OK)

Coding System Name

TestCodingSystem1

Identifier

D

Example Message (Coding System Wrong)

Coding System Name

CodingSystem2

Identifier

D

Example Message (Identifier Wrong)

Coding System Name

TestCodingSystem1

Identifier

X