L Problem table: Difference between revisions

No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{DISPLAYTITLE:L_Problem table}}The [[L_Problem table]] in [[Centralized data.mdb]] contains [[known data errors]] to exclude them from several [[CFE Data Integrity Checks]]. This could be needed because we deliberately decided they were not worth fixing, or because a [[cross check]] delivers a false positive in some circumstances.  
{{DISPLAYTITLE:L_Problem table}}The [[L_Problem table]] in [[Centralized_data.accdb]] contains [[known data errors]] to exclude them from several [[CFE Data Integrity Checks]]. This could be needed because we deliberately decided they were not worth fixing, or because a [[cross check]] delivers a false positive in some circumstances.  


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]].
Line 27: Line 27:
|where=App="Centralized data front end.accdb " and (Status<>"retired" and Status<>"declined") and (L_Problem=true or L_Problem is null)
|where=App="Centralized data front end.accdb " and (Status<>"retired" and Status<>"declined") and (L_Problem=true or L_Problem is null)
|order by=question  
|order by=question  
|limit=0
|limit=20
|more results text=Link to table of cross-checks that use L_Problem table to exclude false-positives
|more results text=Link to table of cross-checks that use L_Problem table to exclude false-positives
|default=Nothing found
|default=Nothing found
Line 37: Line 37:
{{Related Articles}}
{{Related Articles}}


[[Category: Data structure]]
[[Category:Data structure]]
[[Category: Data Processing]]
[[Category:Data Processing]]
[[Category:Data Processing]]
[[Category:Data Processing]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data front end.accdb]]
[[Category:Centralized data.mdb]]
[[Category:Centralized_data.accdb]]