Query s tmp apostrophe in comment

From CCMDB Wiki
Revision as of 13:59, 27 November 2025 by Ttenbergen (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump 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: Check Accept Loc Park, Data Integrity Checks, Query Check VADT too close to first boarding loc, Query Check from ED and prev location same site, 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 AHC, 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 Overstay2, 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 AHC consistent, 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 MR, 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, Service tmp post-send consistency checks, Query s tmp project item consistent
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. .

Log

  • 2025-11-27 was raised as a problem because it made it impossible to enter a place with an apostrophe in the name for Project NonTradLoc. Email to Julie to find out if still needed. Ttenbergen 13:59, 27 November 2025 (CST)
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_s_tmp_apostrophe_in_comment&oldid=168063"