Query check tmp ER Boarding Loc should exist if from ER

From CCMDB Wiki
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; function from_ER(); query check_pt_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



  • how about the cases who did not wait at all at ER but immediately went to the Ward or ICU ? - do they still need the first boarding loc be ER? Some DCs entered at least 1 minute difference between first boarding loc ER and second boarding loc - if this is being done, what does the LOS per Location mean when there is 1 minute or 5 minutes or 30 minutes at ER. Are the ICU or Med service really taking care of them at ER in such short stay? --JMojica 14:16, 2022 March 21 (CDT)
    • Good questions. I think this needs to go to Task to get input from Collectors and Allan. Ttenbergen 11:52, 2022 March 24 (CDT)
    • This was discussed at TASK and the decision was create a soft check for collectors to check this, as we know that stays in ER less than 30 minutes are often errors, can this be removed? Lisa Kaita 08:32, 2022 April 28 (CDT)
      • The soft check would flag it for review, but Julie's question was what is the correct thing to actually enter in that scenario. The check can't address that. Ttenbergen 10:58, 2022 May 4 (CDT)
  • SMW

  • Cargo

  • Categories


  • 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: