Query s tmp apostrophe in comment

From CCMDB Wiki
Revision as of 22:10, 2018 October 26 by Ttenbergen (talk | contribs)
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: [[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.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 (CCMDB.accdb, Centralized data front end.accdb, TISS28.accdb, SAP, DSM Labs Consistency check.accdb, not entered) of allowed values for the "DICApp" property. Property "DICRelatedConcepts" (as page type) with input value "ACCU borrow" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "ACP Status collection in ICU" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Accept Loc Park" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "AcceptDateSource" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Alias ID collection" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Allied Health Consults" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Arrest Witnessing" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Bed Census Data Processing Instructions" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Bed census.mdb" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "File:BedCensusAnnouncement Letter May 2012.pdf" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "BedHeldEnd DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Boarding Loc" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "CCU Service Tracking" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "CRRT Project" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Cardiac Arrest Cooling Protocol" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Catheter09" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Catheter09 Wednesday, November 25, 2009" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Catheter09 Wednesday, October 28.09" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Check Accept Loc Park" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Comfort Care" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Creating a new project article" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Decubitus Ulcer Study" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "DeviceUse Study" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Early ID study" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "EuroSCORE II" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "EuroScore" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "File:Form Individual Site Bed example .pdf" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "File:Form Site Bed Data Summary.pdf" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Function TmpChecker" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "H1N1" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "IABP project" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "ICUotherService" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "IICU consult" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Influenza tracking" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Influenza treated" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "L TmpV2 table" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Legacy Processing Instructions Bed census.mdb" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "List of Factor affecting data quality" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Medical Incompetency tracking" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Moves for Medicine" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Overstay Predictor Project" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Parked in ER tmp entry" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Peer Audit" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Peer Audit Partners" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Programmer-Peer Audit output problem table" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Template:Project" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Project ABO TEE" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Project Borrow arrive" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Project Discharge Documentation" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Project Legacy Co-managed" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Project Legacy HSC CCU Loc" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Projects" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "QA Infection" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "QA Infection CLI" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "QA Infection VAP" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "QA Septic Shock" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query cardiac arrest throughout admission" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check CCI CRRT vs Tmp" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check overstay no colour" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check overstay not entered" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check overstay pt from our med" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp 2 BL TR S same tm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp BedHeld" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp Boarding Loc Service first same" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp ER Boarding Loc should exist if from ER" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp Service and Boarding Loc during admission timeframe" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp Transfer Ready not before Boarding Loc" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp generate allowed" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp service and program consistency" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query check tmp service or location duplicate" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp ABO TEE checks" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Boarding Loc ER delay reasonable" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Boarding Loc date item" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Boarding Loc no borrow but entry" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Borrow duplicates" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Borrow no borrow on own unit" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp Borrow sensible DtTm vs no borrow" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp EuroSCORE II checks" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp IICU consult DtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp IICU consult dispo to IICU but no tmp" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp QASeptic Dx no tmp ICD10" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp QASeptic tmp no dx" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp apostrophe in comment" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp check Boarding Loc and TransferReadyDtTm pairs" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp check combined BL and TRDtTm nonsequential" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp check combined Boarding Loc and TransferReadyDtTm" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Query s tmp project item consistent" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Re-import of TmpV2 data from Julie's Export 2014-09-08" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Re-import of TmpV2 data from Julie's Export 2014-09-18" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Re-import of TmpV2 data from Julie's Export 2014-09-22" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Re-import of TmpV2 data from Julie's Export 2014-09-25" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Septic Shock Order Set" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Service tmp entry" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "SmartPump Audit" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "TISS form audit" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "TMP dates imported backwards" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Temporary study guidelines" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Transfer Ready DtTm tmp entry" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "Transfusion Audit" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process., Property "DICRelatedConcepts" (as page type) with input value "VAP - Ventilator Associated Pneumonia" 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. .