Data Quality Management and Query Resolution

Writing Effective Queries

Table 1

30-45 minutes Foundational Step 6 of 7

Table

Table 1

6 / 7

Table

Table 1

Problem	Poor query	Improved query
Out-of-range temperature	Change temperature to 37.0	Temperature is recorded as 370 degrees Celsius, which is outside the expected range. Please verify against source and correct or clarify.
Date inconsistency	Discharge date is wrong	Discharge date is before admission date. Please verify both dates against source documents and correct or clarify.
Missing primary outcome	Fill in outcome	Primary outcome is missing for the day 28 visit. Please enter the outcome or document the reason it is unavailable.
Inconsistent pregnancy response	Participant cannot be pregnant	Pregnancy status is recorded as pregnant, while sex is recorded as male. Please verify both fields against source and correct or clarify.
Duplicate ID	Delete duplicate	Participant ID appears in two records. Please confirm whether this is a duplicate or two distinct participants and update as appropriate.