Query s tmp apostrophe in comment

From CCMDB Wiki
Jump to navigationJump to search
Data Integrity Checks
Summary: There must not be apostrophes in the comment field as they would mess with Julie's data analysis.
Related: ACCU borrow, ACP Status collection in ICU, Accept Loc Park, AcceptDateSource, Alias ID collection, Allied Health Consults, Arrest Witnessing, Bed Census Data Processing Instructions, Bed census.mdb, File:BedCensusAnnouncement Letter May 2012.pdf, CCU Service Tracking, CRRT, Cardiac Arrest Cooling Protocol, Catheter09, Catheter09 Wednesday, November 25, 2009, Catheter09 Wednesday, October 28.09, Check overstay not entered, Comfort Care, Contacting Quality Officer and Manager for VAPs and CLIs, Creating a new project article, Critical Care Vital Signs Monitoring, Decubitus Ulcer Study, DeviceUse Study, Early ID study, EuroScore, Family Satisfaction in the Intensive Care Unit, File:Form Individual Site Bed example .pdf, File:Form Site Bed Data Summary.pdf, Function TmpChecker, H1N1, IABP project, ICUotherService, IICU consult, Influenza tracking, Influenza treated, L TmpV2 table, Legacy Processing Instructions Bed census.mdb, List of Factor affecting data quality, Medical Incompetency tracking, Moves for Medicine, Overstay Predictor Project, Peer Audit, Peer Audit Partners, Programmer-Peer Audit output problem table, Template:Project, Project ABO TEE, Project Borrow arrive, Projects, QA Infection, QA Infection CLI, QA Infection VAP, QA Septic Shock, Query NDC CLI AcqDX but NoCLI DateinTMPV2, Query NDC CLI No AcqDX but CLI DateinTMPV2, Query NDC zCRRT TISS no tmp, Query NDC zCRRT tmp no TISS, Query check CCI CRRT vs Tmp, Query check overstay no colour, Query check overstay pt from our med, Query check tmp generate allowed, Query s tmp ABO TEE checks, 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 IICU consult DtTm, Query s tmp IICU consult dispo to IICU but no tmp, Query s tmp QASeptic Dx no tmp ICD10, Query s tmp QASeptic tmp no dx, Query s tmp apostrophe in comment, Query s tmp project item consistent, Re-import of TmpV2 data from Julie's Export 2014-09-08, Re-import of TmpV2 data from Julie's Export 2014-09-18, Re-import of TmpV2 data from Julie's Export 2014-09-22, Re-import of TmpV2 data from Julie's Export 2014-09-25, Septic Shock Order Set, SmartPump Audit, Staphylococcus aureus, TMP dates imported backwards, Temporary study guidelines, Transfer Delay, Transfusion Audit, VAP - Ventilator Associated Pneumonia, WRHA Outcomes Improvement Team
Firmness: hard check
Timing:
App: CCMDB.mdb
Coding: query s_tmp_apostrophe_in_comment
Uses L Problem table: not entered
Status: implemented
Implementation Date: 2016-Jun-02

 

Implementation date would have been before this, but that is when a tweak is mentioned in logs. .