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:
- open table L Problem from Centralized data front end.accdb
- 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)
Other known errors
We store information about some other known errors in the L_Problem table: