L Problem table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m Ttenbergen moved page L Problem to L Problem table: consistent naming
m m
Line 1: Line 1:
'''L_Problem''' in [[Centralized_data.mdb]] contains known errors or false-positives. It is used for recording this information by the and for excluding records from check queries.
'''L_Problem''' in [[Centralized_data.mdb]] contains some of the [[known data errors]] and some false-positives. It is used for excluding records from check queries.


It is manually populated by the [[data processor]] as she encounters the errors or false positives, for example as part of [[vetting]].
It is manually populated by the [[data processor]] as she encounters the errors or false positives, for example as part of [[vetting]].

Revision as of 18:04, 23 November 2016

L_Problem in Centralized_data.mdb contains some of the known data errors and some false-positives. It is used for excluding records from check queries.

It is manually populated by the data processor as she encounters the errors or false positives, for example as part of vetting.

L_Problem contains the fields

field type description
D_ID long unique record ID
Query text query from which to exclude this false positive
Notes text further explanations, eg why the error was not corrected or why it is a false positive