Category:Data Integrity Checks

A

• APACHE check (3 P)

C

• CCI Px check (1 C, 34 P)
• CCMDB.accdb cross checks triggering for correct values (2 P)
• CFE Data Integrity Checks (1 P)

D

• Data Integrity Check wiki infrastructure (8 P)
• DSM check (1 P)

I

• ICD10 Dx check (46 P)

L

• Legacy Tmp check (2 P)

M

• Multiple encounter longitudinal consistency check (10 P)

O

• Old dx check (15 P)

R

• Registry checks (1 C, 60 P)

S

• SAS Data Integrity Checks (1 P)
• Service/Location check (4 P)

T

• TISS28 check (1 C, 21 P)
• Tmp check (33 P)

• CCMDB.accdb Data Integrity Checks
• CFE Data Integrity Checks
• Data Integrity Check ready to implement
• Data Integrity Check under review
• Data Integrity Checks
• Soft checks

C

• Can't check ICD10 ARF vs APACHE ARF
• CFE Inline Integrity Checks
• Check Accept Loc Park
• Check AcceptDtTm entered or missing checked
• Check APACHE physiological variable high low
• Check BRR/XBR vs cardiac arrest dx
• Check CRF vs ARF across multiple encounters
• Check duplicate patient
• Check eliminated dx
• Check function location NE dispo
• Check Function Panelling admit transfer same
• Check function preAdmit NE Location
• Check function previous NE Location
• Check function Validate First name
• Check function Validate Last name
• Check Function Validate PostalCode
• Check function Validate Pre Acute Living Situation
• Check if awaiting code is primary dx then Transfer Ready DtTm must be equal to Arrive DtTm
• Check Inf Antibiotic resistance must have pathogen or Infection with implied pathogen
• Check Inf Infection with implied pathogen must not have a pathogen combined code
• Check organ donors must be dead
• Check pre acute consistent
• Check Sub PharmCheck
• Check VAP acquired only first encounter
• Controlling Dx Type for ICD10 codes

D

• Date of Birth

F

• Function Dispo Chronological()
• Function long LOS()
• Function PHIN same as Chart
• Function Transfer Ready DtTm vs status
• Function Validate Chart
• Function Validate Dispo
• Function Validate PHIN
• Function Validate Pre admit Inpatient Institution
• Function Validate Previous Location
• Function Validate previous service
• Function Validate Province
• Function Validate Transfer Ready DtTm

L

• Link suspect dead then alive query
• Link suspect mismatch from ours incomplete query
• Link suspect mismatch pre inpt ours incomplete query
• Link suspect mismatch pre inpt should be ours incomplete query
• Link suspect mismatch to ours incomplete query
• Link suspect negative transit time query
• Link suspect not same visitAdmitDtTm query
• Link suspect transfer ready before arrive date
• Link suspect transfer ready greater than dispo

M

• Multiple encounter consistency checks

P

• PL 2Phin Fake or Blank
• PL Chart 9 Digit
• PL Diff Phin SameLN FN DOB
• PL SameCHART Site Diff PHIN
• PL SamePhin Diff DOB Sex
• PL SamePHIN Site Diff chart

Q

