Search by property
Jump to navigation
Jump to search
This page provides a simple browsing interface for finding entities described by a property and a named value. Other available search interfaces include the page property search, and the ask query builder.
List of results
- Query check AIDS vs HIV + (A record can not have both [[AIDS (disease due to HIV)]] and [[HIV infection, asymptomatic]])
- Query check AIDS vs HIV +
- PL SameCHART Site Diff PHIN + (A record with this [[Chart number]] already exists for this [[service/Location]] and it has a different [[PHIN]].)
- PL SamePHIN Site Diff chart + (Another record exists for this site with the same [[PHIN]] and a different [[Chart number]].)
- PL SamePhin Diff DOB Sex + (Another record exists with the same [[PHIN]] but a different [[Date of Birth]], [[Sex]])
- Query cardiac arrest throughout admission + (Any patient who is admitted to ICU from Med or another ICU with a [[#Cardiac Arrest]] dx should have one in their immediately preceeding Med or ICU record also.)
- Query check ICD10 ESRD vs ARF + (Can't have [[Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15|ESRD]] and acute renal failure, except if there was a transplant during this ward stay)
- Can't check ICD10 ARF vs APACHE ARF + (Can't have [[Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15|ESRD]] and acute renal failure)
- Query NDC VAP unacceptable date + (Checks for Arrive DtTm before [[QA Infection VAP]] date and [[Dispo DtTm]] after [[QA Infection VAP]] date.)
- Query check ICD10 CLI vs CCI CentralLine + (Checks for critical care patients who have a [[Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)]] but no T17 - [[ Central venous catheter (TISS Item)]].)
- Link suspect mismatch pre inpt ours incomplete query + (Checks for patients where [[Pre-admit Inpatient Institution]] is one of ours but we don't have a corresponding record.)
- Query NDC VAP No AcqDX but VAP DateinTMPV2 + (Checks that any record with [[QA Infection VAP]] entry with a date also has an [[Acquired Diagnosis]] [[VAP]] .)
- Query NDC VAP AcqDX but NoVAP DateinTMPV2 + (Checks that any record with an [[Acquired Diagnosis]] [[VAP]] has a [[QA Infection VAP]] entry with a date.)
- Query NDC CLI unacceptable date + (Checks that the [[QA Infection CLI]] Dt is between the ''Arrive DtTm'' and [[Dispo DtTm]])
- Query check cooling vs arrest + (Due to our definition of [[Targeted Temperature Management (TTM)]] that code can only be used if there is a [[Cardiac arrest]] dx)
- Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection + (Dxs 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]].)
- Check Sub PharmCheck + (Every CC record has to have at least one pharmacy record (possibly all zeros), and the number of drug days can't be GT LOS,)
- Query s tmp QAInf dx no tmp + (If '''Complication Diagnosis''' is one of: … If '''Complication Diagnosis''' is one of: </br>*[[Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)]] </br>*[[Pneumonia, ventilator-associated (VAP)]]</br>then there has to be a</br>* L_TmpV2 entry with project "ICU Infection Audit"2 entry with project "ICU Infection Audit")
- Query check_ICD10_ESRD_vs_kidney_transplant + (If there is a [[Past history, transplanted kidney]] then there can only be [[Chronic kidney disease (end-stage renal/kidney disease, ESRD), Stage 5, GFR LT 15]] if there is also [[Kidney transplant, failure or rejection or unspecified complication]])
- Query NDC zCRRT TISS no tmp + (Record has T33 - [[ CRRT (TISS Item)]] but no [[CRRT Project]] tmp entry)
- Query NDC zCRRT tmp no TISS + (Record has [[CRRT]] tmp but no T33 - [[ CRRT (TISS Item)]] entry)
- Reconnect check orphans query + (Record meets following conditions * [[RecordStatus field]] is incomplete * the record doesn't have the same [[SentDtTm field]] as the newest SentDtTm for that [[Service/Location]].)
- Link suspect negative transit time query + (Used 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 [[Admit DtTm]].)
- Link suspect dead then alive query + (Used 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.)
- Link suspect mismatch from ours incomplete query + (Used in [[Correcting suspect links]] … Used 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.ing entry doesn't exist for that location.)
- Link suspect mismatch to ours incomplete query + (Used in [[Correcting suspect links]] … Used 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.ing entry doesn't exist for that location.)
- Query Check Renal IncompatibleDxs + (can't have ARF and CRF in same record)
- Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen + (every dx in [[:Category:Antibiotic resistance]] must have a dx in [[:Category:Infection with implied pathogen]] or in [[:Category:Pathogens]] as [[Combined ICD10 codes]].)
- Query check ICD10 Inf Infection req Pathogen must have one + (every dx in [[:Category:Infection requiring pathogen]] must have a dx in [[:Category:Pathogens]] or [[:Category:Double duty pathogen]] as [[Combined ICD10 codes]].)
- Check Inf Infection with implied pathogen must not have a pathogen combined code + (every dx in [[:Category:Infection with implied pathogen]] must '''not''' have a dx in [[:Category:Pathogens]] as [[Combined ICD10 codes]].)
- Query check ICD10 Inf Potential Infection must have pathogen or alt + (every dx in [[:Category:Potential infection]] must have a dx in [[:Category:Pathogens]] or [[Not an Infection (ICD10 pathogen alternative)]] as [[Combined ICD10 codes]].)