Data Integrity Checks/review list

From CCMDB Wiki
Jump to navigation Jump to search

This page is to review which queries we should run incomplete, and which we should decline/retire altogether.

Pagasa to review

Data processor.svg

Pagasa, regarding the meeting with Trish, Julie and Allan to decide which checks to continue to do when, please

  • expand this list to 50
  • click the “edit w f” link at the start of the line to open any that need change right in a form to use dropdowns to update them
  • confirm that all queries correctly list
    • whether you check them always or only complete (timing field)
    • whether they use L_Problem
    • whether there is a backlog (I just added that field, it defaults to "yes" so change to no if caught up)
  • SMW


  • Cargo


  • Categories

list of cross checks

edit page Status Timing L Problem back logged
edit page Status Timing L Problem back logged
edit w f Check CRF vs ARF across multiple encounters declined complete Yes Yes
edit w f Check VAP acquired only first encounter needs review always Yes Yes
edit w f Link suspect dead then alive query implemented always Yes Yes
edit w f Link suspect mismatch from ours incomplete query implemented always Yes Yes
edit w f Link suspect mismatch pre inpt ours incomplete query implemented always Yes Yes
edit w f Link suspect mismatch to ours incomplete query implemented always Yes Yes
edit w f Link suspect negative transit time query implemented always Yes Yes
edit w f Link suspect not same visitAdmitDtTm query implemented always No Yes
edit w f Link suspect transfer ready before arrive date retired always Yes No
edit w f Link suspect transfer ready greater than dispo retired always No No
edit w f PL 1orphans implemented always Yes Yes
edit w f PL 2Phin Fake or Blank implemented always Yes Yes
edit w f PL Chart 9 Digit implemented always Yes Yes
edit w f PL Diff Phin SameLN FN DOB implemented always No Yes
edit w f PL missing L Tables content implemented complete No Yes
edit w f PL SameCHART Site Diff PHIN implemented always Yes Yes
edit w f PL SamePhin Diff DOB Sex implemented always Yes Yes
edit w f PL SamePHIN Site Diff chart implemented always Yes No
edit w f Query NCD dx implying death across encounters implemented always Yes No
edit w f Query NDC Bad Postal Code implemented Yes Yes
edit w f Query NDC CLI unacceptable date retired always Yes Yes
edit w f Query NDC Pacemaker acquired vs TISS retired complete Yes Yes
edit w f Query NDC Postal Code over time implemented Yes Yes
edit w f Query NDC TISS CCI endoscopic retired complete Yes Yes
edit w f Query NDC Trach Dx TISS retired always Yes No
edit w f Query NDC VAP AcqDX but NoVAP DateinTMPV2 retired always No Yes
edit w f Query NDC VAP No AcqDX but VAP DateinTMPV2 retired always Yes Yes
edit w f Query NDC VAP no TISS declined always No Yes
edit w f Query NDC VAP unacceptable date retired always Yes Yes
edit w f Query NDC zCRRT CCI Px but no TISS retired always No Yes
edit w f Query NDC zCRRT TISS but no CCI Px retired always No Yes
edit w f Query NDC zCRRT TISS no tmp retired always No Yes
edit w f Query NDC zCRRT tmp no TISS retired always No Yes
edit w f Query TISS Errors vent vs vent2300 retired always Yes Yes