Query check pt from ER

From CCMDB Wiki
Revision as of 15:40, 2022 April 21 by Ttenbergen (talk | contribs)
Jump to navigation Jump to search
Data Integrity Checks
Summary: part of validating Accept DtTm
Related: Accept DtTm, Previous Location
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: function Validate_Accept_DtTm(); (function from_ER(); query check_pt_from_ER but those are also used in new boarding loc based validation)
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: date change was rolled out / first applied
Backlogged: true
  • Cargo


  • SMW


  • Categories: 
  • form:

This query in CCMDB.accdb identifies patients from ER. The name would lead you to think it's a cross check query, but it isn't.

Query is used by by function from_ER() which is in turn used by function Validate_Accept_DtTm() which validates the Accept DtTm.

Related articles

Related articles: