Skip to main content

Table 2 An example of representing a quality requirement of CARSES as an SQL query

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

Description of quality requirement

Corresponding table name

Corresponding column name

Corresponding DQR(SQL)

ID of request should not be empty

Imaging_exam_ request

Request_identifier

SELECT

   

Request_identifier

   

FROM

   

Imaging_exam_ request

   

WHERE

   

Request_identifier not null