Known data errors: Difference between revisions
Ttenbergen (talk | contribs) m m |
Ttenbergen (talk | contribs) m m |
||
| Line 1: | Line 1: | ||
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. | 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 == | == Instructions for adding a record == | ||
| 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. | ||
==Location of List of old known errors== | ==Location of List of old known errors== | ||
| Line 17: | Line 17: | ||
== to do == | == to do == | ||
* | * need to discuss linking queries with Pagasa when she is back from vacation Jul 21. | ||
* Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc. | * Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc. | ||
[[Category: Data Processing]] | [[Category: Data Processing]] | ||
Revision as of 15:22, 24 June 2015
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.mdb
- 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.
Location of List of old known errors
The Data processor keeps an Excel workbook that includes: reason some profiles are missing data elements (APACHE - 8 ICU profiles), gaps in database because of deletions including reasons for deletions, overlaps, overs. Example missing all APACHE elements in TMSX, MedTMS and reason why could never be obtained.18:01, 2014 May 2 (CDT) M:\GAPS_OVERLAP_OVERS
to do
- need to discuss linking queries with Pagasa when she is back from vacation Jul 21.
- Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.