CCMDB.accdb Data Integrity Checks

From CCMDB Wiki
Jump to navigation Jump to search

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: 109

 Statusquestionswho
Sub Dx Checkerimplemented
Query check CCI TISS NrDays LT LOSimplemented
Query check CCI TISS NrDays GT LOSimplemented
Query check CCI TISS if no then noneimplemented
Query check tmp Service and Boarding Loc during admission timeframeimplemented
Query check tmp service and program consistencyimplemented
Query check tmp service or location duplicateimplemented
Query check has transfer ready date or checkboximplemented
  • This check doesn't seem to catch when a time is entered without a date. It would be good to update that. Don't have time right now, so leaving a note. Email exchange 2024-11-14. Ttenbergen 12:12, 2024 November 15 (CST)
Tina
Query s tmp Boarding Loc date itemimplemented
Query check_ICD10_ESRD_and_AKI_only_if_transplantimplemented
Query send check centralized is ownerimplemented
Query check CCI TISS Vented without mechanismimplemented
Query s tmp ABO TEE checksimplemented
Query check transfer DtTm during admissionimplemented
Query s tmp IICU consult dispo to IICU but no tmpimplemented
Query check CCI TISS Intubation vs Intubatedimplemented
Check function Validate Pre Acute Living Situationimplemented
Query check ICD10 CLI vs CCI CentralLineimplemented
Check Sub PharmCheckimplemented
Check function previous NE Locationimplemented
Check function preAdmit NE Locationimplemented
Check function location NE dispoimplemented
Check function Validate First nameimplemented
Check function Validate Last nameimplemented
Check Function Validate PostalCodeimplemented
Query check_ICD10_ESRD_vs_kidney_transplantimplemented
Query s tmp Boarding Loc ER delay reasonableimplemented
Function Validate DOBimplemented
Query check_Project_OT_PT_Consultsimplemented
query check_Project_Consults_dataimplemented
Query check ACP Status Collectionimplemented
Query check LAU collection readmission dataimplemented
Query s_tmp_AHC_consistentimplemented
Query s tmp EuroSCORE II checksimplemented
Query check CCI Component no admin entriesimplemented
Query check tmp BedHeldimplemented
Query check ICD10 trach create but no TISSimplemented
Query Check BL TR combiner nullimplemented
Query check Transfer DtTm after paired BL and before later BLimplemented
Query check ICD10 chronic vent acute resp failureimplemented
Query check no consecutive same BL or Serviceimplemented
Query check CCI vs LOS count days picklistimplemented
Query check CCI TISS discontinuous ETTimplemented
Query check CCI vs LOS count days componentimplemented
Query check CCI TISS matching BoardingLoc timeimplemented
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 Boarding Loc Service first sameimplemented
Query s tmp check Boarding Loc and TransferReadyDtTm pairsimplemented
Query s tmp check combined Boarding Loc and TransferReadyDtTmimplemented
  • This doesn't catch duplicate Transfer Ready DtTm tmp entry for Boarding Loc on incompletes. That is probably fine since we don't use the incompletes, but it could be added the next time the check is worked on anyway.
Tina
Check APACHE physiological variable high lowimplemented
Query check tmp generate allowedimplemented
Query check pt from ERimplemented
Query check prev pre-admit consistentimplemented
Function Validate Previous Locationimplemented
Function Validate Pre admit Inpatient Institutionimplemented
Query check minimal data set incompleteimplemented
Query check ICD10 trach dxs consistentimplemented
Query check AIDS vs HIVimplemented
Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogenimplemented
Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infectionimplemented
Check Inf Infection with implied pathogen must not have a pathogen combined codeimplemented
Query check ICD10 Inf Infection req Pathogen must have oneimplemented
Query check CCI must have entryimplemented
Query check ICD10 mechanism vs traumaimplemented
Query check hernia type vs complicationimplemented
Query check ICD10 awaiting has Transfer Ready DtTmimplemented
Query check cooling vs arrestimplemented
Query check CCI Dateimplemented
Query check ICD10 dx implying death must have appropriate dispoimplemented
Query check ICD10 trach has trach but no TISSimplemented
Query check CCI TISS Pharm Vasoactiveimplemented
Query check CCI ICD10 Dialysis no Dximplemented
Check duplicate patientimplemented
Date of Birthimplemented
Query s tmp apostrophe in commentimplemented
Query check ICD10 only 1 stage of renal failureimplemented
Query check CCI Picklist if no admin entriesimplemented
Query check CCI if no then noneimplemented
Query check CCI Picklist duplicatesimplemented
Query check CCI Component duplicatesimplemented
Query check CCI Component unfilledimplemented
Query check CCI Picklist unfilledimplemented
Query check ICD10 Comorbids NoComo code but othersimplemented
Query check ICD10 Comorbids Dx presentimplemented
Query check ICD10 unfilledimplemented
Query check ICD10 dateimplemented
Query check dx primary not exactly oneimplemented
Query check CCI from OR no CCIimplemented
Query check CCI component 1 and 2 compatibleimplemented
Function Validate Dispoimplemented
Function Validate Provinceimplemented
Function Validate Chartimplemented
Query check dx primary lowest priorityimplemented
Function PHIN same as Chartimplemented
Function Validate PHINimplemented
Query s tmp QASeptic tmp no dximplemented
Query s tmp QASeptic Dx no tmp ICD10implemented
query s_tmp_project_item_consistentimplemented
Query Check_VADT_too_close_to_first_boarding_locneeds review

We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT)

  • SMW


  • Cargo


  • Categories

We discussed this in our after-Task meeting 2023-07-23 and I just stumbled across it. I do not remember what this was about, nor what a reasonable delay would be. Could one of you fill in the details for the query if we still want it? No hurry. In fact I'd prefer if you not hurried ;-). Ttenbergen 21:38, 13 August 2025 (CDT) 		Julie
Lisa
Query check_tmp_Overstay2needs reviewothers?Julie
Query check_tmp_AHCneeds review
  • I implemented 'item must not be "not entered" and 40 records in the data I had at the time a "not entered" in complete data. Did I misunderstand the instructions? Or are these correct instructions and should be implemented as that?


    • JALT

    • if there is referral sent there must be a referral received entry and a consult dealt with entry Lisa Kaita 11:31, 7 August 2025 (CDT)
      • pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... Ttenbergen 16:26, 19 August 2025 (CDT)
      • this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this?
        • late answer: how did Julie analyze this? at the time all fields were mandatory, unless there was no consult, current status, collect consult sent and if no data found for this then use consult received. Lisa Kaita 12:59, 13 January 2026 (CST)
        • I don't know, flagging for Julie and putting this on the JALT agenda; collection is still going, so we may still want to implement this. Ttenbergen 14:58, 13 January 2026 (CST)
    		Julie
    Lisa
    Query s_tmp_MRneeds review
    Function long LOS()needs review
    Query check CCI each count vs LOSneeds review
    Query check long transfer delayneeds review
    Query Check_from_ED_and_prev_location_same_siteready to implement

    Click here to see all checks including retired and declined ones

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