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 |