CCMDB Wiki

CCMDB.accdb Data Integrity Checks

Revision as of 12:01, 22 September 2019 by Ttenbergen (talk | contribs) (Text replacement - "CCMDB.mdb" to "CCMDB.accdb")

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

 Statusquestionswho
Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysdeclined
Controlling Dx Type for ICD10 codesdeclined
Query check CCI TISS spont breath no tubedeclined
Query check CCI TISS CAM positive vs Dxdeclined
Query check ICD10 Inf Potential Infection must have pathogen or altdeclined
Query check CCI TISS time means must be twodeclined
Can't check ICD10 ARF vs APACHE ARFdeclined
Query check ICD10 duplicatesdeclined
Query TISS Errors NrTISSDays NE LOSdeclined
Check pre acute consistentdeclinedJALT
  • Julie found data discrepancies and asked if we could review doing cross checks at least on records with the same Visit Admit DtTm for the following fields:
  • We reviewed a broader cross check proposal (link below) in some detail in a version available in the history of this page], so if we consider adding this we should confirm that none of those apply to any checks. Or we can ignore and just implement as soft-checks. Thoughts? Ttenbergen 12:28, 17 December 2025 (CST)
all
Query check ICD10 strokedeclined
Query check_tmp_ER_Boarding_Loc_should_exist_if_from_ERdeclined
Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmdeclined
Query NDC Dialysis TISS CCIdeclined
Query check TISS each daydeclined
Query s tmp ABO TEE checksimplemented
Check function Validate Pre Acute Living Situationimplemented
Query check CCI TISS Intubation vs Intubatedimplemented
Query s tmp IICU consult dispo to IICU but no tmpimplemented
Sub Dx Checkerimplemented
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 check CCI TISS Vented without mechanismimplemented
    Query send check centralized is ownerimplemented
    Query check_ICD10_ESRD_and_AKI_only_if_transplantimplemented
    Query s tmp Boarding Loc date itemimplemented
    Query check CCI TISS if no then noneimplemented
    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 check ICD10 only 1 stage of renal failureimplemented
    Query check CCI must have entryimplemented
    Query check CCI Picklist if no admin entriesimplemented
    Query check CCI if no then noneimplemented
    Query check CCI Picklist duplicatesimplemented
    Query check CCI TISS discontinuous ETTimplemented
    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 s tmp Boarding Loc ER delay reasonableimplemented
    Query check no consecutive same BL or Serviceimplemented
    Query check CCI vs LOS count days picklistimplemented
    Query check tmp service or location duplicateimplemented
    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
    Query check transfer DtTm during admissionimplemented
    Query check CCI TISS NrDays LT LOSimplemented
    Query check CCI TISS NrDays GT LOSimplemented
    Query check ICD10 chronic vent acute resp failureimplemented
    Query check tmp Service and Boarding Loc during admission timeframeimplemented
    Query check tmp service and program consistencyimplemented
    Query check ICD10 Inf Infection req Pathogen must have oneimplemented
    Query s tmp apostrophe in commentimplemented
    query s_tmp_project_item_consistentimplemented
    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 CCI Component unfilledimplemented
    Check APACHE physiological variable high lowimplemented
    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 QASeptic Dx no tmp ICD10implemented
    Function Validate Dispoimplemented
    Query check CCI component 1 and 2 compatibleimplemented
    Query check CCI from OR no CCIimplemented
    Query check dx primary not exactly oneimplemented
    Function Validate Provinceimplemented
    Function Validate Chartimplemented
    Query check dx primary lowest priorityimplemented
    Function PHIN same as Chartimplemented
    Query check ICD10 dateimplemented
    Query check ICD10 unfilledimplemented
    Function Validate PHINimplemented
    Query s tmp QASeptic tmp no dximplemented
    Query check ICD10 Comorbids Dx presentimplemented
    Query check ICD10 Comorbids NoComo code but othersimplemented
    Query check CCI Picklist unfilledimplemented
    Query check CCI Component duplicatesimplemented
    Query check long transfer delayneeds review
    Query check CCI each count vs LOSneeds review
    Function long LOS()needs review
    Query s_tmp_MRneeds review
    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 check_tmp_Overstay2needs reviewothers?Julie
    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 ICD10 ESRD vs ARFnot feasible
    Check organ donors must be deadnot feasible
    Query s tmp Borrow no borrow on own unitnot feasible
    Query Check_from_ED_and_prev_location_same_siteready to implement
    Query check ApARF CRFretired
    Function Dispo Chronological()retired
    Check eliminated dxretired
    Check BRR/XBR vs cardiac arrest dxretired
    Query s tmp Borrow duplicatesretired
    Query check overstay not enteredretired
    Query check trach dx taskretired
    Query Check Renal IncompatibleDxsretired
    Query s tmp QAInf basicretired
    Query s tmp IICU consult DtTmretired
    Query s tmp comfort care gt oneretired
    Query s tmp QAInf dx no tmpretired
    Query s tmp QAInf tmp no dxretired
    Query s tmp QAInf LT 48 hrs after admitretired
    Check Function Panelling admit transfer sameretired
    Function Validate Transfer Ready DtTmretired
    Function Transfer Ready DtTm vs statusretired
    Check Accept Loc Parkretired
    Query check tmp Transfer Ready not before Boarding Locretired
    Query check overstay no colourretired
    Query check overstay pt from our medretired
    Check AcceptDtTm entered or missing checkedretired
    Query check dispo lower acuity than locationretired
    Query s tmp Borrow sensible DtTm vs no borrowretired
    Query s tmp check combined BL and TRDtTm nonsequentialretired
    Query check CCI CRRT vs Tmpretired
    Query check previous location vs service inconsistentretired
    Function Validate previous serviceretired
    Query s tmp Boarding Loc no borrow but entryretired
    Query check VAP admit must be from ICUretired
    Query check transfer ready tmp for each Boarding Locretired
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.accdb_Data_Integrity_Checks&oldid=139668"