Query check dispo lower acuity than location

From CCMDB Wiki
Revision as of 15:24, 2019 September 18 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: check for patients going to lower level of care (based on S dispo table.acuity_level) but without Transfer_Ready_DtTm; Check will launch an error but allow no date, ie it's just a reminder, see Transfer_Ready_DtTm#Hierarchy of levels of care.
Related: Transfer Ready DtTm field, Dispo field
Firmness: soft check
Timing: complete
App: CCMDB.mdb
Coding: query check_dispo_lower_acuity_than_location and function Transfer_Ready_DtTm_vs_Location_vs_Dispo
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2016-06-06
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. 
  • Categories: 
  • form:


Related articles

Related articles: