CCMDB.accdb Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 4: Line 4:


== CCMDB Data Integrity Checks (SMW) ==
== CCMDB Data Integrity Checks (SMW) ==
Current number of CCMDB.accdb Data Integrity Checks: {{#ask: [[DICApp::CCMDB.accdb]] |format=count }}
Current number of CCMDB.accdb Data Integrity Checks: {{#ask: [[DICApp::CCMDB.accdb]] [[DICStatus::!retired]] [[DICStatus::!declined]] |format=count }}
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]]
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]] [[DICStatus::!retired]] [[DICStatus::!declined]]
  |?DICStatus = Status
  |?DICStatus = Status
  |?DiscussQuestion = questions
  |?DiscussQuestion = questions
Line 16: Line 16:
  |class=sortable wikitable smwtable
  |class=sortable wikitable smwtable
}}
}}
{{#ask: [[Category:Data Integrity Checks]] [[DICApp::CCMDB.accdb]]
|?DICStatus = Status
|?DiscussQuestion = questions
|?DiscussWho = who
|limit=0
|searchlabel=Click here
}}  to see all checks including retired and declined ones


== Related articles ==  
== Related articles ==  

Revision as of 17:10, 2021 January 27

This page lists pages that have CCMDB Data Integrity Checks on them, the status of those checks if available, and the page's last modification date.

See Template:Data Integrity Check for how to get things on this list.

CCMDB Data Integrity Checks (SMW)

Current number of CCMDB.accdb Data Integrity Checks: 101

 Statusquestionswho
