Cargo query

edit

Record has T33 - CRRT (TISS Item) but no CRRT Project tmp entry

edit

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

edit

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

edit

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

edit

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

edit

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

edit

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

edit

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

edit

Records with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.

edit

VAP should only be Acquired Diagnosis on the first encounter.

edit

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

edit

Record has CRRT tmp but no T33 - CRRT (TISS Item) entry

edit

If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px

edit

If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px

edit

Cross check of postal codes for consistency during a continuous hospital admission

edit

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

edit

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

edit

What is description

edit

Shows any records in that have RecordStatus "Complete", indicating failed send.

edit

Checks for Arrive DtTm before QA Infection VAP date and Dispo DtTm after QA Infection VAP date.

edit

If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day.

edit

If a patient has a Acquired Diagnosis Pneumonia, ventilator-associated (VAP) and no TISS28 items T18 - Invasive Mechanical Ventilation (TISS Item) (T18) then this is an error.

edit

Category:Diagnosis implying death across encounters

edit

If pt has Acquired Procedure Cardioversion (EXCLUDE defibrillation-we are not tracking), then the TISS28 item T26 & 27 - Cardioversion (TISS Item) (T41) must be marked.

edit

Complete patients must have entries in all of

• L_ICD10 table
• L_CCI_Picklist table
• L_Labs_Flowsheet table
• L_Pharm_Flowsheet table

edit

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.

edit

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.

edit

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.

edit

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.

edit

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.

edit

Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.

edit

Any marked TISS Item T - Invasive mechanical ventilation at 2300 hrs (TISS Item) has to have a corresponding marked TISS Item T18 - Invasive Mechanical Ventilation (TISS Item) for the same date.

edit

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)

edit

Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.

edit

Checks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTm

edit

Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .

edit

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

edit

Cross check of postal codes against known postal codes

• I think this is the process where you said you are having problems with copy/pasting. Copy pasting isn't even mentioned here, so maybe update the process to show how you actually do this, so that someone like Sheila Rusnak would be able to follow the instructions. Ttenbergen 15:45, 2022 March 17 (CDT)
  • Do you create that query each time? Would we be able to update the NDC query that finds these in the first place to include the info you need? We can discuss at our next meeting. Ttenbergen 16:23, 2022 March 17 (CDT)
    • Taking this off Pagasa's list for now, since if we can get this data from DSS we won't need to do this any more. Ttenbergen 15:36, 2022 March 24 (CDT)

edit

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.

JALT Review after 2023-09-15

• Lisa flagged that, if we do this for Cardiac Arrest, we should really do it for other dxs as well. And if we did that, it could result in a lot of work since it would need to be mediated by Pagasa for now. So we decided to see where the SF implementation goes and review the definition of this check once we have a centralized tool where the data collector would not need to mediate this. Ttenbergen 15:43, 2023 July 13 (CDT)