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 Postal Code over time	implemented	15 January 2020 19:15:00
PL SamePhin Diff DOB Sex	implemented	17 December 2020 19:27:52
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 tmp no TISS	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 zCRRT TISS no tmp	retired	8 September 2021 16:33:18
Query NDC Trach Dx TISS	retired	16 September 2021 21:34:14
Query NDC TISS CCI endoscopic	retired	7 October 2021 19:28:23
Query NDC Pacemaker acquired vs TISS	retired	7 October 2021 19:42:53
Query TISS Errors vent vs vent2300	retired	7 October 2021 20:27:47
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
PL Chart 9 Digit	implemented	18 March 2022 20:28:12
PL Diff Phin SameLN FN DOB	implemented	18 March 2022 20:29:04
PL SameCHART Site Diff PHIN	implemented	21 March 2022 20:06:41
Reconnect check missing L Tables content query	implemented	30 March 2022 15:19:28
Reconnect check Completes query	implemented	5 April 2022 19:52:01
PL SamePHIN Site Diff chart	implemented	13 April 2022 22:36:32
Query NDC cardioversion dx vs TISS	retired	14 April 2022 21:20:02
Query NDC VAP unacceptable date	retired	19 April 2022 20:44:31
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
Link suspect dead then alive query	implemented	14 June 2022 20:20:04
Link suspect mismatch to ours incomplete query	implemented	14 June 2022 20:30:28
Link suspect mismatch from ours incomplete query	implemented	14 June 2022 20:30:34
Link suspect mismatch pre inpt ours incomplete query	implemented	14 June 2022 20:30:39
Check CRF vs ARF across multiple encounters	declined	23 June 2022 21:19:13
Link suspect negative transit time query	implemented	28 September 2022 16:57:53
Link suspect mismatch pre inpt should be ours incomplete query	implemented	19 October 2022 15:08:56
PL 2Phin Fake or Blank	implemented	7 December 2022 18:12:16
Query NDC Bad Postal Code	implemented	4 May 2023 17:03:24
Link suspect not same visitAdmitDtTm query	implemented	7 June 2023 20:18:15
Query NDC dx implying death across encounters	implemented	28 June 2023 15:33:55
Reconnect check orphans query	implemented	29 August 2023 14:46:18
Query cardiac arrest throughout admission	needs review	3 October 2024 17:46:37