Check APACHE physiological variable high lowimplemented
Query check minimal data set incompleteimplemented
Function Validate Previous Locationimplemented
Query check prev pre-admit consistentimplemented
Query s tmp project item consistentimplemented
Query s tmp apostrophe in commentimplemented
Function Validate PHINimplemented
Function PHIN same as Chartimplemented
Function Validate Provinceimplemented
Date of Birthimplemented
Function Validate Dispoimplemented
Query check dx primary not exactly oneimplemented
Query check dx primary lowest priorityimplemented
Query check ICD10 dateimplemented
Query check ICD10 unfilledimplemented
Query check CCI Dateimplemented
Query check CCI Component unfilledimplemented
Query check CCI Picklist unfilledimplemented
Query check CCI component 1 and 2 compatibleimplemented
Check Function Validate PostalCodeimplemented
Check function Validate Last nameimplemented
Check function Validate First nameimplemented
Check function location NE dispoimplemented
Check function previous NE Locationimplemented
Check Sub PharmCheckimplemented
Check duplicate patientimplemented
Check function Validate Pre Acute Living Situationimplemented
Query check cooling vs arrestimplemented
Query check hernia type vs complicationimplemented
Query check AIDS vs HIVimplemented
Query s tmp QASeptic tmp no dximplemented
Query check ICD10 Comorbids NoComo code but othersimplemented
Query check ICD10 Comorbids Dx presentimplemented
Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogenimplemented
Check Inf Infection with implied pathogen must not have a pathogen combined codeimplemented
Function Validate Chartimplemented
Sub Dx Checkerimplemented
Query check_ICD10_ESRD_vs_kidney_transplantimplemented
Function Validate Pre admit Inpatient Institutionimplemented
Query check CCI Picklist duplicatesimplemented
Query check CCI Component duplicatesimplemented
Query s tmp QASeptic Dx no tmp ICD10implemented
Query s tmp ABO TEE checksimplemented
Check function preAdmit NE Locationimplemented
Query s tmp IICU consult dispo to IICU but no tmpimplemented
Query send check centralized is ownerimplemented
Query check ICD10 mechanism vs traumaimplemented
Query check ICD10 Inf Infection req Pathogen must have oneimplemented
Query check ICD10 only 1 stage of renal failureimplemented
Query check ICD10 chronic vent acute resp failureimplemented
Query check CCI from OR no CCIimplemented
Query check tmp generate allowedimplemented
Query s tmp Boarding Loc date itemimplemented
Query check tmp service or location duplicateimplemented
Query check tmp service and program consistencyimplemented
Query check CCI if no then noneimplemented
Query check CCI TISS NrDays GT LOSimplemented
Query check CCI TISS NrDays LT LOSimplemented
Query check CCI TISS if no then noneimplemented
Query check ICD10 dx implying death must have appropriate dispoimplemented
Query check CCI TISS Intubation vs Intubatedimplemented
Query check CCI TISS Vented without mechanismimplemented
Query check transfer DtTm during admissionimplemented
Query check CCI TISS Pharm Vasoactiveimplemented
Query s tmp check combined Boarding Loc and TransferReadyDtTmimplemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairsimplemented
Query check tmp Boarding Loc Service first sameimplemented
Query check has transfer ready date or checkboximplemented
Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infectionimplemented
Query check ICD10 awaiting has Transfer Ready DtTmimplemented
Query check eliminated ICD10implemented
Query check eliminated CCI Pickimplemented
Query check eliminated CCI Compimplemented
Query check tmp 2 BL TR S same tmimplemented
Query check tmp Service and Boarding Loc during admission timeframeimplemented
Query check pt from ERimplemented
Query check CCI ICD10 Dialysis no Dximplemented
Query check CCI must have entryimplemented
Query check CCI vs LOS count days componentimplemented
Query check CCI vs LOS count days picklistimplemented
Query check CCI TISS discontinuous ETTimplemented
Query check CCI TISS matching BoardingLoc timeimplemented
Query s tmp Boarding Loc ER delay reasonableimplemented
Query Check BL TR combiner nullimplemented
Query check no consecutive same BL or Serviceimplemented
Query check Transfer DtTm after paired BL and before later BLimplemented
Query check CCI Component no admin entriesimplemented
Query check ICD10 trach has trach but no TISSimplemented
Query check ICD10 trach create but no TISSimplemented
Query check ICD10 CLI vs CCI CentralLineimplemented
Query check ICD10 trach dxs consistentimplemented
Query check_ICD10_ESRD_and_AKI_only_if_transplantimplemented
Query check tmp BedHeldimplemented
Query s tmp EuroSCORE II checksimplemented
Query check CCI Picklist if no admin entriesimplemented
Query check long transfer delayneeds review
Function long LOS()needs review
Query check CCI CXR vs LOSneeds review
  • Just came across this... the started query includes additional dxs now, as per #CCI collect count each. Does the proposed accepted count make sense for all the dxs? Your validation table was for CXR. Ttenbergen 11:50, 2023 May 3 (CDT)
    • Did some checking on all 13 LAB Imaging from CCI picklist and found counts more than the LOS only in ECHO, AXR and CXR. Emailed Lisa and Pagasa March 14, 2024 to check if correct or not. Waiting for their feedbacks. In the email, I also propose another query (e.g. the counts per calendar day per patient must not be more than one) as alternative to the threshold limits LOS +- 3 STD shown below. --JMojica 10:55, 2024 March 18 (CDT)
      • That query is tighter and would therefore have more false positives. What does Lisa think about that? Ttenbergen 09:51, 2024 March 20 (CDT)
        • I made some limits per LOS group for CXR, AXR, ECHO and Blood gases and emailed the results to Tina and Lisa 3/25/2024 for discussion. ---JMojica 13:28, 2024 March 25 (CDT)
          • Further emails with Julie and Lisa about details. Discussed with Lisa who is reviewing some of the errors and will hold off until she is done. Ttenbergen 12:46, 2024 April 8 (CDT)
all
Check organ donors must be deadnot feasible
Query s tmp Borrow no borrow on own unitnot feasible
Query check ICD10 ESRD vs ARFnot feasible

Click here to see all checks including retired and declined ones

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks&oldid=148899"