L Problem table: Difference between revisions

(23 intermediate revisions by the same user not shown)

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

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

L_Problem contains the fields

{| ~~border~~="1"

{| class="wikitable sortable"

~~|D_ID || unique record ID~~

|-

|~~Query~~ || ~~query from which to exclude this false positive~~

!| field

!| type

!| description

|-

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

|D_ID || long || unique record ID

|-

|Query || text || One of the following:

* query from which to exclude this false positive

* [[Known data errors#Other known errors]] documentation

|-

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

@@ 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.
+{{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]].
 L_Problem contains the fields
-{| border="1"
+{| class="wikitable sortable"
-|D_ID  || unique record ID
 |-
-|Query || query from which to exclude this false positive
+!| field
+!| type
+!| description
 |-
-|Notes || further explanations, eg why the error was not corrected or why it is a false positive
+|D_ID  || long || unique record ID
+|-
+|Query || text || One of the following:
+* query from which to exclude this false positive
+* [[Known data errors#Other known errors]] documentation
+|-
+|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.accdb]]