Known data errors: Difference between revisions

(3 intermediate revisions by the same user not shown)

Line 13:

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

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

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

{{#ask: [[DICLProblem::~~True~~]]

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

|?DICStatus = Status

|?DICLProblem = problem

|sort=Modification date

|order=ascending

Line 24:

Line 25:

}}

==~~Location~~ of ~~List of old~~ known errors==

Cargo

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

{{#cargo_query:

~~M:\GAPS_OVERLAP_OVERS~~

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

}}

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

[[Category:Data Processing]]

@@ Line 13: / Line 13: @@
 == List of queries that use [[L_Problem table]] (SMW) ==
-(Based on [[Property:DICLProblem]] as set in [[Template:Data Integrity Check]].)
+(Based on [[Property:DICLProblem]], [[Property:DICStatus]] as set in [[Template:Data Integrity Check]].)
-{{#ask: [[DICLProblem::True]]
+{{#ask: [[DICStatus::not entered||implemented||ready to implement||needs review]] [[DICLProblem::true]]
   |?DICStatus = Status
+ |?DICLProblem = problem
   |sort=Modification date
   |order=ascending
@@ Line 24: / Line 25: @@
 }}
-==Location of List of old known errors==
+Cargo
-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)
+{{#cargo_query:
-M:\GAPS_OVERLAP_OVERS
+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
+}}
+== 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]]