View table: DataIntegrityChecks

Can't have ESRD and acute renal failure

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

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

an APACHE physiological variable is extremely high or low

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.

If a patient had a comorbid of CRF in any previous admission then ARF can not be an admit or complication in subsequent admissions.

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

disallows any currently entered diagnosis that has been eliminated

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

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

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

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

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

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

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

can't be blank

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

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

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

organ donors must be deceased

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

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,

VAP should only be Acquired Diagnosis on the first encounter.

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

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

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

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

PHIN can't be the same as Chart

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

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

doesn't allow empty

• 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

validates Pre-admit Inpatient Institution field:

• Can not be blank
• Check function preAdmit NE Location

validates Previous Location field:

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

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

Validates the Province field:

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

doesn't allow violation of function Transfer_Ready_DtTm_vs_status

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.

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.

Checks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.

What is description

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.

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.

Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.

Checks for records that have Transfer Ready DtTm field is before Arrive_DtTm field.

Checks for records that have Transfer Ready DtTm field is greater than Dispo DtTm field.

Finds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.

Finds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart number

Checks that there are no likely matches of this patient with a different PHIN (ie typos)

A record with this Chart number already exists for this service/Location and it has a different PHIN.

Another record exists with the same PHIN but a different Date of Birth, Sex

Another record exists for this site with the same PHIN and a different Chart number.

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.

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

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

Checks that all Boarding Loc / Transfer Ready DtTm tmp entry pairs have a non-null combiner integer.

Component CCIs must have compatible component 1 and component 2

No duplication of CCI Component Px_Type, Px_Date

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

CCI Component entry with missing px, Px_Type or Px_Count

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

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

Confirm that a Category:Labs Imaging count is not unreasonably high

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

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

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

Any marked TISS Item T40 - Insertion of ETT (TISS Item) or in T22 - ETT Present (TISS Item) must have at least one marked TISS item either in T28 - Planned extubation (TISS Item) or in T29 - Unplanned extubation (TISS Item)

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

No duplication of CCI Picklist Px_Type, Px_Date, Px_Count

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

CCI Picklist entry with missing px, Px_Type or Px_Count

Checks that each T9 - CAM positive (TISS Item) goes with an ICD10 code from Category:Delirium

T22 - ETT Present (TISS Item) should start with an T40 - Insertion of ETT (TISS Item) and end with an T28 - Planned extubation (TISS Item) or T29 - Unplanned extubation (TISS Item).

If No TISS Item (TISS Item) in CCI Picklist there must be no other entry from TISS Item List in CCI Picklist, and vice versa

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.

If the Px Date component of a CCI Picklist has a time, then there must be a corresponding Boarding Loc entry

There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm

There are more TISS Item Px_Dates than there are days between the first Service tmp entry and Dispo DtTm

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

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

If certain Px Dates have a time component, then there should also be a matching CCI Picklist without the time

Any marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) has to have (T22 - ETT Present (TISS Item) or T23 - Trach Tube Present (TISS Item)) for the same date.

Confirm that CCI Collection Mode or CCI Component CCI collect count days items don't have a count > LOS.

Confirm that CCI Collection Mode for CCI Picklist CCI collect count days items don't have a count > LOS.

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

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.

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

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

disallows any currently entered diagnosis that has been eliminated

disallows any currently entered diagnosis that has been eliminated

disallows any currently entered diagnosis that has been eliminated

Each Transfer Ready DtTm tmp entry has to have either a dttm, or its checkbox checked.

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

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.

Chronic dependence on mechanical ventilator should not be coded with Respiratory failure (insufficiency) NOS, acute

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

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

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

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