Data Integrity Checks

From CCMDB Wiki

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.mdb 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

Documenting a new cross check

  • 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
  • add
    {{Data Integrity Check}}
    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

List of Data Integrity Checks (SMW)

Current number of Data Integrity Checks: 155

 SummaryStatusAppDICRelatedConceptsCategory
Minimum combined codesSome ICD10s must always be coded as Combined ICD10 codes with at least a certain number of other codes.declinedCCMDB.mdbCombined ICD10 codes
Has MinimumCombinedCodes
Data Integrity Checks
CCMDB.mdb
Legacy Content
Query NDC VAP no TISSIf a patient has a Acquired Diagnosis Pneumonia, ventilator-associated (VAP) and no TISS28 items Invasive Mechanical Ventilation (TISS Item) (T18) then this is an error.declinedCentralized data front end.accdbPneumonia, ventilator-associated (VAP)
Invasive Mechanical Ventilation (TISS Item)
Spontaneous breathing via ETT or Trach (TISS Item)
Data Integrity Checks
Centralized data front end.accdb
Questions
TISS28 checks
Data Processing
VAP - Ventilator Associated Pneumonia
Check APACHE physiological variable high lowan APACHE physiological variable is extremely high or lowimplementedCCMDB.mdbAaDO2
AP Dias BP Field
AP Sys BP Field
Creatinine (APACHE)
FiO2
HCT
HR
K
Na
PCO2
PH
PO2
RR
Serum CO2
Temperature
WBC
Data Integrity Checks
CCMDB.mdb
APACHE II Physiological Variables
APACHE check
Function long LOS()LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).implementedCCMDB.mdbLOS
Arrive DtTm field
Dispo DtTm field
2016 Time and Place changes
Length of stay
Data Integrity Checks
CCMDB.mdb
Site/Location check
Registry checks
Query check minimal data set incompletemakes sure the Minimal Data Set is collected before records can be sent.implementedCCMDB.mdbMinimal Data Set
Serial number
Service/Location field
FirstName field
LastName field
PHIN field
Chart number
Arrive DtTm field
Overstay Predictor Project Collection Instructions
Overstay Predictor Project
Data Integrity Checks
CCMDB.mdb
Registry checks
Query check overstay no colourMed pts must have Overstay coloursimplementedCCMDB.mdbOverstay Predictor Project Collection Instructions
Overstay Predictor Project
Data Integrity Checks
CCMDB.mdb
OverstayProject
Tmp check
Query check overstay pt from our medpts from a location where we collect should not have Overstay colourimplementedCCMDB.mdbOverstay Predictor Project Collection Instructions
Overstay Predictor Project
Data Integrity Checks
CCMDB.mdb
OverstayProject
Tmp check
Function Validate Previous Locationvalidates Previous Location field: implementedCCMDB.mdbPrevious Location fieldData Integrity Checks
CCMDB.mdb
Registry checks
Query check previous location vs service inconsistentpatients with Previous Location field in medicine must have Previous Service field medicine; ICU (except STB ACCU, STB CICU/ICCS) must have previous service "critical care".implementedCCMDB.mdbPrevious Location field
Previous Service field
Data Integrity Checks
CCMDB.mdb
Registry checks
Query check prev pre-admit consistentfor inpatient transfers within the region, Previous Location field and Pre-admit Inpatient Institution field should be same.implementedCCMDB.mdbPrevious Location field
Pre-admit Inpatient Institution field
Data Integrity Checks
CCMDB.mdb
Registry checks
Function Validate previous serviceValidates Previous Service field: can't be empty/blankimplementedCCMDB.mdbPrevious Service fieldData Integrity Checks
CCMDB.mdb
Registry checks
Query check tmp generate allowedcheck that tmp project/item combo exists for this location in OverstayimplementedCCMDB.mdbOverstay Predictor Project Collection Instructions
Overstay Predictor Project
Data Integrity Checks
CCMDB.mdb
OverstayProject
Tmp check
Query s tmp project item consistentChecks that tmp project entries only contain combinations of project and item that are allowed.implementedCCMDB.mdbTmp Project CollectionData Integrity Checks
CCMDB.mdb
TmpV2
Tmp check
Query s tmp apostrophe in commentThere must not be apostrophes in the comment field as they would mess with Julie's data analysis.implementedCCMDB.mdbACCU borrow
ACP Status collection in ICU
Accept Loc Park
AcceptDateSource
Alias ID collection
Allied Health Consults
Arrest Witnessing
CCU Service Tracking
CRRT
Cardiac Arrest Cooling Protocol
Catheter09
Comfort Care
Creating a new project article
Decubitus Ulcer Study
DeviceUse Study
Early ID study
EuroScore
H1N1
IABP project
ICUotherService
Influenza tracking
Influenza treated
Medical Incompetency tracking
Moves for Medicine
Overstay Predictor Project
Peer Audit
Project ABO TEE
Project Borrow arrive
Projects
QA Infection CLI
QA Infection VAP
QA Septic Shock
Septic Shock Order Set
SmartPump Audit
Transfusion Audit
Query check CCI CRRT vs Tmp
Query check tmp generate allowed
Query s tmp QASeptic tmp no dx
Query s tmp apostrophe in comment
Check overstay not entered
Query check overstay no colour
Query check overstay pt from our med
Query s tmp project item consistent
IICU consult
Query NDC zCRRT TISS no tmp
Query NDC zCRRT tmp no TISS
Query s tmp IICU consult DtTm
Query s tmp IICU consult not paired
Query s tmp QASeptic Dx no tmp ICD10
Bed Census Data Processing Instructions
Bed census.mdb
File:BedCensusAnnouncement Letter May 2012.pdf
Catheter09 Wednesday, November 25, 2009
Catheter09 Wednesday, October 28.09
Contacting Quality Officer and Manager for VAPs and CLIs
Critical Care Vital Signs Monitoring
Family Satisfaction in the Intensive Care Unit
File:Form Individual Site Bed example .pdf
File:Form Site Bed Data Summary.pdf
L TmpV2 table
Legacy Processing Instructions Bed census.mdb
List of Factor affecting data quality
Peer Audit Partners
Programmer-Peer Audit output problem table
QA Infection
Query s tmp ABO TEE checks
Re-import of TmpV2 data from Julie's Export 2014-09-08
Re-import of TmpV2 data from Julie's Export 2014-09-18
Re-import of TmpV2 data from Julie's Export 2014-09-22
Re-import of TmpV2 data from Julie's Export 2014-09-25
Staphylococcus aureus
TMP dates imported backwards
Temporary study guidelines
Transfer Delay
VAP - Ventilator Associated Pneumonia
WRHA Outcomes Improvement Team
Query s tmp Borrow duplicates
Query s tmp Borrow no borrow on own unit
Query s tmp Borrow sensible DtTm vs no borrow
Query s tmp IICU consult dispo to IICU but no tmp
Function TmpChecker
Query NDC CLI AcqDX but NoCLI DateinTMPV2
Query NDC CLI No AcqDX but CLI DateinTMPV2
Data Integrity Checks
CCMDB.mdb
Tmp check
Function Validate PHIN
  • for patients with Province = MB, the PHIN has to be (> 100 000 000 and <= 130 000 000) or 999 999 999 (to accommodate PHIN_field#Location_Manitoba_and_no_PHIN
  • for out-of-province patients, the PHIN must be entered as blank
  • checks Function PHIN same as Chart
  • implementedCCMDB.mdbPHIN fieldData Integrity Checks
    CCMDB.mdb
    Registry checks
    Function PHIN same as ChartPHIN can't be the same as ChartimplementedCCMDB.mdbPHIN field
    Chart number
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Function Validate ProvinceValidates the Province field: implementedCCMDB.mdbProvince field
    PHIN field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Date of BirthThe minimum age allowed is 10, the maximum age allowed is 120.implementedCCMDB.mdbDate of BirthData structure
    Data Collection Guide
    Registry Data
    Demographics
    L Log table
    L PHI table
    Data Integrity Checks
    CCMDB.mdb
    CCMDB.mdb cross checks triggering for correct values
    Registry checks
    Function Validate Dispodoesn't allow emptyimplementedCCMDB.mdbDispo fieldData Integrity Checks
    CCMDB.mdb
    Registry checks
    Function Validate Transfer Ready DtTmdoesn't allow violation of function Transfer_Ready_DtTm_vs_statusimplementedCCMDB.mdbTransfer Ready DtTm field
    Function Transfer Ready DtTm vs status
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Function Transfer Ready DtTm vs statusIf Transfer_Ready_DtTm is blank, TR_info_status must not be; if TR_info_status has content, Transfer_Ready_DtTm must be blank.implementedCCMDB.mdbTransfer Ready DtTm field
    TR info status field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Query TISS Errors NrTISSDays NE LOSLength of stay (LOS) for all ICU patients must be consistent with their number of TISS days, incl no TISS days at all (ie missing forms).implementedTISS28.mdbLOS
    TISS
    Arrive DtTm field
    Dispo DtTm field
    Data Integrity Checks
    Data Processing
    Length of stay
    TISS28 checks
    Registry checks
    TISS28.mdb
    TISS28 Scanning Process
    Questions
    Query check dx primary not exactly oneThere has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit DiagnosisimplementedCCMDB.mdbDx Primary
    Admit Diagnosis
    Primary Admit Diagnosis
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Query check dx primary lowest priorityThe dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority.implementedCCMDB.mdbDx Primary
    Dx Priority
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Query check ICD10 dateAcquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Arrive_DtTm<Dx_Date<Dispo_DtTmimplementedCCMDB.mdbICD10 Diagnosis
    Acquired Diagnosis / Complication
    Admit Diagnosis
    Comorbid Diagnosis
    Dx Type
    Dx Date
    Dx Date unknown
    Arrive DtTm field
    Dispo DtTm field
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Query check ICD10 unfilledICD10 entry with missing Dx_Type, Dx_Priority or No Dx EnteredimplementedCCMDB.mdbDx Type
    Dx Priority
    No Dx Entered
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Query check CCI no admin entriesThere must be no No procedure entered/Blank procedure entry in CCI Picklist or CCI Component.implementedCCMDB.mdbCCI Picklist
    CCI Component
    No procedure entered
    Blank procedure entry
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Query check CCI if no then noneIf No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI ComponentimplementedCCMDB.mdbCCI Picklist
    CCI Component
    No procedure performed
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Query check CCI DatePx Date must be sensible when compared to Arrive_DtTm and Dispo_DtTmimplementedCCMDB.mdbPx Date
    Arrive DtTm field
    Dispo DtTm field
    Px Type
    Data Integrity Checks
    CCMDB.mdb
    CCI Px check
    Query check CCI Component unfilledCCI Component entry with missing px, Px_Type or Px_CountimplementedCCMDB.mdbCCI Component
    Px Count
    Px Type
    CCI
    CCI Px check
    Data Integrity Checks
    CCMDB.mdb
    Query check CCI Picklist unfilledCCI Picklist entry with missing px, Px_Type or Px_CountimplementedCCMDB.mdbCCI Picklist
    Px Type
    Px Count
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Query check CCI component 1 and 2 compatibleComponent CCIs must have compatible component 1 and component 2implementedCCMDB.mdbCCI ProcedureData Integrity Checks
    CCMDB.mdb
    CCI Px check
    Query check dispo lower acuity than locationcheck for patients going to lower level of care but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see #hierarchy of levels of care.implementedCCMDB.mdbTransfer Ready DtTm field
    Dispo field
    Data Integrity Checks
    CCMDB.mdb
    Questions
    ICD10 Dx check
    CCI Px check
    Site/Location check
    Check AcceptDtTm entered or missing checkedEither Accept DtTm field must have content or Accept DtTm missing field must be checked.implementedCCMDB.mdbAccept DtTm field
    Accept DtTm missing field
    Data Integrity Checks
    APACHE check
    Registry checks
    CCMDB.mdb
    Check Function Validate PostalCodeValidates that Postal Code field only contains characters in format allowed for a postal codeimplementedCCMDB.mdbPostal Code fieldData Integrity Checks
    Registry checks
    Postal Codes
    CCMDB.mdb
    Check function Validate Last name
  • can't be blank
  • can't start with a space
  • can't start with a hyphen
  • only allows letters, spaces and hyphens
  • implementedCCMDB.mdbLastName fieldData Integrity Checks
    Registry checks
    CCMDB.mdb
    Check function Validate First name
    • can't be blank
    • can't start with a space
    • can't start with a hyphen
    • only allows letters, spaces and hyphens
    implementedCCMDB.mdbFirstName fieldData Integrity Checks
    CCMDB.mdb
    Registry checks
    Check function location NE dispoService/Location field can't be same as Dispo fieldimplementedCCMDB.mdbService/Location field
    Dispo field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Check function previous NE LocationPrevious Location field can't be same as Service/Location fieldimplementedCCMDB.mdbService/Location field
    Previous Location field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Check Accept Loc Parkif Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry.
    if there is an Accept_Loc_park entry, then the Previous Location must be <your hospital> ER (parked) and Pre-admit Inpatient Institution must be "NA / not applicable"
    implementedCCMDB.mdbPrevious Location field
    Pre-admit Inpatient Institution field
    Accept Loc Park
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Check Sub PharmCheckchecks that every CC pt has at least one pharmacy record (possibly all zeros), that patients don't have drug days than LOS, disallows complete check if Arrive DtTm or Dispo DtTm are missing because that would break max count check,implementedCCMDB.mdbPharmacy collectionData Integrity Checks
    CCMDB.mdb
    Check duplicate patientthere are no dupliate entries for the same patient ward admission on the laptop at send timeimplementedCCMDB.mdbPHIN field
    Date of Birth
    Chart number
    FirstName field
    LastName field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    PL Diff Phin SameLN FN DOBChecks that there are no likely matches of this patient with a different PHIN (ie typos)implementedCentralized data front end.accdbPHIN field
    LastName field
    FirstName field
    Date of Birth
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    PL queries
    Data Processing
    PL SameCHART Site Diff PHINA record with this Chart number already exists for this service/Location and it has a different PHIN.implementedCentralized data front end.accdbChart number
    Service/Location field
    PHIN field
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    PL queries
    Data Processing
    PL SamePHIN Site Diff chartAnother record exists for this Service/Location with the same PHIN and a different Chart number.implementedCentralized data front end.accdbPHIN field
    Service/Location field
    Chart number
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    PL queries
    Data Processing
    Questions
    PL SamePhin Diff LN FN DOB SexAnother record exists with the same PHIN but a different LastName field, FirstName field, Date of Birth, SeximplementedCentralized data front end.accdbPHIN field
    LastName field
    FirstName field
    Date of Birth
    Sex field
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    PL queries
    Data Processing
    PL 1orphansRecord meets following conditions implementedCentralized data front end.accdbRecordStatus field
    SentDtTm field
    Service/Location field
    Data Integrity Checks
    Centralized data front end.accdb
    PL queries
    Data Processing
    PL 2Phin Fake or BlankFinds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.implementedCentralized data front end.accdbPHIN fieldRegistry checks
    Data Integrity Checks
    Centralized data front end.accdb
    PL queries
    Data Processing
    Link suspect negative transit time queryUsed in Correcting suspect links to find records where an earlier record for a patient with that PHIN has a Dispo DtTm that is later than the next record's Arrive DtTm.implementedCentralized data front end.accdbPHIN field
    Arrive DtTm field
    Dispo DtTm field
    Data Processing
    Multiple Encounter linking
    Data Integrity Checks
    Multiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Link suspect dead then alive queryUsed in Correcting suspect links to find records where an earlier record with that PHIN was listed as dispo field deceased, but a later entry then shows up.implementedCentralized data front end.accdbPHIN field
    Dispo DtTm field
    Data Processing
    Multiple Encounter linking
    Data Integrity Checks
    Multiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Link suspect mismatch from ours incomplete queryUsed in Correcting suspect links to find records where a later record with that PHIN has a Previous Location entry corresponding to one of our sites as per the s_dispo table.real_collection table, but an earlier corresponding entry doesn't exist for that location.implementedCentralized data front end.accdbPHIN field
    Previous Location field
    Data Processing
    Multiple Encounter linking
    Data Integrity Checks
    Multiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Link suspect mismatch to ours incomplete queryUsed in Correcting suspect links to find records where an earlier record with that PHIN has a dispo entry corresponding to one of our sites as per the s_dispo table.real_collection, but a later corresponding entry doesn't exist for that location.implementedCentralized data front end.accdbPHIN field
    Dispo field
    Data Processing
    Multiple Encounter linking
    Data Integrity Checks
    Multiple encounter longitudinal consistency check
    Centralized data front end.accdb
    Registry checks
    Questions
    Check function Validate Pre Acute Living Situationcan't be blankimplementedCCMDB.mdbPre acute living situation fieldData Integrity Checks
    CCMDB.mdb
    Registry checks
    Link suspect not same visitAdmitDtTm queryChecks for records that are likely part of the same admission but have different Visit Admit DtTm field.implementedCentralized data front end.accdbVisit Admit DtTm fieldData Integrity Checks
    Centralized data front end.accdb
    Registry checks
    Query check CCI CRRT vs TmpIf CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versaimplementedCCMDB.mdbCRRT (incl volume removal via PRISMA device)Data Integrity Checks
    CCMDB.mdb
    CCI Px check
    Tmp check
    Query check cooling vs arrestDue to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dximplementedCCMDB.mdbCardiac arrest
    Targeted Temperature Management (TTM)
    Data Integrity Checks
    CCMDB.mdb
    CCI
    ICD10
    Query check hernia type vs complicationany abdominal hernia complication dx must have an abdominal hernia type dx coded.implementedCCMDB.mdbHiatus (diaphragmatic) hernia
    Inguinal hernia
    Abdominal hernia, NOS
    Abdominal hernia, with obstruction, incarceration or strangulation
    Abdominal hernia, with gangrene
    Data Integrity Checks
    CCMDB.mdb
    Hernia
    ICD10 Dx check
    Query check AIDS vs HIVA record can not have both AIDS (disease due to HIV) and HIV infection, asymptomaticimplementedCCMDB.mdbAIDS (disease due to HIV)
    HIV infection, asymptomatic
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Query s tmp QASeptic tmp no dxCC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dximplementedCCMDB.mdbQA Septic Shock
    Septic Shock
    Shock, septic
    Data Integrity Checks
    CCMDB.mdb
    Tmp check
    ICD10 Dx check
    Old dx check
    PL Chart 9 DigitFinds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart numberimplementedCentralized data front end.accdbChart numberData Integrity Checks
    Centralized data front end.accdb
    Registry checks
    Questions
    PL queries
    Data Processing
    Query NDC zCRRT TISS no tmpRecord has CRRT (TISS Item) but no CRRT tmp entryimplementedCentralized data front end.accdbCRRT (TISS Item)
    CRRT
    Data Integrity Checks
    Centralized data front end.accdb
    Tmp check
    TISS28 checks
    Query NDC zCRRT tmp no TISSRecord has CRRT tmp but no CRRT (TISS Item) entryimplementedCentralized data front end.accdbCRRT (TISS Item)
    CRRT
    Data Integrity Checks
    Centralized data front end.accdb
    Tmp check
    TISS28 checks
    Query NDC zCRRT CCI Px but no TISSIf there is a CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI PximplementedCentralized data front end.accdbCRRT (TISS Item)
    CRRT (incl volume removal via PRISMA device)
    Data Integrity Checks
    Centralized data front end.accdb
    CCI Px check
    TISS28 checks
    Questions
    Query NDC zCRRT TISS but no CCI PxIf there is a CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI PximplementedCentralized data front end.accdbCRRT (TISS Item)
    CRRT (incl volume removal via PRISMA device)
    Data Integrity Checks
    Centralized data front end.accdb
    CCI Px check
    TISS28 checks
    Questions
    Query s tmp IICU consult DtTm"IICU consult" must have either a date or the check box checked. If they have a date, it has to be between Arrive_DtTm and Dispo_DtTm.implementedCCMDB.mdbIICU consultData Integrity Checks
    CCMDB.mdb
    Tmp check
    Query check ICD10 Comorbids NoComo code but othersIf No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities codedimplementedCCMDB.mdbComorbid Diagnosis
    No Comorbidities (ICD10 code)
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Query check ICD10 Comorbids Dx presentAll complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code).implementedCCMDB.mdbData Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTmIf an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal Arrive DtTmimplementedCCMDB.mdbArrive DtTm field
    Transfer Ready DtTm field
    Primary Admit Diagnosis
    Dx Primary
    Awaiting/delayed transfer to home
    Awaiting/delayed transfer to long-term care/PCH
    Awaiting/delayed transfer to other acute care facility
    Awaiting/delayed transfer to transitional care facility
    Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
    Admit Diagnosis
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days
    Awaiting/delayed transfer to other care facility NOS
    Data Integrity Checks
    CCMDB.mdb
    Transfer Ready
    ICD10 Dx check
    Awaiting/delayed transfer
    Check Inf Pathogens must have Infection requiring pathogen or Potential InfectionDxs in Category:Pathogens (but not in Category:Double duty pathogen) must have either a Category:Infection requiring pathogen or Category:Potential infection as Combined ICD10 codes.implementedCCMDB.mdbAbscess of intestine
    Anus or rectum, abscess
    Appendicitis, with or without rupture or peritonitis
    Arthritis, infectious (septic arthritis)
    Bacteremia
    Bacterial infection, NOS
    Bladder, cystitis, acute infectious
    Bladder, cystitis, chronic
    Bone infection (osteomyelitis), NOS
    Bone infection (osteomyelitis), acute
    Bone infection (osteomyelitis), chronic
    Bursitis, infective (any site)
    Cellulitis
    Cholangitis
    Chronic myringitis
    Colonized with organism (not infected)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral
    Endocarditis, infective, acute or subacute
    Endophthalmitis, infectious
    Epididymis, infection (epididymitis)
    Food poisoning (due to foodborne bacterial toxin), NOS
    Fournier's gangrene in a male
    Fungemia, NOS
    Gas gangrene (usually due to Clostridium perfringens)
    Gastrointestinal infection (gastroenteritis, colitis), bug NOS
    Iatrogenic, infection, cardiac or vascular prosthetic device or implant or graft NOS
    Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    Iatrogenic, infection, following a procedure or surgery, NOS
    Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis)
    Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device
    Iatrogenic, infection, internal prosthetic device or implant or graft NOS
    Iatrogenic, infection, related to vascular access other than central line
    Iatrogenic, infection, urinary catheter
    Impetigo
    Infection of skin or subcutaneous (soft) tissue, NOS
    Infectious disease NOS
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Intervertebral disc, infection (infective discitis)
    Kidney infection, acute (pyelonephritis)
    Kidney infection, chronic (pyelonephritis)
    Liver abscess
    Lower respiratory tract infection, acute infectious
    Mediastinitis, infectious
    Meningitis, fungal
    Meningitis, infectious NOS
    Meningitis, viral - incl West Nile
    Muscle, infection (pyomyositis, infective myositis)
    Myocarditis/carditis, acute infective
    Necrotizing fasciitis
    Otitis externa, infectious
    Otitis media, infectious
    Parasitic infection, NOS
    Pericarditis, acute, infective
    Peritonitis, infectious
    Peritonsillar abscess
    Pneumonia, bacterial
    Pneumonia, fungal/yeast
    Pneumonia, ventilator-associated (VAP)
    Pneumonia, viral
    Puerperal (post-delivery) infections or sepsis
    Pulmonary embolism (thromboembolism), septic
    Pulmonary embolism, septic obstetrical thromboembolism
    Sepsis (SIRS due to infection, without acute organ failure)
    Severe sepsis
    Sexually transmitted (venereal) infections, NOS
    Skin abscess
    Synovitis, tenosynovitis, infective (any site)
    Toxic shock syndrome
    Upper respiratory infection, acute NOS
    Urinary tract infection, NOS
    Vertebrae, osteomyelitis (bone infection)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Abdominal hernia, with gangrene
    Abortion NOS, with complication
    Bartholin's gland, disorder, infectious or not
    Bladder, cystitis NOS
    Breast, disorder NOS
    Breast, inflammatory or infectious disorder of breast
    Cervix, inflammatory or infectious disorder
    Cholecystitis, acute
    Chronic sinusitis
    Common cold (acute nasopharyngitis)
    Disorder of anus or rectum, NOS
    Disorder of eye(s), NOS
    Disorder of iris or ciliary body of eye
    Disorder of lacrimal system
    Disorder of liver, NOS
    Disorder of nose and/or sinuses, infectious or noninfectious NOS
    Disorder of peritoneum, NOS
    Disorder of pulmonary vessels, NOS
    Disorder of respiratory system, any part, NOS
    Disorder of skin or subcutaneous tissues, NOS
    Disorder of spleen, NOS
    Disorder of the cardiovascular/circulatory system, NOS
    Disorder of upper respiratory tract, infectious or noninfectious NOS
    Diverticulitis, small or large intestine (diverticular disease with perforation or abscess)
    Diverticulosis, small or large intestine (diverticular disease without perforation or abscess)
    Duodenitis
    Endocarditis, infective, chronic
    Epiglotittis, acute
    Erythema multiforme
    Erythema nodosum
    Gallbladder or bile duct disorder, NOS
    Hepatomegaly
    Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder
    Interstitial lung disease, NOS
    Intracranial abscess
    Intraspinal abscess
    Kidney or ureter, disorder NOS
    Laryngitis or tracheitis, acute
    Laryngitis or tracheitis, chronic
    Lymphangitis
    Male genital organs, disorder NOS
    Mastoiditis (acute or chronic, infectious or noninfectious)
    Medical abortion, with complication
    Meningitis, bacterial, NOS
    Observation for suspected infection NOS
    Pancreas disorder, NOS
    Pancreatitis, acute NOS
    Penis, disorders NOS
    Pharyngitis, acute
    Pleural effusion, NOS
    Pleurisy (infectious or noninfectious)
    Pneumonia, NOS
    Prostate, disorder NOS
    Respiratory disorder, postprocedure/postop NOS
    Retropharyngeal or parapharyngeal abscess
    Salpingitis, oophoritis or salpingo-oophoritis
    Sinusitis, acute
    Skin, rash NOS
    Spontaneous abortion/miscarriage, with complication
    Thyroiditis, acute
    Tonsillitis, acute
    Tonsillitis, chronic
    Urethra, infectious or noninfectious urethritis
    Urinary system, disorder NOS
    Uterus, inflammatory or infectious disorder
    Acinetobacter species
    Actinomyces (actinomycosis)
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Botulism (due to Clostridium botulinum toxin)
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Cholera (due to Vibrio cholerae)
    Citrobacter species
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dengue fever (due to Dengue virus)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungus or yeast, NOS
    HIV infection, asymptomatic
    Haemophilus influenzae (H. flu)
    Hantavirus infection
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Influenza without pneumonia but with other respiratory manifestations
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Molluscum contagiosum
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nocardia (nocardiosis)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Rabies OR for buglist rabies virus
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Tick-borne viruses (causes of encephalitis)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Varicella zoster virus (VZV)
    Virus, NOS
    West Nile virus
    Yellow fever (caused by yellow fever virus)
    Combined ICD10 codes
    Infections in ICD10
    Shock, septic
    Clostridium difficile infection (C. diff)
    Empyema (pyothorax)
    Epididymitis or orchitis, NOS (unclear which)
    Esophagitis, NOS
    Vagina, vaginitis, acute
    Vagina, vaginitis, chronic
    Respiratory syncytial virus (RSV)
    Deep venous thrombosis/thrombophlebitis, leg (DVT)
    Superficial venous thrombosis/thrombophlebitis, anywhere
    Kidney, renal abscess or perinephric abscess
    Nosocomial infection, NOS
    Mouth, cellulitis or abscess
    Lung abscess
    Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS
    Gastrointestinal infection (gastroenteritis, colitis), viral
    Conjunctivitis, any type or cause
    Testis, orchitis
    Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Check Inf Infection requiring pathogen must have pathogen combined codeevery dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbAbscess of intestine
    Anus or rectum, abscess
    Appendicitis, with or without rupture or peritonitis
    Arthritis, infectious (septic arthritis)
    Bacteremia
    Bacterial infection, NOS
    Bladder, cystitis, acute infectious
    Bladder, cystitis, chronic
    Bone infection (osteomyelitis), NOS
    Bone infection (osteomyelitis), acute
    Bone infection (osteomyelitis), chronic
    Bursitis, infective (any site)
    Cellulitis
    Cholangitis
    Chronic myringitis
    Colonized with organism (not infected)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, bacterial
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, infectious NOS
    Encephalitis, meningoencephalitis, myelitis, encephalomyelitis, viral
    Endocarditis, infective, acute or subacute
    Endophthalmitis, infectious
    Epididymis, infection (epididymitis)
    Food poisoning (due to foodborne bacterial toxin), NOS
    Fournier's gangrene in a male
    Fungemia, NOS
    Gas gangrene (usually due to Clostridium perfringens)
    Gastrointestinal infection (gastroenteritis, colitis), bug NOS
    Iatrogenic, infection, cardiac or vascular prosthetic device or implant or graft NOS
    Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    Iatrogenic, infection, following a procedure or surgery, NOS
    Iatrogenic, infection, heart valve prosthesis (incl prosthetic valve endocarditis)
    Iatrogenic, infection, internal orthopedic prosthetic device or implant or graft or bone device
    Iatrogenic, infection, internal prosthetic device or implant or graft NOS
    Iatrogenic, infection, related to vascular access other than central line
    Iatrogenic, infection, urinary catheter
    Impetigo
    Infection of skin or subcutaneous (soft) tissue, NOS
    Infectious disease NOS
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Intervertebral disc, infection (infective discitis)
    Kidney infection, acute (pyelonephritis)
    Kidney infection, chronic (pyelonephritis)
    Liver abscess
    Lower respiratory tract infection, acute infectious
    Mediastinitis, infectious
    Meningitis, fungal
    Meningitis, infectious NOS
    Meningitis, viral - incl West Nile
    Muscle, infection (pyomyositis, infective myositis)
    Myocarditis/carditis, acute infective
    Necrotizing fasciitis
    Otitis externa, infectious
    Otitis media, infectious
    Parasitic infection, NOS
    Pericarditis, acute, infective
    Peritonitis, infectious
    Peritonsillar abscess
    Pneumonia, bacterial
    Pneumonia, fungal/yeast
    Pneumonia, ventilator-associated (VAP)
    Pneumonia, viral
    Puerperal (post-delivery) infections or sepsis
    Pulmonary embolism (thromboembolism), septic
    Pulmonary embolism, septic obstetrical thromboembolism
    Sepsis (SIRS due to infection, without acute organ failure)
    Severe sepsis
    Sexually transmitted (venereal) infections, NOS
    Skin abscess
    Synovitis, tenosynovitis, infective (any site)
    Toxic shock syndrome
    Upper respiratory infection, acute NOS
    Urinary tract infection, NOS
    Vertebrae, osteomyelitis (bone infection)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Acinetobacter species
    Actinomyces (actinomycosis)
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Botulism (due to Clostridium botulinum toxin)
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Cholera (due to Vibrio cholerae)
    Citrobacter species
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dengue fever (due to Dengue virus)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungus or yeast, NOS
    HIV infection, asymptomatic
    Haemophilus influenzae (H. flu)
    Hantavirus infection
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Influenza without pneumonia but with other respiratory manifestations
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Molluscum contagiosum
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nocardia (nocardiosis)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Rabies OR for buglist rabies virus
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Tick-borne viruses (causes of encephalitis)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Varicella zoster virus (VZV)
    Virus, NOS
    West Nile virus
    Yellow fever (caused by yellow fever virus)
    Combined ICD10 codes
    Infections in ICD10
    Shock, septic
    Clostridium difficile infection (C. diff)
    Empyema (pyothorax)
    Respiratory syncytial virus (RSV)
    Kidney, renal abscess or perinephric abscess
    Nosocomial infection, NOS
    Gastrointestinal infection (gastroenteritis, colitis), protozoal, NOS
    Gastrointestinal infection (gastroenteritis, colitis), viral
    Gastrointestinal infection (gastroenteritis, colitis), bacterial, NOS
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogenevery dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbAIDS (disease due to HIV)
    Actinomyces (actinomycosis)
    African trypanosomiasis
    Amoebiasis (amoebic dysentery due to Entamoeba histolytica)
    Arthritis, due to Lyme
    Arthritis, due to tuberculosis
    Bone, tuberculosis (tuberculous osteomyelitis)
    Botulism (due to Clostridium botulinum toxin)
    Chagas' disease (due to American trypanosomiasis)
    Chlamydia psittici infection
    Cholera (due to Vibrio cholerae)
    Clostridium difficile infection (C. diff)
    Creutzfeldt-Jakob disease
    Dengue fever (due to Dengue virus)
    Diptheria (due to Corynebacterium diphtheriae toxin)
    German measles, limited to skin
    HIV infection, asymptomatic
    Hantavirus infection
    Helminthic (parasitic worm) infection, any organ(s)
    Hepatitis A, acute
    Hepatitis B, acute
    Hepatitis B, chronic
    Hepatitis C, acute
    Hepatitis C, chronic
    Infection with implied pathogen
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious contact/exposure, tuberculosis, without disease (yet)
    Infestation, NOS
    Influenza pneumonia
    Influenza with nonrespiratory manifestations
    Influenza without pneumonia but with other respiratory manifestations
    Leprosy (due to Mycobacterium leprae) (Hansen's disease)
    Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii)
    Malaria (due to Plasmodia, any type)
    Measles, limited to skin
    Molluscum contagiosum
    Mumps
    Nocardia (nocardiosis)
    Observation for SUSPECTED tuberculosis
    Poliomyelitis, acute
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Rabies OR for buglist rabies virus
    Rickettsia infection
    SARS (severe acute respiratory syndrome)
    Salmonella enteritis
    Scarlet fever
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Staphylococcal scalded skin syndrome
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Syphilis (due to Treponema pallidum)
    Tetanus infection (due to toxoid of Clostridium tetani)
    Thrush (Candida infection of mouth)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Tuberculosis of the nervous system
    Tuberculosis of the respiratory system, confirmed
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Whooping cough (Pertussis) (due to Bordetella pertussis)
    Yellow fever (caused by yellow fever virus)
    Zoonotic bacterial disease (directly transmitted from animal)
    Acinetobacter species
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Citrobacter species
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungemia, NOS
    Fungus or yeast, NOS
    Haemophilus influenzae (H. flu)
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Pneumonia, viral
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Tick-borne viruses (causes of encephalitis)
    Varicella zoster virus (VZV)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Virus, NOS
    West Nile virus
    Combined ICD10 codes
    Infections in ICD10
    Respiratory syncytial virus (RSV)
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Check Inf Infection with implied pathogen must not have a pathogen combined codeevery dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes.implementedCCMDB.mdbAIDS (disease due to HIV)
    Actinomyces (actinomycosis)
    African trypanosomiasis
    Amoebiasis (amoebic dysentery due to Entamoeba histolytica)
    Arthritis, due to Lyme
    Arthritis, due to tuberculosis
    Bone, tuberculosis (tuberculous osteomyelitis)
    Botulism (due to Clostridium botulinum toxin)
    Chagas' disease (due to American trypanosomiasis)
    Chlamydia psittici infection
    Cholera (due to Vibrio cholerae)
    Clostridium difficile infection (C. diff)
    Creutzfeldt-Jakob disease
    Dengue fever (due to Dengue virus)
    Diptheria (due to Corynebacterium diphtheriae toxin)
    German measles, limited to skin
    HIV infection, asymptomatic
    Hantavirus infection
    Helminthic (parasitic worm) infection, any organ(s)
    Hepatitis A, acute
    Hepatitis B, acute
    Hepatitis B, chronic
    Hepatitis C, acute
    Hepatitis C, chronic
    Infection with implied pathogen
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious contact/exposure, tuberculosis, without disease (yet)
    Infestation, NOS
    Influenza pneumonia
    Influenza with nonrespiratory manifestations
    Influenza without pneumonia but with other respiratory manifestations
    Leprosy (due to Mycobacterium leprae) (Hansen's disease)
    Lyme meningitis (due to Borrelia burgdorferi or Borrelia mayonii)
    Malaria (due to Plasmodia, any type)
    Measles, limited to skin
    Molluscum contagiosum
    Mumps
    Nocardia (nocardiosis)
    Observation for SUSPECTED tuberculosis
    Poliomyelitis, acute
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Rabies OR for buglist rabies virus
    Rickettsia infection
    SARS (severe acute respiratory syndrome)
    Salmonella enteritis
    Scarlet fever
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Staphylococcal scalded skin syndrome
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Syphilis (due to Treponema pallidum)
    Tetanus infection (due to toxoid of Clostridium tetani)
    Thrush (Candida infection of mouth)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Tuberculosis of the nervous system
    Tuberculosis of the respiratory system, confirmed
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Whooping cough (Pertussis) (due to Bordetella pertussis)
    Yellow fever (caused by yellow fever virus)
    Zoonotic bacterial disease (directly transmitted from animal)
    Acinetobacter species
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Citrobacter species
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungemia, NOS
    Fungus or yeast, NOS
    Haemophilus influenzae (H. flu)
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Pneumonia, viral
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Tick-borne viruses (causes of encephalitis)
    Varicella zoster virus (VZV)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Virus, NOS
    West Nile virus
    Combined ICD10 codes
    Infections in ICD10
    Respiratory syncytial virus (RSV)
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Check CCI vs previous locationIf from OR or PACU, must have at least 1 CCI Procedure other than No procedure performedimplementedCCMDB.mdbCCI Procedure
    Previous Location field
    Data Integrity Checks
    CCMDB.mdb
    CCI Px check
    Registry checks
    Function Validate Chartvalidates the Chart number:
  • Chart must be numerical
  • chart must be
  • checks Function PHIN same as Chart
  • no further checks at this time because chart numbers are different at different hospitals
  • implementedCCMDB.mdbPHIN field
    Chart number
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Sub Dx CheckerRuns most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxsimplementedCCMDB.mdbICD10 collectionData Integrity Checks
    CCMDB.mdb
    Old dx check
    ICD10 Dx check
    CCI Px check
    Query check ICD10 ESRD vs kidney transplantIf there is a Past history, transplanted kidney then there can only be Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5 if there is also Kidney transplant, failure or rejection or unspecified complicationimplementedCCMDB.mdbPast history, transplanted kidney
    Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Kidney transplant, failure or rejection or unspecified complication
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Query check ICD10 chonic vent acute resp failureChronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acuteimplementedCCMDB.mdbChronic dependence on mechanical ventilator
    Respiratory failure (insufficiency) NOS, acute
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Function Validate Pre admit Inpatient Institutionvalidates Pre-admit Inpatient Institution field:
  • Can not be blank
  • Check function preAdmit NE Location
  • implementedCCMDB.mdbPre-admit Inpatient Institution fieldData Integrity Checks
    CCMDB.mdb
    Query check ER Delay not too bigUnusually long ER DelayimplementedCCMDB.mdbER Delay
    Accept DtTm field
    Arrive DtTm field
    Service/Location field
    Data Integrity Checks
    CCMDB.mdb
    Query check CCI Picklist duplicatesNo duplication of CCI Picklist Px_Type, Px_Date, Px_CountimplementedCCMDB.mdbCCI Picklist
    Px Type
    Dx Priority
    No Dx Entered
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Query check CCI Component duplicatesNo duplication of CCI Component Px_Type, Px_DateimplementedCCMDB.mdbCCI Component
    Px Type
    Dx Priority
    No Dx Entered
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Check eliminated dxdisallows any currently entered diagnosis that has been eliminatedimplementedCCMDB.mdbEliminating a diagnosis from collectionData Integrity Checks
    CCMDB.mdb
    Old dx check
    ICD10 Dx check
    Query check ICD10 ESRD vs AP ARFARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.needs reviewCCMDB.mdbARF (APACHE)
    Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    CCMDB.mdb
    Data Collection Guide
    ICD10 Dx check
    Questions
    Query s tmp QASeptic Dx no tmp ICD10CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entryimplementedCCMDB.mdbQA Septic Shock
    Septic Shock
    Shock, septic
    Data Integrity Checks
    CCMDB.mdb
    Tmp check
    ICD10 Dx check
    Old dx check
    Query s tmp comfort care gt oneOnly one entry allowed per patient.implementedCCMDB.mdbComfort CareData Integrity Checks
    CCMDB.mdb
    Query s tmp ABO TEE checksEach of the three projects must have one entry on the ITEM for patients with RecordStatus completeimplementedCCMDB.mdbProject ABO TEE
    Service/Location field
    Data Integrity Checks
    CCMDB.mdb
    Site/Location check
    Tmp check
    TISS Errors vent vs vent2300Any marked TISS Item Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item Invasive Mechanical Ventilation (TISS Item) for the same date.implementedCentralized data front end.accdbInvasive Mechanical Ventilation (TISS Item)
    Invasive mechanical ventilation at 2300 hrs (TISS Item)
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    TISS28 checks
    TISS Errors Vent vs mechanismAny marked TISS Item Invasive Mechanical Ventilation (TISS Item) has to have (ETT Present (TISS Item) or Trach Tube Present (TISS Item)) for the same date.implementedCentralized data front end.accdbInvasive Mechanical Ventilation (TISS Item)
    ETT Present (TISS Item)
    Trach Tube Present (TISS Item)
    Data Integrity Checks
    Centralized data front end.accdb
    Tracheostomy
    TISS28 checks
    Link suspect mismatch pre inpt ours incomplete queryChecks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.implementedCentralized data front end.accdbPre-admit Inpatient Institution field
    Service/Location field
    Data Integrity Checks
    Centralized data front end.accdb
    Registry checks
    Query NDC Trach Dx TISSTracheostomy ICD10s and CCIs must be consistent with Trach TISS.implementedCentralized data front end.accdbTrach Tube Present (TISS Item)
    Tracheostomy, has one
    Tracheostomy creation
    Data Integrity Checks
    Centralized data front end.accdb
    Tracheostomy
    ICD10 Dx check
    CCI Px check
    TISS28 checks
    PL missing L Tables contentComplete patients must have entries in all of
  • L_ICD10 table
  • L_CCI_Picklist table
  • L_Labs_Flowsheet table
  • L_Pharm_Flowsheet table
  • implementedCentralized data front end.accdbQuality Assurance queries in CFE
    L Dxs table
    L Como table
    L Labs Flowsheet table
    L Pharm Flowsheet table
    Sending Patients
    Data Integrity Checks
    Centralized data front end.accdb
    Questions
    Query NDC Pacemaker acquired vs TISSRecords with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.implementedCentralized data front end.accdbPacemaker insertion, permanent
    Pacemaker insertion, temporary
    Permanent Pacemaker Insertion
    Pacemaker insertion (TISS Item)
    Data Integrity Checks
    Centralized data front end.accdb
    Query NDC TISS CCI endoscopicIf pt has TISS28 item Endoscopy (any type of scope) in the ICU (T43) then there must be an endoscopic CCI for that day.implementedCentralized data front end.accdbEndoscopy (TISS Item)
    ERCP (endoscopic retrograde cholangiopancreatography)
    Inspection, Exploration (endoscopic)
    Biopsy (endoscopic)
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    CCI Px check
    Check function preAdmit NE LocationPre-admit Inpatient Institution field can't be same as Service/Location fieldimplementedCCMDB.mdbService/Location field
    Pre-admit Inpatient Institution field
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Query check ICD10 mechanism vs traumaMechanism of injury needs to be co-coded with certain other codes, and should always have a combined code that expresses the injury itself.implementedCCMDB.mdbObservation after accident/injury
    Iatrogenic, mechanical complication/dysfunction, cardiac electronic device
    Iatrogenic, mechanical complication/dysfunction, cardiac or vascular prosthetic device or implant or graft, NOS
    Iatrogenic, mechanical complication/dysfunction, dialysis catheter
    Iatrogenic, mechanical complication/dysfunction, heart valve prosthesis
    Iatrogenic, mechanical complication/dysfunction, internal orthopedic prosthetic device or implant or graft or bone device
    Iatrogenic, mechanical complication/dysfunction, internal prosthetic device or implant or graft NOS
    Iatrogenic, mechanical complication/dysfunction, urinary catheter
    Iatrogenic, puncture or laceration, related to a procedure or surgery NOS
    Mechanism of injury: animal rider or occupant of animal-drawn vehicle
    Mechanism of injury: bus occupant
    Mechanism of injury: crushed or jammed or pinched in or between objects
    Mechanism of injury: driver or occupant of ATV or off-road vehicle or snowmobile
    Mechanism of injury: driver or occupant of watercraft
    Mechanism of injury: explosion
    Mechanism of injury: fall or jump (not necessarily from a height)
    Mechanism of injury: firearm (GSW)
    Mechanism of injury: hanging or strangulation (accidental or intentional)
    Mechanism of injury: hypodermic needle
    Mechanism of injury: knife or other sharp object, stabbing
    Mechanism of injury: machinery
    Mechanism of injury: motorcyclist
    Mechanism of injury: occupant or driver of car or truck
    Mechanism of injury: other NOS
    Mechanism of injury: pedal cyclist vs powered vehicle
    Mechanism of injury: pedal cyclist, not with powered vehicle
    Mechanism of injury: pedestrian vs powered vehicle
    Mechanism of injury: pilot or occupant of aircraft
    Mechanism of injury: struck by an inanimate moving object/blunt trauma
    Mechanism of injury: train occupant
    Mechanism of injury: transport or vehicle accident NOS
    Rotator cuff, tear or rupture
    Query check ICD10 mechanism vs trauma
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Mechanism
    Check overstay not enteredcheck that all has been entered for the Overstay projectimplementedCCMDB.mdbOverstay Predictor Project Collection Instructions
    Overstay Predictor Project
    OverstayProject
    Data Integrity Checks
    CCMDB.mdb
    Tmp check
    Query check ICD10 awaiting has Transfer Ready DtTmAny patient who has code in Category:Awaiting/delayed transfer has to have a Transfer Ready DtTm on a different day than their Dispo DtTm.implementedCCMDB.mdbTransfer Ready DtTm field
    Awaiting/delayed transfer to home
    Awaiting/delayed transfer to long-term care/PCH
    Awaiting/delayed transfer to other acute care facility
    Awaiting/delayed transfer to transitional care facility
    Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days
    Awaiting/delayed transfer to other care facility NOS
    Data Integrity Checks
    CCMDB.mdb
    Transfer Ready
    ICD10 Dx check
    Registry checks
    Query s tmp IICU consult dispo to IICU but no tmpA patient is discharged to IICU and does not have an "IICU consult".implementedCCMDB.mdbIICU consultData Integrity Checks
    CCMDB.mdb
    Tmp check
    Query check ICD10 trach dxs consistentTracheostomy related CCI and ICD10 codes must be consistent with each other.implementedCCMDB.mdbTracheostomy, has one
    Tracheostomy care
    Tracheostomy complication, hemorrhage from site
    Tracheostomy complication, malfunction
    Tracheostomy complication, NOS
    Tracheostomy complication, tracheo-esophageal fistula
    Tracheostomy creation
    Data Integrity Checks
    CCMDB.mdb
    Tracheostomy
    ICD10 Dx check
    CCI Px check
    Query s tmp Borrow sensible DtTm vs no borrowChecks that data for Project Borrow arrive follows that project'simplementedCCMDB.mdbProject Borrow arriveData Integrity Checks
    CCMDB.mdb
    Tmp check
    Query s tmp Borrow duplicatesChecks that data for Project Borrow arrive follows that project'simplementedCCMDB.mdbProject Borrow arriveData Integrity Checks
    CCMDB.mdb
    Tmp check
    Query NDC cardioversion dx vs TISSIf pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item Cardioversion (TISS Item) (T41) must be marked.implementedCentralized data front end.accdbCardioversion (TISS Item)
    Acquired Procedure
    Cardioversion (EXCLUDE defibrillation-we are not tracking)
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    CCI Px check
    Query NDC CLI vs DX but no TISS17 CentralLineChecks for patients who have a Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI) but no Central venous catheter (TISS Item).implementedCentralized data front end.accdbCentral venous catheter (TISS Item)
    Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    ICD10 Dx check
    Old dx check
    Questions
    Query NDC Bad Postal CodeCross check of postal codes against known postal codesimplementedCentralized data front end.accdbPostal Code fieldData Integrity Checks
    Centralized data front end.accdb
    Data Processing
    Postal Codes
    Registry checks
    Query NDC CLI AcqDX but NoCLI DateinTMPV2Checks for Patients who have a CLI but not the corresponding tmp entry.implementedCentralized data front end.accdbIatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    QA Infection CLI
    Data Integrity Checks
    Centralized data front end.accdb
    Tmp check
    Old dx check
    ICD10 Dx check
    Questions
    Query NDC CLI No AcqDX but CLI DateinTMPV2Checks for Patients who have a CLI tmp entry but not the corresponding dx.implementedCentralized data front end.accdbIatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    QA Infection CLI
    Data Integrity Checks
    Centralized data front end.accdb
    Tmp check
    Old dx check
    ICD10 Dx check
    Questions
    Query NDC TISS Spontaneous vs ETT TrachA patient with Spontaneous breathing via ETT or Trach (TISS Item)(T19) must also have (ETT Present (TISS Item)(T22) or Trach Tube Present (TISS Item)(T23))implementedCentralized data front end.accdbSpontaneous breathing via ETT or Trach (TISS Item)
    ETT Present (TISS Item)
    Trach Tube Present (TISS Item)
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    Data Processing
    Query NDC Dialysis TISS CCICritical care patients who have CCI entries for dialysis must have TISS28 entries as well, and vice versa.implementedCentralized data front end.accdbCRRT (incl volume removal via PRISMA device)
    PD (Peritoneal dialysis)
    HD (Hemodialysis)
    Peritoneal dialysis (TISS Item)
    CRRT (TISS Item)
    Intermittent hemodialysis (TISS Item)
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    CCI Px check
    Query TISS Errors D ID not in CFEThe D_ID on a TISS28 form does not exist in CFEimplementedTISS28.mdbCentralized data front end.accdb
    D ID field
    Data Integrity Checks
    TISS28.mdb
    TISS28 checks
    Data Processing
    TISS28 Scanning Process
    Query TISS Errors duplicate ItemsA TISS28 item exists twiceimplementedTISS28.mdbTISS Items SMWData Integrity Checks
    TISS28.mdb
    TISS28 checks
    Data Processing
    TISS28 Scanning Process
    Query TISS Errors missing daysThere are no TISS28 entries for a day that should have at least one based on Arrive DtTm and Dispo DtTmimplementedTISS28.mdbTISS Items SMW
    Arrive DtTm field
    Dispo DtTm field
    Data Integrity Checks
    TISS28.mdb
    TISS28 checks
    Data Processing
    Questions
    TISS28 Scanning Process
    Query TISS Errors TISS date out of admissionTISS date is not during admissionimplementedTISS28.mdbTISS Items SMW
    Arrive DtTm field
    Dispo DtTm field
    Data Integrity Checks
    TISS28 checks
    Registry checks
    Data Processing
    Length of stay
    TISS28.mdb
    TISS28 Scanning Process
    Questions
    Query check long transfer delayIs the Transfer Delay unreasonably long?needs reviewCCMDB.mdbTransfer Delay
    Transfer Ready DtTm field
    Dispo DtTm field
    Questions
    Admit/Discharge
    Transfer Ready
    Data Integrity Checks
    CCMDB.mdb
    Controlling Dx Type for ICD10 codesControlling Dx Type for ICD10 codesneeds reviewCCMDB.mdbICD10 DiagnosisQuestions
    ICD10
    ICD10 Dx check
    Data Integrity Checks
    CCMDB.mdb
    Check pre acute consistentconsistency of Pre acute living situation; Dispo; Postal Code and Previous Locationneeds reviewCCMDB.mdbPre acute living situation field
    Dispo field
    Postal Code field
    Previous Location field
    Questions
    Data Integrity Checks
    CCMDB.mdb
    Admit/Discharge
    Registry Data
    Pre-acute living situation
    Postal Codes
    Check CRF vs ARF across multiple encountersIf a patient had a comorbid of CRF in any previous admission then ARF can not be an admit or complication in subsequent admissions.needs reviewCentralized data front end.accdbCRF - Chronic Renal Failure
    ARF (Diagnosis)
    Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Kidney, acute renal failure NOS
    Kidney, acute renal failure, postprocedural
    Kidney, acute tubular necrosis (ATN)
    Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic
    Renal Coding Considerations for ICD10
    Questions
    Multiple encounter longitudinal consistency check
    Data Integrity Checks
    Centralized data front end.accdb
    ICD10 Dx check
    CCI Px check
    Check Inf Potential Infection must have pathogen or alt combined codeevery dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.needs reviewCCMDB.mdbAbdominal hernia, with gangrene
    Abortion NOS, with complication
    Bartholin's gland, disorder, infectious or not
    Bladder, cystitis NOS
    Breast, disorder NOS
    Breast, inflammatory or infectious disorder of breast
    Cervix, inflammatory or infectious disorder
    Cholecystitis, acute
    Chronic sinusitis
    Common cold (acute nasopharyngitis)
    Disorder of anus or rectum, NOS
    Disorder of eye(s), NOS
    Disorder of iris or ciliary body of eye
    Disorder of lacrimal system
    Disorder of liver, NOS
    Disorder of nose and/or sinuses, infectious or noninfectious NOS
    Disorder of peritoneum, NOS
    Disorder of pulmonary vessels, NOS
    Disorder of respiratory system, any part, NOS
    Disorder of skin or subcutaneous tissues, NOS
    Disorder of spleen, NOS
    Disorder of the cardiovascular/circulatory system, NOS
    Disorder of upper respiratory tract, infectious or noninfectious NOS
    Diverticulitis, small or large intestine (diverticular disease with perforation or abscess)
    Diverticulosis, small or large intestine (diverticular disease without perforation or abscess)
    Duodenitis
    Endocarditis, infective, chronic
    Epiglotittis, acute
    Erythema multiforme
    Erythema nodosum
    Gallbladder or bile duct disorder, NOS
    Hepatomegaly
    Internal female reproductive organs and adnexa NOS, inflammatory or infectious disorder
    Interstitial lung disease, NOS
    Intracranial abscess
    Intraspinal abscess
    Kidney or ureter, disorder NOS
    Laryngitis or tracheitis, acute
    Laryngitis or tracheitis, chronic
    Lymphangitis
    Male genital organs, disorder NOS
    Mastoiditis (acute or chronic, infectious or noninfectious)
    Medical abortion, with complication
    Meningitis, bacterial, NOS
    Observation for suspected infection NOS
    Pancreas disorder, NOS
    Pancreatitis, acute NOS
    Penis, disorders NOS
    Pharyngitis, acute
    Pleural effusion, NOS
    Pleurisy (infectious or noninfectious)
    Pneumonia, NOS
    Prostate, disorder NOS
    Respiratory disorder, postprocedure/postop NOS
    Retropharyngeal or parapharyngeal abscess
    Salpingitis, oophoritis or salpingo-oophoritis
    Sinusitis, acute
    Skin abscess
    Skin, rash NOS
    Spontaneous abortion/miscarriage, with complication
    Thyroiditis, acute
    Tonsillitis, acute
    Tonsillitis, chronic
    Urethra, infectious or noninfectious urethritis
    Urinary system, disorder NOS
    Uterus, inflammatory or infectious disorder
    Acinetobacter species
    Actinomyces (actinomycosis)
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Botulism (due to Clostridium botulinum toxin)
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Cholera (due to Vibrio cholerae)
    Citrobacter species
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dengue fever (due to Dengue virus)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungemia, NOS
    Fungus or yeast, NOS
    HIV infection, asymptomatic
    Haemophilus influenzae (H. flu)
    Hantavirus infection
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Influenza without pneumonia but with other respiratory manifestations
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Molluscum contagiosum
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nocardia (nocardiosis)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Pneumonia, viral
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Rabies OR for buglist rabies virus
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Tick-borne viruses (causes of encephalitis)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Varicella zoster virus (VZV)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Virus, NOS
    West Nile virus
    Yellow fever (caused by yellow fever virus)
    Combined ICD10 codes
    Infections in ICD10
    Clostridium difficile infection (C. diff)
    Epididymitis or orchitis, NOS (unclear which)
    Esophagitis, NOS
    Vagina, vaginitis, acute
    Vagina, vaginitis, chronic
    Respiratory syncytial virus (RSV)
    Deep venous thrombosis/thrombophlebitis, leg (DVT)
    Superficial venous thrombosis/thrombophlebitis, anywhere
    Mouth, cellulitis or abscess
    Lung abscess
    Conjunctivitis, any type or cause
    Testis, orchitis
    Data Integrity Checks
    CCMDB.mdb
    Questions
    ICD10 Dx check
    Query s tmp IICU consult not pairedIf any "IICU consult" entries are present in L_TmpV2 then there have to be two.needs reviewCCMDB.mdbIICU consultData Integrity Checks
    CCMDB.mdb
    Questions
    Tmp check
    Check dx implying death across encountersCategory:Diagnosis implying death across encountersneeds reviewCentralized data front end.accdbBrain death
    Medical Assistance In Dying
    Sudden cardiac death (and died)
    Organ donor (organ/tissue donation by the donor)
    Deceased patients
    Data Integrity Checks
    Centralized data front end.accdb
    Multiple encounter longitudinal consistency check
    Registry checks
    ICD10 Dx check
    End-of-life related data
    Questions
    Check dx implying death must be dispo deceasedIf dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be deceased or transplant locationneeds reviewCCMDB.mdbBrain death
    Medical Assistance In Dying
    Sudden cardiac death (and died)
    Dispo field
    Deceased patients
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    End-of-life related data
    Questions
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff daysAny patient with a with Transfer Ready DtTm and Dispo DtTm on different days has to have one of the "awaiting" codes and vice versa.needs reviewCCMDB.mdbTransfer Ready DtTm field
    Dispo DtTm field
    Awaiting/delayed transfer to home
    Awaiting/delayed transfer to long-term care/PCH
    Awaiting/delayed transfer to other acute care facility
    Awaiting/delayed transfer to transitional care facility
    Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
    Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days
    Awaiting/delayed transfer to other care facility NOS
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Transfer Ready
    Questions
    Awaiting/delayed transfer
    Query NDC Dxs vs TISS DialysisIf there is a TISS28 entry for Hemodialysis there should be a corresponding Dx.needs reviewCentralized data front end.accdbIntermittent hemodialysis (TISS Item)
    Peritoneal dialysis (TISS Item)
    CRRT (TISS Item)
    Kidney, acute renal failure NOS
    Kidney, acute renal failure, postprocedural
    Kidney, acute tubular necrosis (ATN)
    Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic
    Data Integrity Checks
    Centralized data front end.accdb
    Questions
    TISS28 checks
    ICD10 Dx check
    Function Dispo Chronological()Checks that the registry times are in a sensible chronological order.needs reviewCCMDB.mdbArrive DtTm field
    Accept DtTm field
    Transfer Ready DtTm field
    Dispo DtTm field
    2016 Time and Place changes
    Data Integrity Checks
    CCMDB.mdb
    Registry checks
    Check ICD10 some cant be primaryDxs in Category:Pathogens or Category:Antibiotic resistance must not be Primary Admit Diagnosis.needs reviewCCMDB.mdbAcinetobacter species
    Actinomyces (actinomycosis)
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Botulism (due to Clostridium botulinum toxin)
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Cholera (due to Vibrio cholerae)
    Citrobacter species
    Clostridium difficile infection (C. diff)
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dengue fever (due to Dengue virus)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungemia, NOS
    Fungus or yeast, NOS
    HIV infection, asymptomatic
    Haemophilus influenzae (H. flu)
    Hantavirus infection
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Influenza without pneumonia but with other respiratory manifestations
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Molluscum contagiosum
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nocardia (nocardiosis)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Pneumonia, viral
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Rabies OR for buglist rabies virus
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Respiratory syncytial virus (RSV)
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Tick-borne viruses (causes of encephalitis)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Varicella zoster virus (VZV)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Virus, NOS
    West Nile virus
    Antibiotic Resistant Organism (old)
    Resistance to antimicrobials, anti-mycobacterial agent
    Resistance to antimicrobials, antibiotic, resistance to other beta lactams
    Resistance to antimicrobials, antifungal drug
    Resistance to antimicrobials, antiparasitic drug
    Resistance to antimicrobials, drug NOS
    Resistance to antimicrobials, extended spectrum beta lactamase (ESBL)
    Resistance to antimicrobials, methicillin (anti-staph penicillins)
    Resistance to antimicrobials, miscellaneous antibacterial antibiotics
    Resistance to antimicrobials, vancomycin
    VRE
    Combined ICD10 codes
    Infections in ICD10
    Yellow fever (caused by yellow fever virus)
    Antibiotic Resistant Organism
    Data Integrity Checks
    CCMDB.mdb
    ICD10 Dx check
    Questions
    Query check ICD10 ESRD vs ARFCan't have ESRD and acute renal failure, except if there was a transplant during this ward stayneeds reviewCCMDB.mdbChronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Kidney, acute renal failure NOS
    Kidney, acute renal failure, postprocedural
    Kidney, acute tubular necrosis (ATN)
    Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Questions
    Query check CCI must have entryThere must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)needs reviewCCMDB.mdbCCI Collection
    No procedure performed
    L CCI Picklist table
    Data Integrity Checks
    CCMDB.mdb
    CCI
    CCI Px check
    Questions
    Can't check ICD10 ARF vs APACHE ARFCan't have ESRD and acute renal failurenot feasibleCCMDB.mdbARF (APACHE)
    Kidney, acute renal failure NOS
    Kidney, acute renal failure, postprocedural
    Kidney, acute tubular necrosis (ATN)
    Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    ICD10
    ICD10 Dx check
    APACHE check
    CCMDB.mdb
    Questions
    Check organ donors must be deadorgan donors must be deceasednot feasibleCCMDB.mdbQuestions
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp Borrow no borrow on own unitCan't have Project Borrow arrive on own unitnot feasibleCCMDB.mdbProject Borrow arriveData Integrity Checks
    CCMDB.mdb
    Tmp check
    Check VAP acquired only first encounterVAP should only be Acquired Diagnosis on the first encounter.ready to implementCentralized data front end.accdbPneumonia, ventilator-associated (VAP)
    Acquired Diagnosis / Complication
    Multiple Encounter
    Data Integrity Checks
    Multiple encounter longitudinal consistency check
    VAP - Ventilator Associated Pneumonia
    ICD10 Dx check
    Old dx check
    Registry checks
    Centralized data front end.accdb
    Check TISS Intubation consistentAny marked TISS Item Insertion of ETT (TISS Item) or in ETT Present (TISS Item) must have at least one marked TISS item either in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item)ready to implementCentralized data front end.accdbInsertion of ETT (TISS Item)
    Planned extubation (TISS Item)
    Unplanned extubation (TISS Item)
    Questions
    Data Integrity Checks
    Centralized data front end.accdb
    CXR count cross checkConfirm that a Category:Labs Imaging count is not unreasonably highready to implementCCMDB.mdbLOS
    Arrive DtTm field
    Dispo DtTm field
    CXR (plain film)
    Data Integrity Checks
    CCMDB.mdb
    CCMDB.mdb cross checks triggering for correct values
    Labs
    Length of stay
    Questions
    Query check ICD10 only 1 stage of renal failurecan only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosisready to implementCCMDB.mdbChronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Chronic kidney disease, NOS (stage unspecified)
    Kidney, renal failure/insufficiency/uremia, unspecified as acute or chronic
    Chronic kidney disease (chronic renal insufficiency, uremia) Stage 1
    Chronic kidney disease (chronic renal insufficiency, uremia) Stage 2
    Chronic kidney disease (chronic renal insufficiency, uremia) Stage 3
    Chronic kidney disease (chronic renal insufficiency, uremia) Stage 4
    Renal Coding Considerations for ICD10
    Data Integrity Checks
    CCMDB.mdb
    Questions
    ICD10
    ICD10 Dx check
    Query check ICD10 duplicatesICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism) can't be entered in duplicate.ready to implementCCMDB.mdbAcinetobacter species
    Actinomyces (actinomycosis)
    Adenovirus
    Aspergillus
    Bacillus fragilis (B. frag)
    Bacteria, NOS
    Blastomyces
    Botulism (due to Clostridium botulinum toxin)
    Candida species
    Chlamydia trachomatis (bug responsible for regular sexually transmitted chlamydia)
    Cholera (due to Vibrio cholerae)
    Citrobacter species
    Clostridium difficile infection (C. diff)
    Clostridium perfringens
    Coccidioides
    Coronavirus
    Cryptococcus
    Cytomegalovirus (CMV)
    Dengue fever (due to Dengue virus)
    Dermatophytosis (tineas, cutaneous fungal infection)
    Entamoeba histolytica (amoebic infection of non-intestinal sites)
    Enterobacter species
    Enterococcus species
    Enterovirus - incl coxsackievirus, echovirus
    Escherichia coli (E. coli)
    Fungemia, NOS
    Fungus or yeast, NOS
    HIV infection, asymptomatic
    Haemophilus influenzae (H. flu)
    Hantavirus infection
    Helicobacter pylori (H. pylori)
    Herpes simplex virus (HSV)
    Histoplasma
    Infectious contact/exposure, HIV, without disease (yet)
    Infectious contact/exposure, rabies, without disease (yet)
    Infectious mononucleosis (usually due to Epstein-Barr virus)
    Infectious organism, unknown
    Influenza virus NOS -- should almost never be used
    Influenza without pneumonia but with other respiratory manifestations
    Klebsiella species
    Legionella
    Listeria
    Lyme disease OR for buglist Borrelia burgdorferi or B. mayonii
    Measles virus
    Molluscum contagiosum
    Mosquito-borne viruses (causes of encephalitis)
    Mucormycetes
    Mumps
    Mumps virus
    Mycobacterium avium-intracellulare (MAC)
    Mycobacterium tuberculosis (M. TB)
    Mycoplasma pneumoniae
    Neisseria gonorrhea (gonococcus)
    Neisseria meningitidis (meningococcus)
    Nocardia (nocardiosis)
    Nontuberculous mycobacteria
    Not an Infection (ICD10 pathogen alternative)
    Other type of infectious organism, NOS
    Papillomavirus
    Paracoccidioides
    Parainfluenza virus
    Parvovirus
    Pathogens
    Pneumocystis Jirovecii or Pneumocystis Carinii
    Pneumonia, viral
    Progressive Multifocal Leukoencephalopathy (PML) (caused by JC virus)
    Proteus mirabilus (morganii)
    Protozoa, NOS
    Pseudomonas
    Rabies OR for buglist rabies virus
    Reovirus
    Resistance to antimicrobials, antiviral agent
    Respiratory syncytial virus (RSV)
    Retrovirus
    Rubella virus (German measles virus)
    Salmonella species
    Serratia species
    Shigellosis (dysentery due to Shigella species)
    Smallpox (due to Variola viruses)
    Spirochetes, NOS - incl yaws, louse-borne, tick-borne
    Sporothrix
    Staphylococcus aureus
    Staphylococcus, NOS
    Stenotrophomonas species
    Streptococcus group A (strep pyogenes)
    Streptococcus group B (strep agalactiae)
    Streptococcus group D
    Streptococcus group G
    Streptococcus pneumoniae
    Streptococcus, NOS
    Subacute sclerosing panencephalitis (SSPE) (caused by Measles virus)
    Tick-borne viruses (causes of encephalitis)
    Toxoplasmosis OR for buglist Toxoplama gondii
    Typhoid fever or Paratyphoid fever (due to Salmonella typhi or Salmonella enterica)
    Varicella zoster virus (VZV)
    Viral carditis
    Viral hemorrhagic fever, NOS
    Viral hepatitis, acute, NOS
    Viral hepatitis, chronic, NOS
    Virus, NOS
    West Nile virus
    Yellow fever (caused by yellow fever virus)
    Antibiotic Resistant Organism
    Antibiotic Resistant Organism (old)
    Resistance to antimicrobials, anti-mycobacterial agent
    Resistance to antimicrobials, antibiotic, resistance to other beta lactams
    Resistance to antimicrobials, antifungal drug
    Resistance to antimicrobials, antiparasitic drug
    Resistance to antimicrobials, drug NOS
    Resistance to antimicrobials, extended spectrum beta lactamase (ESBL)
    Resistance to antimicrobials, methicillin (anti-staph penicillins)
    Resistance to antimicrobials, miscellaneous antibacterial antibiotics
    Resistance to antimicrobials, vancomycin
    VRE
    Combined ICD10 codes
    Infections in ICD10
    Data Integrity Checks
    CCMDB.mdb
    ICD10
    ICD10 Dx check
    Questions
    Check drugs vs TISSCompare Vasoactive drug IV continuous-single (TISS Item)/Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.ready to implementCentralized data front end.accdbVasoactive drug IV continuous-single (TISS Item)
    Vasoactive drug IV continuous-multiple simultaneous (TISS Item)
    Pharmacy collection
    Data Integrity Checks
    TISS28 checks
    Questions
    Centralized data front end.accdb
    Query TISS Errors CAM positive vs DxChecks that each CAM positive (TISS Item) goes with an ICD10 code from Category:Deliriumready to implementCentralized data front end.accdbCAM positive (TISS Item)
    Delirium, not due to drugs or alcohol
    Delusional disorder
    Psychosis/psychotic disorder, NOS, acute or chronic
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    Data Processing
    Length of stay
    Registry checks
    Query NDC TISS Extubation only on TISS Intubated daysAny marked TISS Item in Planned extubation (TISS Item) or in Unplanned extubation (TISS Item) must have the ETT Present (TISS Item) on the same date.ready to implementCentralized data front end.accdbInsertion of ETT (TISS Item)
    Planned extubation (TISS Item)
    Unplanned extubation (TISS Item)
    Data Integrity Checks
    Centralized data front end.accdb
    TISS28 checks
    Check BRR/XBR vs cardiac arrest dxIf there is an Admit Diagnosis or Acquired Diagnosis of at least one of:
  • Witnessed Cardiac Arrest
  • Unwitnessed Cardiac Arrest
  • then there has to be a BRR collection entry.
    retiredCCMDB.mdbWitnessed Cardiac Arrest
    Unwitnessed Cardiac Arrest
    BRR
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Check Function Panelling admit transfer sameIf patient has Panelling or Discharge Planning as Admit Diagnosis then Arrive DtTm field must be equal to Transfer Ready DtTm field.retiredCCMDB.mdbPanelling or Discharge Planning
    Arrive DtTm field
    Transfer Ready DtTm field
    Data Integrity Checks
    CCMDB.mdb
    Old dx check
    Legacy Content
    Query check ApARF CRFARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.retiredCCMDB.mdbARF (APACHE)
    Chronic kidney disease (end-stage kidney disease, ESRD), Stage 5
    Data Integrity Checks
    CCMDB.mdb
    Data Collection Guide
    ICD10 Dx check
    Legacy Content
    Query Check Renal IncompatibleDxscan't have ARF and CRF in same recordretiredCCMDB.mdbRenal Transplant
    CRF - Chronic Renal Failure
    ARI
    ARF (Diagnosis)
    Acute Tubular Necrosis (ATN)
    Data Integrity Checks
    CCMDB.mdb
    Old dx check
    Legacy Content
    Query check trach dx taskmake sure Trach Task is entered correctlyretiredCCMDB.mdbTrach TaskData Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp QAInf basicchecks that none of int, float, bool fields are used in this data.retiredCCMDB.mdbQA Infection
    QA Infection CLI
    QA Infection VAP
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp QAInf dx no tmpIf Complication Diagnosis is one of:

    then there has to be a

    • L_TmpV2 entry with project "ICU Infection Audit"
    retiredCCMDB.mdbQA Infection
    QA Infection CLI
    QA Infection VAP
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp QAInf tmp no dxIf "QAInf" entry is present in L_TmpV2 then
  • program must be "CC"
  • the corresponding diagnosis must exist
  • retiredCCMDB.mdbQA Infection
    QA Infection CLI
    Pneumonia, ventilator-associated (VAP)
    QA Infection VAP
    Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp QAInf LT 48 hrs after admitDtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.retiredCCMDB.mdbQA Infection
    QA Infection CLI
    QA Infection VAP
    Data Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query s tmp ACPerror if ACP Status collection in ICU is missing part of the entry.retiredCCMDB.mdbACP Status collection in ICUData Integrity Checks
    CCMDB.mdb
    Legacy Content
    Query check VAP admit must be from ICUVAP should only be Admit Diagnosis when Previous Location is an ICU.retiredCCMDB.mdbPneumonia, ventilator-associated (VAP)
    Previous Location field
    Admit Diagnosis
    Data Integrity Checks
    CCMDB.mdb
    Multiple encounter longitudinal consistency check
    VAP - Ventilator Associated Pneumonia
    ICD10 Dx check
    Old dx check
    Registry checks
    Query NDC VAP unacceptable dateChecks for Arrive DtTm before QA Infection VAP date and Dispo DtTm after QA Infection VAP date.retiredCentralized data front end.accdbPneumonia, ventilator-associated (VAP)
    QA Infection VAP
    Arrive DtTm field
    Dispo DtTm field
    Data Integrity Checks
    Centralized data front end.accdb
    Questions
    Old dx check
    Registry checks
    Query NDC VAP AcqDX but NoVAP DateinTMPV2Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.retiredCentralized data front end.accdbPneumonia, ventilator-associated (VAP)
    Acquired Diagnosis / Complication
    QA Infection VAP
    Data Integrity Checks
    Centralized data front end.accdb
    Questions
    Old dx check
    Registry checks
    Query NDC VAP No AcqDX but VAP DateinTMPV2Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .retiredCentralized data front end.accdbPneumonia, ventilator-associated (VAP)
    Acquired Diagnosis / Complication
    QA Infection VAP
    Data Integrity Checks
    Centralized data front end.accdb
    Questions
    Registry checks
    Old dx check
    Query NDC CLI unacceptable dateChecks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTmretiredCentralized data front end.accdbIatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
    Arrive DtTm field
    Dispo DtTm field
    QA Infection CLI
    Data Integrity Checks
    Centralized data front end.accdb
    Old dx check
    Registry checks
    Questions

    Checks under review

    See Data Integrity Check under review