• Query cardiac arrest throughout admission
• Query check AIDS vs HIV
• Query check ApARF CRF
• Query Check BL TR combiner null
• Query check CCI component 1 and 2 compatible
• Query check CCI Component duplicates
• Query check CCI Component no admin entries
• Query check CCI Component unfilled
• Query check CCI CRRT vs Tmp
• Query check CCI Date
• Query check CCI each count vs LOS
• Query check CCI from OR no CCI
• Query check CCI ICD10 Dialysis no Dx
• Query check CCI if no then none
• Query check CCI InExtubation consistent
• Query check CCI must have entry
• Query check CCI Picklist duplicates
• Query check CCI Picklist if no admin entries
• Query check CCI Picklist unfilled
• Query check CCI TISS CAM positive vs Dx
• Query check CCI TISS discontinuous ETT
• Query check CCI TISS if no then none
• Query check CCI TISS Intubation vs Intubated
• Query check CCI TISS matching BoardingLoc time
• Query check CCI TISS NrDays GT LOS
• Query check CCI TISS NrDays LT LOS
• Query check CCI TISS Pharm Vasoactive
• Query check CCI TISS spont breath no tube
• Query check CCI TISS time means must be two
• Query check CCI TISS Vented without mechanism
• Query check CCI vs LOS count days component
• Query check CCI vs LOS count days picklist
• Query check cooling vs arrest
• Query check dispo lower acuity than location
• Query check dx primary lowest priority
• Query check dx primary not exactly one
• Query check eliminated CCI Comp
• Query check eliminated CCI Pick
• Query check eliminated ICD10
• Query check has transfer ready date or checkbox
• Query check hernia type vs complication
• Query check ICD10 awaiting has Transfer Ready DtTm
• Query check ICD10 chronic vent acute resp failure
• Query check ICD10 CLI vs CCI CentralLine
• Query check ICD10 Comorbids Dx present
• Query check ICD10 Comorbids NoComo code but others
• Query check ICD10 date
• Query check ICD10 duplicates
• Query check ICD10 dx implying death must have appropriate dispo
• Query check ICD10 ESRD and AKI only if transplant
• Query check ICD10 ESRD vs AP ARF
• Query check ICD10 ESRD vs ARF
• Query check ICD10 ESRD vs kidney transplant
• Query check ICD10 Inf Infection req Pathogen must have one
• Query check ICD10 Inf Potential Infection must have pathogen or alt
• Query check ICD10 mechanism vs trauma
• Query check ICD10 needs awaiting if TR Dt and Dispo Dt on diff days
• Query check ICD10 only 1 stage of renal failure
• Query check ICD10 stroke
• Query check ICD10 trach create but no TISS
• Query check ICD10 trach dxs consistent
• Query check ICD10 trach has trach but no TISS
• Query check ICD10 unfilled
• Query Check Inf Pathogens must have Infection requiring pathogen or Potential Infection
• Query check long transfer delay
• Query check minimal data set incomplete
• Query check no consecutive same BL or Service
• Query check overstay no colour
• Query check overstay not entered
• Query check overstay pt from our med
• Query check prev pre-admit consistent
• Query check previous location vs service inconsistent
• Query check pt from ER
• Query Check Renal IncompatibleDxs
• Query check TISS each day
• Query check tmp 2 BL TR S same tm
• Query check tmp BedHeld
• Query check tmp Boarding Loc Service first same
• Query check tmp ER Boarding Loc should exist if from ER
• Query check tmp generate allowed
• Query check tmp Service and Boarding Loc during admission timeframe
• Query check tmp service and program consistency
• Query check tmp service or location duplicate
• Query check tmp Transfer Ready not before Boarding Loc
• Query check trach dx task
• Query check Transfer DtTm after paired BL and before later BL
• Query check transfer DtTm during admission
• Query check transfer ready tmp for each Boarding Loc
• Query check VAP admit must be from ICU
• Query Import request matcher
• Query NDC Bad Postal Code
• Query NDC cardioversion dx vs TISS
• Query NDC CLI unacceptable date
• Query NDC Dialysis TISS CCI
• Query NDC dx implying death across encounters
• Query NDC Pacemaker acquired vs TISS
• Query NDC Postal Code over time
• Query NDC TISS CCI endoscopic
• Query NDC Trach Dx TISS
• Query NDC VAP AcqDX but NoVAP DateinTMPV2
• Query NDC VAP No AcqDX but VAP DateinTMPV2
• Query NDC VAP no TISS
• Query NDC VAP unacceptable date
• Query NDC zCRRT CCI Px but no TISS
• Query NDC zCRRT TISS but no CCI Px
• Query NDC zCRRT TISS no tmp
• Query NDC zCRRT tmp no TISS
• Query s tmp ABO TEE checks
• Query s tmp ACP
• Query s tmp AHC consistent
• Query s tmp apostrophe in comment
• Query s tmp Boarding Loc date item
• Query s tmp Boarding Loc ER delay reasonable
• Query s tmp Boarding Loc no borrow but entry
• Query s tmp Borrow duplicates
• Query s tmp Borrow no borrow on own unit
• Query s tmp Borrow sensible DtTm vs no borrow
• Query s tmp check Boarding Loc and TransferReadyDtTm pairs
• Query s tmp check combined BL and TRDtTm nonsequential
• Query s tmp check combined Boarding Loc and TransferReadyDtTm
• Query s tmp comfort care gt one
• Query s tmp EuroSCORE II checks
• Query s tmp IICU consult dispo to IICU but no tmp
• Query s tmp IICU consult DtTm
• Query s tmp project item consistent
• Query s tmp QAInf basic
• Query s tmp QAInf dx no tmp
• Query s tmp QAInf LT 48 hrs after admit
• Query s tmp QAInf tmp no dx
• Query s tmp QASeptic Dx no tmp ICD10
• Query s tmp QASeptic tmp no dx
• Query send check centralized is owner
• Query TISS Errors BIPAP vs BIPAP2300
• Query TISS Errors CVC vs CVC2300
• Query TISS Errors D ID not in CFE
• Query TISS Errors duplicate Items
• Query TISS Errors missing days
• Query TISS Errors NrTISSDays NE LOS
• Query TISS Errors TISS date out of admission
• Query TISS Errors vent vs vent2300