Data Integrity Checks

From CCMDB Wiki
Revision as of 11:54, 14 August 2018 by Ttenbergen (talk | contribs) (Created page with "The Critical Care and Medicine Database has many data integrity checks built into our data collection process. This page is an index to our documentation for those. We try t...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

The Critical Care and Medicine Database has many data integrity checks built into our data collection process. This page is an index to our documentation for those.

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

  1. CCMDB Data Integrity Checks - run in CCMDB.mdb and notify Data Collector during the collection process
  2. CFE Data Integrity Checks - run in Centralized data front end.accdb as part of the Data Processor's job
  3. 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.

Template: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)

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Data_Integrity_Checks&oldid=118641"