CFE Data Integrity Checks

From CCMDB Wiki
Revision as of 13:59, 2021 September 15 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search

This page lists pages that have CFE Data Integrity Checks on them, the status of those checks if available. See also the following for the order in which these checks are run and how they are used:

See Template:Data Integrity Check for how to get things on this list.

Currently active checks

edit page Status Timing Firmness Summary question who
edit page Status Timing Firmness Summary question who
edit PL SamePhin Diff DOB Sex implemented always hard check Another record exists with the same PHIN but a different Date of Birth, Sex
edit Reconnect check Completes query implemented complete hard check Shows any records in that have RecordStatus "Complete", indicating failed send.
edit Link suspect mismatch pre inpt should be ours incomplete query implemented always hard check What is description
edit Query NDC Postal Code over time implemented hard check Cross check of postal codes for consistency during a continuous hospital admission
edit Link suspect not same visitAdmitDtTm query implemented always soft check Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.
edit Link suspect mismatch pre inpt ours incomplete query implemented always soft check Checks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.
edit PL 2Phin Fake or Blank implemented always hard check Finds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.
edit PL Chart 9 Digit implemented always hard check Finds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart number
edit PL Diff Phin SameLN FN DOB implemented always soft check Checks that there are no likely matches of this patient with a different PHIN (ie typos)
edit PL SameCHART Site Diff PHIN implemented always hard check A record with this Chart number already exists for this service/Location and it has a different PHIN.
edit PL SamePHIN Site Diff chart implemented always soft check Another record exists for this site with the same PHIN and a different Chart number.
edit Link suspect negative transit time query implemented always hard check 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 Link suspect mismatch to ours incomplete query implemented always hard check 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 Link suspect mismatch from ours incomplete query implemented always hard check 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 Link suspect dead then alive query implemented always hard check 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 Reconnect check orphans query implemented always hard check Record meets following conditions
edit Reconnect check missing L Tables content query implemented complete hard check Complete patients must have entries in all of
  • L_ICD10 table
  • L_CCI_Picklist table
  • L_Labs_Flowsheet table
  • L_Pharm_Flowsheet table
    		•
    edit Query NDC dx implying death across encounters implemented always hard check Category:Diagnosis implying death across encounters
    edit Query NDC Bad Postal Code implemented hard check 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)
    		•  Tina
    edit Query cardiac arrest throughout admission needs review complete hard check 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)
    		•  all

    All checks

    edit page Status Timing Firmness Summary question who
    edit page Status Timing Firmness Summary question who
    edit Query NDC zCRRT TISS no tmp retired always hard check Record has T33 - CRRT (TISS Item) but no CRRT Project tmp entry
    edit PL SamePhin Diff DOB Sex implemented always hard check Another record exists with the same PHIN but a different Date of Birth, Sex
    edit PL SameCHART Site Diff PHIN implemented always hard check A record with this Chart number already exists for this service/Location and it has a different PHIN.
    edit PL Diff Phin SameLN FN DOB implemented always soft check Checks that there are no likely matches of this patient with a different PHIN (ie typos)
    edit PL Chart 9 Digit implemented always hard check Finds any chart numbers that have >8 digits. This would usually mean someone confused a PHIN and a Chart number
    edit PL 2Phin Fake or Blank implemented always hard check Finds blank PHINs and those entered to meet function Validate_PHIN so Data Processor can apply PseudoPHIN via Generating PseudoPHINs.
    edit Link suspect mismatch pre inpt ours incomplete query implemented always soft check Checks for patients where Pre-admit Inpatient Institution is one of ours but we don't have a corresponding record.
    edit Link suspect not same visitAdmitDtTm query implemented always soft check Checks for records that are likely part of the same admission but have different Visit Admit DtTm field.
    edit Query NDC Pacemaker acquired vs TISS retired complete hard check Records with Acquired Procedure of Pacemaker insertion, temporary that don't have date-matching Pacemaker insertion or vice versa.
    edit Check VAP acquired only first encounter declined always hard check VAP should only be Acquired Diagnosis on the first encounter.
    edit Check CRF vs ARF across multiple encounters declined complete hard check 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 Query NDC zCRRT tmp no TISS retired always hard check Record has CRRT tmp but no T33 - CRRT (TISS Item) entry
    edit Query NDC zCRRT CCI Px but no TISS retired always hard check If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px
    edit Query NDC zCRRT TISS but no CCI Px retired always hard check If there is a T33 - CRRT (TISS Item) then there should be a CRRT (incl volume removal via PRISMA device) CCI Px
    edit Query NDC Postal Code over time implemented hard check Cross check of postal codes for consistency during a continuous hospital admission
    edit Link suspect transfer ready greater than dispo retired always hard check Checks for records that have Transfer Ready DtTm field is greater than Dispo DtTm field.
    edit Link suspect transfer ready before arrive date retired always hard check Checks for records that have Transfer Ready DtTm field is before Arrive_DtTm field.
    edit Link suspect mismatch pre inpt should be ours incomplete query implemented always hard check What is description
    edit Reconnect check Completes query implemented complete hard check Shows any records in that have RecordStatus "Complete", indicating failed send.
    edit Query NDC VAP unacceptable date retired always hard check Checks for Arrive DtTm before QA Infection VAP date and Dispo DtTm after QA Infection VAP date.
    edit Query NDC TISS CCI endoscopic retired complete hard check If pt has T26 & 27 - Endoscopy (TISS Item) then there must be an endoscopic CCI for that day.
    edit Query NDC VAP no TISS declined always hard check 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 Query NDC dx implying death across encounters implemented always hard check Category:Diagnosis implying death across encounters
    edit Query NDC cardioversion dx vs TISS retired complete hard check 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 Reconnect check missing L Tables content query implemented complete hard check Complete patients must have entries in all of
    edit Reconnect check orphans query implemented always hard check 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 Link suspect dead then alive query implemented always hard check 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 Link suspect mismatch from ours incomplete query implemented always hard check 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 Link suspect mismatch to ours incomplete query implemented always hard check 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 Link suspect negative transit time query implemented always hard check 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 Query NDC Trach Dx TISS retired always hard check Tracheostomy ICD10s and CCIs must be consistent with Trach TISS.
    edit Query TISS Errors vent vs vent2300 retired always hard check 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 Query check CCI InExtubation consistent retired always soft check 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 Query NDC VAP AcqDX but NoVAP DateinTMPV2 retired always hard check Checks that any record with an Acquired Diagnosis VAP has a QA Infection VAP entry with a date.
    edit Query NDC CLI unacceptable date retired always hard check Checks that the QA Infection CLI Dt is between the Arrive DtTm and Dispo DtTm
    edit Query NDC VAP No AcqDX but VAP DateinTMPV2 retired always hard check Checks that any record with QA Infection VAP entry with a date also has an Acquired Diagnosis VAP .
    edit PL SamePHIN Site Diff chart implemented always soft check Another record exists for this site with the same PHIN and a different Chart number.
    edit Query NDC Bad Postal Code implemented hard check 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)
    		•  Tina
    edit Query cardiac arrest throughout admission needs review complete hard check 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)
    		•  all



    Related articles

    Related articles:
    Retrieved from "https://ccmdb.kuality.ca/index.php?title=CFE_Data_Integrity_Checks&oldid=152008"