Cargo query

edit

The minimum age allowed is 10, the maximum age allowed is 120.

edit

there are no duplicate entries for the same patient ward admission on the laptop at send time

edit

can't have ARF and CRF in same record

edit

ARF (APACHE) and CRF - Chronic Renal Failure can not be coded together for the same patient.

edit

If a profile has one of the #Dialysis CCI Items there should also be one of the #Dialysis qualifying Dxs.

edit

Length 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).

edit

check that all has been entered for the Overstay project

edit

Compare Vasoactive drug IV continuous-single (TISS Item)/T14 - Vasoactive drug IV continuous-multiple simultaneous (TISS Item) against Pharmacy entries for vasoactive drugs.

edit

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

edit

organ donors must be deceased

edit

disallows any currently entered diagnosis that has been eliminated

edit

Checks that the registry times are in a sensible chronological order.

edit

LOS/Length of Stay should not be unlikely long based on historical LOS for a given ward (Service/Location field).

edit

Is the Transfer Delay (Critical Care) or Transfer Delay (Medicine) unreasonably long?

edit

Some dxs can't be Dx Types Primary Admit Diagnosis, Comorbid Diagnosis, Admit Diagnosis or Acquired Diagnosis

edit

If dx is (Brain death;Medical Assistance In Dying;Sudden cardiac death (and died)) then Dispo field must be one of the Deceased patients options

edit

Px Date must be sensible when compared to first Service tmp entry and Dispo_DtTm

edit

Due to our definition of Targeted Temperature Management (TTM) that code can only be used if there is a Cardiac arrest dx

edit

Any patient who has code in Category:Awaiting/delayed transfer has to have a (Transfer Ready DtTm or Transfer Ready DtTm tmp entry) on a different day than their Dispo DtTm.

edit

Any patient with a with Transfer Ready DtTm and Dispo DtTm on different days has to have one of the "awaiting" codes and vice versa.

edit

If an ICD10 code in Category:Awaiting/delayed transfer is Primary Admit Diagnosis/Dx Primary then Transfer Ready DtTm must equal "Arrive DtTm"

edit

any abdominal hernia complication dx must have an abdominal hernia type dx coded.

edit

Traumas need mechanisms, and mechanisms need traumas (see also Template:ICD10 Guideline Trauma w mechanism).

edit

an APACHE physiological variable is extremely high or low

edit

every dx in Category:Infection requiring pathogen must have a dx in Category:Pathogens or Category:Double duty pathogen as Combined ICD10 codes.

edit

every dx in Category:Infection with implied pathogen must not have a dx in Category:Pathogens as Combined ICD10 codes.

edit

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.

edit

every dx in Category:Antibiotic resistance must have a dx in Category:Infection with implied pathogen or in Category:Pathogens as Combined ICD10 codes.

edit

A record can not have both AIDS (disease due to HIV) and HIV infection, asymptomatic

edit

Tracheostomy related CCI and ICD10 codes must be consistent with each other.

edit

makes sure the Minimal Data Set is collected before records can be sent.

edit

Med pts must have Overstay colours

edit

pts from a location where we collect should not have Overstay colour

edit

validates Pre-admit Inpatient Institution field:

• Can not be blank
• Check function preAdmit NE Location

edit

validates Previous Location field:

• Can not be blank
• function previous_NE_Location() - Previous Location field can't be same as Service/Location field

edit

patients 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".

edit

for inpatient transfers within the WRHA, Previous Location field and Pre-admit Inpatient Institution field should be same.

edit

Validates Previous Service field: can't be empty/blank

edit

part of validating Boarding Loc

edit

check that tmp project/item combo exists for this location for a project

edit

make sure Trach Task is entered correctly

edit

error if ACP Status collection in ICU is missing part of the entry.

edit

Checks that tmp project entries only contain combinations of project and item that are allowed.

edit

checks that none of int, float, bool fields are used in this data.

edit

There must not be apostrophes in the comment field as they would mess with Julie's data analysis.

edit

If Complication Diagnosis is one of:

• Iatrogenic, infection, central venous catheter-related bloodstream infection (CVC-BSI, CLI)
• Pneumonia, ventilator-associated (VAP)

then there has to be a

• L_TmpV2 entry with project "ICU Infection Audit"

edit

If "QAInf" entry is present in L_TmpV2 then

• program must be "CC"
• the corresponding diagnosis must exist

edit

DtTm of QAInf entry has to be at least 48hrs after patient admission unless the inf_dttm is blank.

