Query s tmp apostrophe in comment

From CCMDB Wiki
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, 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 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 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
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. .