L Problem table: Difference between revisions

(13 intermediate revisions by the same user not shown)

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]].

Line 18:

|Notes || text || further explanations, eg why the error was not corrected or why it is a false positive

|}

=== List of cross-checks that use L_Problems ===

{{#cargo_query:

tables=DataIntegrityChecks,Discussions,_pageData

|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName

|fields=

DataIntegrityChecks._pageName=page, Status, Timing, Summary, Status

|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

|limit=20

|more results text=Link to table of cross-checks that use L_Problem table to exclude false-positives

|default=Nothing found

|format=dynamic table

|rows per page=20

}}

== Related Articles ==

[[Category: Data structure]]

[[Category:Data structure]]

[[Category: Data Processing]]

[[Category:Data Processing]]

[[Category:Centralized data front end.accdb]]

[[Category:~~Centralized data~~.~~mdb~~]]

[[Category:Centralized_data.accdb]]

@@ 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]].
@@ Line 18: / Line 18: @@
 |Notes || text || further explanations, eg why the error was not corrected or why it is a false positive
 |}
+=== List of cross-checks that use L_Problems ===
+{{#cargo_query:
+tables=DataIntegrityChecks,Discussions,_pageData
+|join on=DataIntegrityChecks._pageName=_pageData._pageName,DataIntegrityChecks._pageName=Discussions._pageName
+|fields=
+DataIntegrityChecks._pageName=page, Status, Timing, Summary, Status
+|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
+|limit=20
+|more results text=Link to table of cross-checks that use L_Problem table to exclude false-positives
+|default=Nothing found
+|format=dynamic table
+|rows per page=20
+}}
 == Related Articles ==
 {{Related Articles}}
-[[Category: Data structure]]
+[[Category:Data structure]]
-[[Category: Data Processing]]
+[[Category:Data Processing]]
 [[Category:Data Processing]]
 [[Category:Centralized data front end.accdb]]
-[[Category:Centralized data.mdb]]
+[[Category:Centralized_data.accdb]]