edit

CC patient has Septic Shock/Shock, septic dx and no QA Septic Shock tmp entry

edit

CC pt has QA Septic Shock tmp entry and no Septic Shock/Shock, septic dx

edit

• 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

edit

PHIN can't be the same as Chart

edit

validates 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

edit

Validates the Province field:

• can't be left blank
• must not fail function Validate_PHIN

edit

doesn't allow empty

edit

doesn't allow violation of function Transfer_Ready_DtTm_vs_status

edit

If Transfer_Ready_DtTm is blank, TR_info_status must not be; if TR_info_status has content, Transfer_Ready_DtTm must be blank.

edit

Component CCIs must have compatible component 1 and component 2

edit

If from OR or PACU, must have at least 1 CCI Procedure other than No procedure performed

edit

There has to be exactly one dx per patient with Dx Primary checked, and it has to be an Admit Diagnosis

edit

The dx with Dx Primary checked should be one of the group of Combined ICD10 codes with the lowest Dx Priority.

edit

Acquired Diagnosis / Complication must have Dx Date or Dx Date unknown, other Dx Type must have neither, and must be Admit DtTm<Dx_Date<Dispo_DtTm

edit

ICD10 entry with missing Dx_Type, Dx_Priority or No Dx Entered

edit

Admit and Comorbid ICD10 Diagnoses (except for Category:Pathogens or Category:Antibiotic resistance and Category:Mechanism and Colonized with organism (not infected)) can't be entered in duplicate.

edit

All complete patients must have at least one ICD10 entry for Dx Type Comorbid Diagnosis, which might be No Comorbidities (ICD10 code).

edit

If No Comorbidities (ICD10 code) is entered, there must really be no other comorbidities coded

edit

CCI Picklist entry with missing px, Px_Type or Px_Count

edit

CCI Component entry with missing px, Px_Type or Px_Count

edit

No duplication of CCI Component Px_Type, Px_Date

edit

No duplication of CCI Picklist Px_Type, Px_Date, Px_Count

edit

If No procedure performed in CCI Picklist there must be no other entries in CCI Picklist or CCI Component

edit

There must be no No procedure entered/Blank procedure entry in CCI Picklist.

edit

There must be at least 1 CCI entry in L_CCI_Picklist table (which might be No procedure performed)

edit

consistency of Pre acute living situation; Dispo; Postal Code and Previous Location

edit

Can't have ESRD and acute renal failure, except if there was a transplant during this ward stay

edit

can only have one stage of renal failure in Comorbid Diagnosis and in Admit Diagnosis

edit

Can't have ESRD and acute renal failure

edit

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

edit

If CCI CRRT (incl volume removal via PRISMA device) exists there should be a tmp CRRT entry and vice versa

edit

If patient has Panelling or Discharge Planning as Admit Diagnosis then Arrive DtTm field must be equal to Transfer Ready DtTm field.

edit

check for patients going to lower level of care (based on S dispo table.acuity_level) but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see Level of care hierarchy.

edit

Either Accept DtTm field must have content or Accept DtTm missing field must be checked.

edit

Validates that Postal Code field only contains characters in format allowed for a postal code

edit

• can't be blank
• can't start with a space
• can't start with a hyphen
• only allows letters, spaces and hyphens

edit

• can't be blank
• can't start with a space
• can't start with a hyphen
• only allows letters, spaces and hyphens

edit

Service/Location field can't be same as Dispo field

edit

Pre-admit Inpatient Institution field can't be same as Service/Location field

edit

Previous Location field can't be same as Service/Location field

edit

if Previous Location = <your hospital> ER (parked) and Pre-admit Inpatient Institution = "NA / not applicable" then there must be a Accept_Loc_park entry.

edit

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"

edit

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,

edit

every dx in Category:Potential infection must have a dx in Category:Pathogens or Not an Infection (ICD10 pathogen alternative) as Combined ICD10 codes.

edit

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

edit

can't be blank

edit

VAP should only be Admit Diagnosis when Previous Location is an ICU.

edit

Any marked TISS Item in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item) must have the T22 - ETT Present (TISS Item) on the same date.

edit

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

edit

A patient is discharged to IICU and does not have an IICU consult entry.

edit

A patient with T19 - Spontaneous breathing via ETT without PEEP/CPAP, with or without supplemental O2 (TISS Item) must also have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item))

edit

Runs most Category:Old_dx_check, Category:ICD10 Dx check, Category:CCI Px check, and a few other checks for dxs