Query check tmp ER Boarding Loc should exist if from ER

From CCMDB Wiki
Jump to navigation Jump to search
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)
        • Discuss at JALT: Lisa explained that for SICU there can be the same time for start of ER, surgery and SICU; collectors then pull this apart to actual entries. Julie will provide info on amount of problem in complete data. Lisa to ask STB ICU what the story is with these. Ttenbergen 11:59, 2022 November 30 (CST)
  • 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: