Known data errors: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (→Instructions for adding a record: changed to .accdb, replaced: Centralized data front end.mdb → Centralized data front end.accdb) |
Ttenbergen (talk | contribs) m (→Location of List of old known errors: moved details to Gaps and overlaps) |
||
(4 intermediate revisions by the same user not shown) | |||
Line 10: | Line 10: | ||
== Instructions for using the table in queries == | == 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. | 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) == | ||
(Based on [[Property:DICLProblem]] as set in [[Template:Data Integrity Check]].) | |||
{{#ask: [[DICLProblem::True]] | |||
|?DICStatus = Status | |||
|sort=Modification date | |||
|order=ascending | |||
|limit=10000 | |||
|format=broadtable | |||
|link=all | |||
|class=sortable wikitable smwtable | |||
}} | |||
== | == Other known errors == | ||
* | We store information about some other known errors in the [[L_Problem table]]: | ||
* | * [[Gaps and overlaps]] | ||
* [[Lost/missing chart]] | |||
== Related articles == | |||
{{Related Articles}} | |||
[[Category: Data Processing]] | [[Category: Data Processing]] |
Latest revision as of 15:41, 2022 March 31
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)
(Based on Property:DICLProblem as set in Template:Data Integrity Check.)
Other known errors
We store information about some other known errors in the L_Problem table:
Related articles
Related articles: |