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, ACP Status Collection for LAU, ACP Status Collection in ICU, Accept Loc Park, AcceptDateSource, Alias ID collection, Allied Health Consults, Arrest Witnessing, Assisted Living, Automatic Generation of TMP entries, 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, Check pre acute consistent, Checklist when changing or adding a variable or tmp project, Chronic Health Facility, Comfort Care, Creating a new project article, File:DPST GGH.pdf, Template:DPST SOP, Template:DPST form, Data Integrity Checks, Data definition for factor candidates for the Overstay2 project, Decubitus Ulcer Study, Deer Lodge (DLC), DeviceUse Study, File:Discharge Planning Screening Tool.pdf, Dropdown-like user experience for tmp projects, ER Wait, Early ID study, Entity–attribute–value model of the L Tmp V2 table, EuroSCORE II, EuroScore, File:Form Individual Site Bed example .pdf, File:Form Site Bed Data Summary.pdf, Function GenerUpdate tmp entry, Function TmpChecker, File:GRA DPST SOP.pdf, H1N1, IABP project, ICUotherService, IICU consult, Influenza tracking, Influenza treated, Intended1stSrvc, L TmpV2 multi-entry clean-up, L TmpV2 table, LAU LTC consult, LAU OT/PT consults, LAU Public Trustee, LAU collection readmission data, Legacy Processing Instructions Bed census.mdb, List of Factor affecting data quality, List of diagnoses affecting Overstay Project, List of diagnoses affecting Overstay Project (pre-ICD10), Medical Incompetency tracking, Moves for Medicine, Template:OSDD, Overstay Predictor Diagnosis Code Used, Overstay Predictor Project, Overstay Predictor Project Algorithm, Overstay Predictor Project Collection Instructions, Overstay Project Start Stop dates, Overstay roles and responsibilities, Overstay2 Overview, Overstay2 Screening Reports, Overstay2 colour, Template:Overstay2 data collector timeline, Overstay2 data processing and reporting in CFE, Overstay2 issues remaining, Overstay2 module, Overstay2 processes on the units to reduce discharge delay, Overstay2 scoring model for Grace Hospital, Overstay2 scoring model for HSC, Overstay2 scoring model for St. Boniface, Overstay2 scoring models, Overstay2 timeline, Parked in ER tmp entry, Patient Viewer Tab Tmp, Peer Audit, Peer Audit Partners, Personal Care Home, Pre-2017-07-30 Overstay Predictor Project Collection Instructions, Programmer-Peer Audit output problem table, Template:Project, Project ABO TEE, Project AHC, Project AHC (LAU), Project Borrow arrive, [[Project Consults data... further results]]
Firmness:	hard check
Timing:
App:	CCMDB.mdb
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

"CCMDB.mdb" is not in the list (SAP, not entered, Centralized data front end.accdb, DSM Labs Consistency check.accdb, CCMDB.accdb, TISS28.accdb) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "Project Consults data... further results" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process.

• Categories:  

• form:

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