CFE Data Integrity Checks
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 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 | 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. | ||
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 | Query NDC dx implying death across encounters | implemented | always | hard check | Category:Diagnosis implying death across encounters | ||
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 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
| ||
edit | Query NDC Bad Postal Code | implemented | hard check | Cross check of postal codes against known postal codes |
| Tina |
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 | 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 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 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. | ||
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 | 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 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
| ||
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 | 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 | 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 | 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 Bad Postal Code | implemented | hard check | Cross check of postal codes against known postal codes |
| Tina |