CCMDB Wiki

Data Integrity Checks: Difference between revisions

← Older edit
m Text replacement - "cross check " to "cross check "
 
(14 intermediate revisions by the same user not shown)
Line 2: Line 2:


We try to run the checks as early in the collection process as possible:  
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
# [[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
# [[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]] ==
 
{{Discussion}} We should review [[:Category:Multiple encounter longitudinal consistency check]] while working this out. Ttenbergen 18:36, 2018 August 16 (CDT)
 
== Making a new cross check ==
* search the wiki to see if this already exists
* 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
* if not, make a new page with a self-explanatory name that follows any conventions we might use
* add [[Template:Data Integrity Check]] at the top of the page
* 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


== SMW List ==
== List of Data Integrity Checks (SMW) ==
Using [[Template:Data Integrity Check]], being applied to checks as I review them for move to [[ICD10]]/[[CCI]].
Current number of Data Integrity Checks: {{#ask: [[DICApp::+]] |format=count }}
|?DICRelatedConcepts = Related concepts


Current number of Data Integrity Checks: {{#ask: [[DICApp::+]] |format=count }}
{{#ask: [[Category:Data Integrity Checks]]  
{{#ask: [[Category:Data Integrity Checks]]  
  |?DICSummary=Summary
  |?DICSummary=Summary
  |?DICStatus = Status
  |?DICStatus = Status
  |?DICApp = App
  |?DICApp = App
|?Category
  |sort=DICStatus  
  |sort=DICStatus  
  |order=ascending
  |order=ascending
Line 31: Line 29:
}}
}}


== Cross checks that need review ==
== Checks under review ==
{{#ask: [[Category:Data Integrity Checks]] [[DICStatus::needs review]]
See [[Data Integrity Check under review]]
|?DICApp = App
|?Modification date
|sort=DICStatus
|order=ascending
|limit=1000
|format=broadtable
|link=all
|class=sortable wikitable smwtable
}}


[[Category:Data Integrity Checks | *]]
[[Category:Data Integrity Checks | *]]
[[Category:Tmp Project Infrastructure]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_Integrity_Checks"