Skip to main content

Table 3 Sub-dimensions in Kahn’s framework and corresponding keywords of ADL and DQR templates

From: Application of openEHR archetypes to automate data quality rules for electronic health records: a case study

Sub-dimension of Kahn’s DQA framework

Keywords of ADL

Definition

Example of constraint description

DQR templates with example for problematic data (in pseudocode)

Relational conformance

Cardinality

Limits the max number of memberships

(2..5)

Select *

   

From archetypes group by attributes having count(*) > 5 and count(*) < 2

Occurrences

Data exist only once

(1..1)

Select attribute

    

From archetype

    

group by attribute having count(*) ! = 1

Completeness

Existence

Attribute value is optional

(0..1)

Attribute value is mandatary

(1..1)

Select attribute

    

From archetype

    

Where attribute is Null or attribute = ‘’

Uniqueness plausibility

Cardinality

Objects in one list are not duplicate

(..unique)

Select *

    

From archetypes group by attributes having count(*) > 1

Value conformance

Defining_code

Designate terminology code

(Codeset)

Select attribute

    

From archetype

    

Where attribute.code not in {Codeset}

 

Matches( )

Value range

(|10..1000|)

Select attribute

   

From archetype

   

Where attribute value < 10 or > 1000

 

Designate value

(“mmHg”)

Select attribute

    

From archetype

    

Where attribute.value ! = ‘mmHg’

  1. The archetype and attribute(s) stand for corresponding table name and column name(s) of the CDR database. Codeset stands for the content of a specific code constraint