L Problem table: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) Created page with "'''L_Problem''' in Centralized_data.mdb contains known errors or false-positives. It is used for recording this information, and for excluding records from check queries...." |
Ttenbergen (talk | contribs) mNo edit summary |
||
| (11 intermediate revisions by 2 users 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. | |||
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]]. | ||
L_Problem contains the fields | L_Problem contains the fields | ||
{| | {| class="wikitable sortable" | ||
|- | |- | ||
| | !| 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 | |||
|} | |||
== 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]] | |||
Latest revision as of 15:11, 17 October 2024
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.
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 | One of the following:
|
| Notes | text | further explanations, eg why the error was not corrected or why it is a false positive |
Related Articles
| Related articles: |