Click on the magnifying glass to the right. Starting typing a topic you wish to learn about

Data Quality Module

Owned by Melanie Mansuy (Unlicensed)
Last updated: Sept 22, 2022 by Alyssa Hill
2 min read

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.