Query check tmp ER Boarding Loc should exist if from ER: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
Line 2: Line 2:
|DIC_summary=For patients with [[Previous Location]] ER at same site there should be a [[Boarding Loc]] ER.  
|DIC_summary=For patients with [[Previous Location]] ER at same site there should be a [[Boarding Loc]] ER.  
|DIC_related_concepts=Boarding Loc; Previous Location
|DIC_related_concepts=Boarding Loc; Previous Location
|DIC_firmness=hard check
|DIC_firmness=soft check
|DIC_coding=query ''check_tmp_ER_Boarding_Loc_should_exist_if_from_ER''
|DIC_coding=query ''check_tmp_ER_Boarding_Loc_should_exist_if_from_ER''
|DIC_implementation_date=2021-01-15
|DIC_implementation_date=2021-01-15
Line 11: Line 11:


The converse is not true, since a patient could board in ER after admission, e.g. GRA ICU uses their ER
The converse is not true, since a patient could board in ER after admission, e.g. GRA ICU uses their ER
{{ TT |
* change this to a soft check. Pt can come from ER but be moved at same time as service accepts so there would not be an ER Boarding Loc
}}


== Log ==
== Log ==
* 2021-09-07 turned from hard check to soft check since this is possible after a collection rule change some time ago
* 2021-01-15 - check implemented
* 2021-01-15 - check implemented


Revision as of 17:27, 2021 September 7

Data Integrity Checks
Summary: For patients with Previous Location ER at same site there should be a Boarding Loc ER.
Related: Boarding Loc, Previous Location
Firmness: soft check
Timing: always
App: CCMDB.accdb
Coding: query check_tmp_ER_Boarding_Loc_should_exist_if_from_ER
Uses L Problem table: not relevant for this app
Status: implemented
Implementation Date: 2021-01-15
Backlogged: No
  • Cargo


  • SMW


  • Categories: 
  • form:

The converse is not true, since a patient could board in ER after admission, e.g. GRA ICU uses their ER

Log

  • 2021-09-07 turned from hard check to soft check since this is possible after a collection rule change some time ago
  • 2021-01-15 - check implemented

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_tmp_ER_Boarding_Loc_should_exist_if_from_ER&oldid=151918"