CFE Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 17: Line 17:
* [[Pre-linking checks]]
* [[Pre-linking checks]]
* [[Quality Assurance queries in CFE]]
* [[Quality Assurance queries in CFE]]
{{#ask: [[DICApp::Centralized data front end.accdb]]
|?DICStatus = Status
|?Modification date
|sort=Modification date
|order=ascending
|limit=1000
|format=broadtable
|link=all
|class=sortable wikitable smwtable
}}


[[Category:CCMDB Data Integrity Checks| *]]
[[Category:CCMDB Data Integrity Checks| *]]

Revision as of 15:10, 2018 September 25

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

 StatusModification 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 timeimplemented15 January 2020 19:15:00
PL SamePhin Diff DOB Seximplemented17 December 2020 19:27:52
Query NDC VAP AcqDX but NoVAP DateinTMPV2retired27 January 2021 22:19:59
Query NDC VAP No AcqDX but VAP DateinTMPV2retired27 January 2021 22:20:09
Link suspect transfer ready greater than disporetired29 January 2021 00:37:59
Query NDC zCRRT TISS but no CCI Pxretired8 September 2021 16:33:05
Query NDC zCRRT tmp no TISSretired8 September 2021 16:33:05
Query NDC zCRRT CCI Px but no TISSretired8 September 2021 16:33:06
Query NDC VAP no TISSdeclined8 September 2021 16:33:14
Query NDC zCRRT TISS no tmpretired8 September 2021 16:33:18
Query NDC Trach Dx TISSretired16 September 2021 21:34:14
Query NDC TISS CCI endoscopicretired7 October 2021 19:28:23
Query NDC Pacemaker acquired vs TISSretired7 October 2021 19:42:53
Query TISS Errors vent vs vent2300retired7 October 2021 20:27:47
Query check CCI InExtubation consistentretired8 December 2021 22:06:13
Check VAP acquired only first encounterdeclined10 March 2022 21:25:12
PL Chart 9 Digitimplemented18 March 2022 20:28:12
PL Diff Phin SameLN FN DOBimplemented18 March 2022 20:29:04
PL SameCHART Site Diff PHINimplemented21 March 2022 20:06:41
Reconnect check missing L Tables content queryimplemented30 March 2022 15:19:28
Reconnect check Completes queryimplemented5 April 2022 19:52:01
PL SamePHIN Site Diff chartimplemented13 April 2022 22:36:32
Query NDC cardioversion dx vs TISSretired14 April 2022 21:20:02
Query NDC VAP unacceptable dateretired19 April 2022 20:44:31
Link suspect transfer ready before arrive dateretired21 April 2022 19:32:36
Query NDC CLI unacceptable dateretired21 April 2022 21:42:11
Link suspect dead then alive queryimplemented14 June 2022 20:20:04
Link suspect mismatch to ours incomplete queryimplemented14 June 2022 20:30:28
Link suspect mismatch from ours incomplete queryimplemented14 June 2022 20:30:34
Link suspect mismatch pre inpt ours incomplete queryimplemented14 June 2022 20:30:39
Check CRF vs ARF across multiple encountersdeclined23 June 2022 21:19:13
Link suspect negative transit time queryimplemented28 September 2022 16:57:53
Link suspect mismatch pre inpt should be ours incomplete queryimplemented19 October 2022 15:08:56
PL 2Phin Fake or Blankimplemented7 December 2022 18:12:16
Query NDC Bad Postal Codeimplemented4 May 2023 17:03:24
Link suspect not same visitAdmitDtTm queryimplemented7 June 2023 20:18:15
Query NDC dx implying death across encountersimplemented28 June 2023 15:33:55
Reconnect check orphans queryimplemented29 August 2023 14:46:18
Query cardiac arrest throughout admissionneeds review3 October 2024 17:46:37