Known data errors

Some records have known errors or data that triggers false positives in consistency checks. L Problem is a record of these so they can be excluded from queries. The table would usually be populated by the data collector during vetting.

Instructions for adding a record

If a false positive or known uncorrected error is found:

1. open table L Problem from Centralized data front end.accdb
2. make a new line
   • D_ID field: the D_ID of the record
   • Query field: the name of the query that detected this record and from which it should be masked
   • Notes field: explanations, eg why the error was not corrected or why it is a false positive

Instructions for using the table in queries

For every query, filter the L Problem table to only records related to that query and only list if null.

List of queries that use L_Problem table (SMW)

(Based on Property:DICLProblem, Property:DICStatus as set in Template:Data Integrity Check.)

	Status	problem
Query NDC dx implying death across encounters	implemented	true
Link_suspect_visitAdmitDtTm_mult_to-from-home query	ready to implement	true
Link suspect mismatch pre inpt ours incomplete query	implemented	true
Link suspect mismatch pre inpt should be ours incomplete query	implemented	true
Query cardiac arrest throughout admission	ready to implement	true
Link suspect negative transit time query	implemented	true
Link suspect dead then alive query	implemented	true

Other known errors

We store information about some other known errors in the L_Problem table:

• Gaps and overlaps
• Lost/missing chart