Data Integrity Checks: Difference between revisions

(23 intermediate revisions by the same user not shown)

Line 2:

We try to run the checks as early in the collection process as possible:

# [[CCMDB Data Integrity Checks]] - run in [[CCMDB.~~mdb~~]] and notify [[Data Collector]] during the collection process

# [[CCMDB.accdb Data Integrity Checks]] - run in [[CCMDB.accdb]] and notify [[Data Collector]] during the collection process

# [[CFE Data Integrity Checks]] - run in [[Centralized data front end.accdb]] as part of the [[Data Processor]]'s job

# [[SAS Data Integrity Checks]] - run in SAS as part of the [[Statistician]]'s final clean up of the data before any reports or data requests are released

~~[[Template:~~Data Integrity Check~~]] is used~~ to ~~consistently document~~ the ~~checks so they populate our lists appropriately.~~

== Documenting a new cross check ==

* search the wiki to see if this already exists

* if not, make a new page with a self-explanatory name that follows any conventions we might use

* add <pre>{{Data Integrity Check}}</pre> at the top of the page and save

* click the "edit with form" tab at the top of the page to edit the Data Integrity Checks with a helpful form

{{~~Discussion~~}} yes, lots of red links for now, I will fix this up, it's just a starting point. We need a better way to track these as we implement the lot that needs to be added for ICD10 / CCI. Ttenbergen 12:54, 2018 August 14 (CDT)

== List of Data Integrity Checks (SMW) ==

Current number of Data Integrity Checks: {{#ask: [[DICApp::+]] |format=count }}

|?DICRelatedConcepts = Related concepts

~~{{Discussion}} We should review [[:Category:Multiple encounter longitudinal consistency check]] while working this out. Ttenbergen 18:36, 2018 August 16 (CDT)~~

{{#ask: [[Category:Data Integrity Checks]]

|?DICSummary=Summary

~~== SMW List ==~~

|?DICStatus = Status

~~using [[Template:Data Integrity Check]], being applied to checks as I review them for move to [[ICD10]]/[[CCI]].~~

|?DICApp = App

{{#ask: [[Category:Data Integrity Checks]] ~~[[DICApp::CCMDB.mdb]]~~

|?Category

|?~~Has IntegrityCheckStatus~~ = Status

|sort=DICStatus

|?~~Modification date~~

|sort=~~Modification date~~

|order=ascending

|limit=1000

Line 25:

Line 29:

}}

== Checks under review ==

See [[Data Integrity Check under review]]

[[Category:Data Integrity Checks | *]]

[[Category:Tmp Project Infrastructure]]

@@ Line 2: / Line 2: @@
 We try to run the checks as early in the collection process as possible:
-# [[CCMDB Data Integrity Checks]] - run in [[CCMDB.mdb]] and notify [[Data Collector]] during the collection process
+# [[CCMDB.accdb Data Integrity Checks]] - run in [[CCMDB.accdb]] and notify [[Data Collector]] during the collection process
 # [[CFE Data Integrity Checks]] - run in [[Centralized data front end.accdb]] as part of the [[Data Processor]]'s job
 # [[SAS Data Integrity Checks]] - run in SAS as part of the [[Statistician]]'s final clean up of the data before any reports or data requests are released
-[[Template:Data Integrity Check]] is used to consistently document the checks so they populate our lists appropriately.
+== Documenting a new cross check ==
+* search the wiki to see if this already exists
+* if not, make a new page with a self-explanatory name that follows any conventions we might use
+* add <pre>{{Data Integrity Check}}</pre> at the top of the page and save
+* click the "edit with form" tab at the top of the page to edit the Data Integrity Checks with a helpful form
-{{Discussion}} yes, lots of red links for now, I will fix this up, it's just a starting point. We need a better way to track these as we implement the lot that needs to be added for ICD10 / CCI. Ttenbergen 12:54, 2018 August 14 (CDT)
+== List of Data Integrity Checks (SMW) ==
+Current number of Data Integrity Checks: {{#ask: [[DICApp::+]] |format=count }}
+ |?DICRelatedConcepts = Related concepts
-{{Discussion}} We should review [[:Category:Multiple encounter longitudinal consistency check]] while working this out. Ttenbergen 18:36, 2018 August 16 (CDT)
+{{#ask: [[Category:Data Integrity Checks]]
+  |?DICSummary=Summary
-== SMW List ==
+ |?DICStatus = Status
-using [[Template:Data Integrity Check]], being applied to checks as I review them for move to [[ICD10]]/[[CCI]].
+  |?DICApp = App
-{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.mdb]]
+ |?Category
-  |?Has IntegrityCheckStatus = Status
+  |sort=DICStatus
-  |?Modification date
-  |sort=Modification date
   |order=ascending
   |limit=1000
@@ Line 25: / Line 29: @@
 }}
+== Checks under review ==
+See [[Data Integrity Check under review]]
 [[Category:Data Integrity Checks | *]]
+[[Category:Tmp Project Infrastructure]]