CFE Data Integrity Checks

This page lists pages that have CFE Data Integrity Checks on them, the status of those checks if available.

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

information that still needs to be integrated

• Pre-linking checks
• Quality Assurance queries in CFE

SMW LIST

	Status	Modification date"Modification date" is a predefined property that corresponds to the date of the last modification of a subject and is provided by Semantic MediaWiki.
Query NDC VAP AcqDX but NoVAP DateinTMPV2	retired	27 January 2021 22:19:59
Query NDC VAP No AcqDX but VAP DateinTMPV2	retired	27 January 2021 22:20:09
Link suspect transfer ready greater than dispo	retired	29 January 2021 00:37:59
Query NDC zCRRT TISS but no CCI Px	retired	8 September 2021 16:33:05
Query NDC zCRRT CCI Px but no TISS	retired	8 September 2021 16:33:06
Query NDC VAP no TISS	declined	8 September 2021 16:33:14
Query NDC Trach Dx TISS	retired	16 September 2021 21:34:14
Query check CCI InExtubation consistent	retired	8 December 2021 22:06:13
Check VAP acquired only first encounter	declined	10 March 2022 21:25:12
Query NDC cardioversion dx vs TISS	retired	14 April 2022 21:20:02
Link suspect transfer ready before arrive date	retired	21 April 2022 19:32:36
Query NDC CLI unacceptable date	retired	21 April 2022 21:42:11
Query NDC zCRRT tmp no TISS	retired	20 June 2025 19:25:02
Query NDC zCRRT TISS no tmp	retired	20 June 2025 19:25:10
Check CRF vs ARF across multiple encounters	declined	20 June 2025 19:25:58
Reconnect check Completes query	implemented	23 July 2025 04:04:10
Query TISS Errors vent vs vent2300	retired	23 July 2025 04:13:15
PL SameCHART Site Diff PHIN	implemented	23 July 2025 04:13:18
Query NDC Pacemaker acquired vs TISS	retired	23 July 2025 04:13:19
Query NDC VAP unacceptable date	retired	23 July 2025 04:13:19
PL SamePhin Diff DOB Sex	implemented	23 July 2025 04:13:20
PL 2Phin Fake or Blank	implemented	23 July 2025 04:13:20
PL Chart 9 Digit	implemented	23 July 2025 04:13:21
Query NDC TISS CCI endoscopic	retired	23 July 2025 04:13:21
Reconnect check missing L Tables content query	implemented	23 July 2025 04:13:22
PL SamePHIN Site Diff chart	implemented	23 July 2025 04:13:23
Link_suspect_not_same_visitAdmitDtTm query	implemented	23 July 2025 04:13:26
Link_suspect_visitAdmitDtTm_mult_to-from-home query	ready to implement	23 July 2025 04:15:01
Query NDC dx implying death across encounters	implemented	23 July 2025 04:15:01
Link suspect mismatch pre inpt ours incomplete query	implemented	23 July 2025 04:15:02
Link suspect mismatch pre inpt should be ours incomplete query	implemented	23 July 2025 04:15:03
Link suspect negative transit time query	implemented	23 July 2025 04:15:04
Query cardiac arrest throughout admission	ready to implement	23 July 2025 04:15:04
Reconnect check orphans query	implemented	23 July 2025 21:36:28
Link suspect mismatch from ours incomplete query	implemented	30 July 2025 16:33:54
Link suspect dead then alive query	implemented	30 July 2025 16:34:06
Query NDC Postal Code over time	implemented	30 July 2025 16:55:15
Query NDC Bad Postal Code	implemented	4 August 2025 16:44:59
PL DiffPhin SameLN FN DOB	implemented	7 August 2025 20:13:08
Link suspect mismatch to ours incomplete query	implemented	8 December 2025 15:28:32