Known data errors: Difference between revisions

Line 1:

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

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.

== 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

== ~~L_problems_table~~==

== Instructions for using the table in queries ==

~~see~~ [[L Problem]]

For every query, filter the [[L Problem]] table to only records related to that query and only list if null.

~~{{Potential Change}}~~

==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 ==

Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.

* Waiting for Pagasa to give me a query to test this with.

* Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.

[[Category: Data Processing]]

@@ Line 1: / Line 1: @@
-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)
+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.
+== 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
-== L_problems_table==
+== Instructions for using the table in queries ==
-see [[L Problem]]
+For every query, filter the [[L Problem]] table to only records related to that query and only list if null.
-{{Potential Change}}
 ==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 ==
-Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.
+* Waiting for Pagasa to give me a query to test this with.
+* Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.
 [[Category: Data Processing]]