SAS Data Integrity Checks: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
mNo edit summary
mNo edit summary
Line 1: Line 1:
Julie runs checks that are not in [[:Category:Data Integrity Checks]]. They are in in the CHK*.sas programs under the  
Julie runs checks that are not in [[:Category:Data Integrity Checks]]. They are in in the CHK*.sas programs under the  
* [[X:\]]Julie\SAS\CriticalCare  
* [[X:\]]Julie\SAS\CriticalCare  
* X:\Julie\SAS\Medicine
* [[X:\]]Julie\SAS\Medicine


{{discussion}} Once we have a structure for cross-checks we should add those Julie does in SAS to here as well, using the same structure as for those listed in [[CCMDB Data Integrity Checks]]. Ttenbergen 18:13, 2018 August 16 (CDT)
{{discuss | who=Julie | question=Now that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in [[Data Integrity Checks]] Ttenbergen 20:46, 2018 October 26 (CDT)}}
 
== SMW LIST ==
Current number of CFE Data Integrity Checks: {{#ask: [[DICApp::Centralized data front end.accdb ]] |format=count }}
{{#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: SAS Data Integrity Checks]]
[[Category: SAS Data Integrity Checks]]

Revision as of 19:46, 26 October 2018

Julie runs checks that are not in Category:Data Integrity Checks. They are in in the CHK*.sas programs under the

  • X:\Julie\SAS\CriticalCare
  • X:\Julie\SAS\Medicine

Now that we have a structure for cross-checks we should add those you do in SAS to here as well, using the same structure as for those listed in Data Integrity Checks Ttenbergen 20:46, 2018 October 26 (CDT)

  • SMW


  • Cargo


  • Categories

SMW LIST

Current number of CFE Data Integrity Checks: 40

 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 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 CCI Px but no TISSretired8 September 2021 16:33:06
Query NDC VAP no TISSdeclined8 September 2021 16:33:14
Query NDC Trach Dx TISSretired16 September 2021 21:34:14
Query check CCI InExtubation consistentretired8 December 2021 22:06:13
Check VAP acquired only first encounterdeclined10 March 2022 21:25:12
Query NDC cardioversion dx vs TISSretired14 April 2022 21:20:02
Link suspect transfer ready before arrive dateretired21 April 2022 19:32:36
Query NDC CLI unacceptable dateretired21 April 2022 21:42:11
Query NDC zCRRT tmp no TISSretired20 June 2025 19:25:02
Query NDC zCRRT TISS no tmpretired20 June 2025 19:25:10
Check CRF vs ARF across multiple encountersdeclined20 June 2025 19:25:58
Reconnect check Completes queryimplemented23 July 2025 04:04:10
Query TISS Errors vent vs vent2300retired23 July 2025 04:13:15
PL SameCHART Site Diff PHINimplemented23 July 2025 04:13:18
Query NDC Pacemaker acquired vs TISSretired23 July 2025 04:13:19
Query NDC VAP unacceptable dateretired23 July 2025 04:13:19
PL SamePhin Diff DOB Seximplemented23 July 2025 04:13:20
PL 2Phin Fake or Blankimplemented23 July 2025 04:13:20
PL Chart 9 Digitimplemented23 July 2025 04:13:21
Query NDC TISS CCI endoscopicretired23 July 2025 04:13:21
Reconnect check missing L Tables content queryimplemented23 July 2025 04:13:22
PL SamePHIN Site Diff chartimplemented23 July 2025 04:13:23
Link_suspect_not_same_visitAdmitDtTm queryimplemented23 July 2025 04:13:26
Link_suspect_visitAdmitDtTm_mult_to-from-home queryready to implement23 July 2025 04:15:01
Query NDC dx implying death across encountersimplemented23 July 2025 04:15:01
Link suspect mismatch pre inpt ours incomplete queryimplemented23 July 2025 04:15:02
Link suspect mismatch pre inpt should be ours incomplete queryimplemented23 July 2025 04:15:03
Link suspect negative transit time queryimplemented23 July 2025 04:15:04
Query cardiac arrest throughout admissionready to implement23 July 2025 04:15:04
Reconnect check orphans queryimplemented23 July 2025 21:36:28
Link suspect mismatch from ours incomplete queryimplemented30 July 2025 16:33:54
Link suspect dead then alive queryimplemented30 July 2025 16:34:06
Query NDC Postal Code over timeimplemented30 July 2025 16:55:15
Query NDC Bad Postal Codeimplemented4 August 2025 16:44:59
PL DiffPhin SameLN FN DOBimplemented7 August 2025 20:13:08
Link suspect mismatch to ours incomplete queryimplemented8 December 2025 15:28:32
Retrieved from "https://ccmdb.kuality.ca/index.php?title=SAS_Data_Integrity_Checks&oldid=122244"