Data Quality Module

What is Data Quality Module

Data Quality Module (DQM) helps quickly find discrepancies and errors in your project data.
This module contains two different user rights settings on the User Rights page: one setting for creating/editing custom rules, and one for executing rules.

Pre-defined Rules

To pull up the list of rules, click on "Data Quality" in the left margin (circled in red below)
There are 8 pre-defined rules. They cannot be modified, reordered, or removed.
To find discrepancies for a given rule, click the Execute button next to it, or click the "All", "All except A&B", or "All custom" buttons to file multiple rules at once.

Custom Rules

Custom Rules can include mathematical operations and also advance functions to provide you with a great amount of power for validating your project data.

This example will count the number of times that the name John has been entered into the name variable. The name variable is a text box.

[name] = 'John'

This example will count the number of times that the ICD-9 code = 780.4 has been entered into the project. The sc_icddiag variable is for CheckBoxes (Single Answer).

if ( [sc_icddiag_code] = 780.4, 1,0 )

This example will count the number of times that the ICD-9 code = 780.4 AND ICD-9 code = 345.8 have been entered into the project.

if ( [sc_icddiag_code] = 780.4 AND [sc_icddiag_code] = 345.8 , 1,0 )

This example will count the number of times that the ICD-9 code = 780.4 OR ICD-9 code = 345.8 have been entered into the project.

if ( [sc_icddiag_code] = 780.4 OR [sc_icddiag_code] = 345.8 , 1,0 )

This example will count the number of time that the ICD-9 code = 780.4 OR = 345.8 Works for CheckBoxes (Multiple Answer),

1, 780.4

2, 345.41

3, 345.8

4, 345.9

[sc_icddiag_code(1)] references the first item in the list, in this case it is 780.4
if ( [sc_icddiag_code(1)] = 780.4 OR [sc_icddiag_code(1)] =345.8, 1,0)

The project variable names may be used in rule logic by placing the variable name inside square brackets [].
Data Quality rules must always result with a TRUE or FALSE condition and NEVER a value.

Utah CTSI REDCap Support

Data Quality Module

Analytics

Related content