Known data errors: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 10:

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

== List of queries that use [[L_Problem table]] (SMW) ==

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

(Based on [[Property:DICLProblem]], [[Property:DICStatus]] as set in [[Template:Data Integrity Check]].)

~~M:\GAPS_OVERLAP_OVERS~~

{{#ask: [[DICStatus::not entered||implemented||ready to implement||needs review]] [[DICLProblem::true]]

|?DICStatus = Status

|?DICLProblem = problem

|sort=Modification date

|order=ascending

|limit=10000

|format=broadtable

|link=all

|class=sortable wikitable smwtable

}}

== ~~to do~~ ==

Cargo

* need to discuss linking queries with Pagasa when she is back from vacation Jul 21.

{{#cargo_query:

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

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

}}

[[Category: Data Processing]]

== Other known errors ==

We store information about some other known errors in the [[L_Problem table]]:

* [[Gaps and overlaps]]

* [[Lost/missing chart]]

== Related articles ==

[[Category:Data Processing]]

@@ Line 10: / Line 10: @@
 == 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==
+== List of queries that use [[L_Problem table]] (SMW) ==
-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)
+(Based on [[Property:DICLProblem]], [[Property:DICStatus]] as set in [[Template:Data Integrity Check]].)
-M:\GAPS_OVERLAP_OVERS
+{{#ask: [[DICStatus::not entered||implemented||ready to implement||needs review]] [[DICLProblem::true]]
+ |?DICStatus = Status
+ |?DICLProblem = problem
+ |sort=Modification date
+ |order=ascending
+ |limit=10000
+ |format=broadtable
+ |link=all
+ |class=sortable wikitable smwtable
+}}
-== to do ==
+Cargo
-* need to discuss linking queries with Pagasa when she is back from vacation Jul 21.
+{{#cargo_query:
-* Discussion about 8 profiles missing all APACHE elements and specific reason why missing etc.
+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
+}}
-[[Category: Data Processing]]
+== 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]]