Query check tmp BedHeld

From CCMDB Wiki
Jump to navigation Jump to search
Data Integrity Checks
Summary: Sanity check for BedHeldEnd DtTm
Related: BedHeldEnd DtTm, Dispo DtTm
Firmness: hard check
Timing: complete
App: CCMDB.accdb
Coding: query check_tmp_BedHeld
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2023-05-02
Backlogged: No
  • Cargo

  • SMW

  • Categories: 
  • form:
  • dttm entry is always required
  • for item in ("AMA (AWOL)", "Procedure"), BedHeldEnd DtTm must always be after Dispo DtTm
  • if BedHeldEnd DtTm = Dispo DtTm and Dispo = "AMA (left against medical advice)", should be "AMA protocol" and vice versa
  • for item in ("AMA (AWOL)", "AMA (Protocol)"), Dispo needs to be "AMA" and vice versa


  • 2023-07-06 - the query is being called out of tmp checker, so it must be running now, considering question dealt with
  • 2023-05-02 - query defined and written but waiting to find out if this can be before complete or only after (emailed)
  • 2023-01-11 - Discussed at JALT and decided to not have a cross check for "procedure" against "Dispo"
  • 2023-01-10 - Julie identified needed checks

Related articles

Related articles: