Query s tmp apostrophe in comment

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, BedHeldEnd DtTm, Boarding Loc, CCU Service Tracking, CRRT Project, Cardiac Arrest Cooling Protocol, Catheter09, Catheter09 Wednesday, November 25, 2009, Catheter09 Wednesday, October 28.09, Check Accept Loc Park, Comfort Care, Creating a new project article, Decubitus Ulcer Study, DeviceUse Study, Early ID study, EuroSCORE II, EuroScore, 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, Parked in ER tmp entry, Peer Audit, Peer Audit Partners, Programmer-Peer Audit output problem table, Template:Project, Project ABO TEE, Project Borrow arrive, Project Discharge Documentation, Project Legacy Co-managed, Project Legacy HSC CCU Loc, Projects, QA Infection, QA Infection CLI, QA Infection VAP, QA Septic Shock, Query cardiac arrest throughout admission, Query check CCI CRRT vs Tmp, Query check overstay no colour, Query check overstay not entered, Query check overstay pt from our med, Query check tmp 2 BL TR S same tm, Query check tmp BedHeld, Query check tmp Boarding Loc Service first same, Query check tmp ER Boarding Loc should exist if from ER, Query check tmp Service and Boarding Loc during admission timeframe, Query check tmp Transfer Ready not before Boarding Loc, Query check tmp generate allowed, Query check tmp service and program consistency, Query check tmp service or location duplicate, Query s tmp ABO TEE checks, Query s tmp Boarding Loc ER delay reasonable, Query s tmp Boarding Loc date item, Query s tmp Boarding Loc no borrow but entry, 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 EuroSCORE II checks, 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 check Boarding Loc and TransferReadyDtTm pairs, Query s tmp check combined BL and TRDtTm nonsequential, Query s tmp check combined Boarding Loc and TransferReadyDtTm, 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, Service tmp entry, SmartPump Audit, TISS form audit, TMP dates imported backwards, Temporary study guidelines, Transfer Ready DtTm tmp entry, Transfusion Audit, VAP - Ventilator Associated Pneumonia
Firmness:	hard check
Timing:
App:	CCMDB.accdb
Coding:	query s_tmp_apostrophe_in_comment
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	2016-Jun-02
Backlogged:	true

• Cargo

• SMW

• Categories: 

• form:

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