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 |