Query check_tmp_AHC

Data Integrity Checks
Summary:	For patients with Previous Location ER at same site there should be a Boarding Loc ER.
Related:	Project AHC, Site, SentDtTm, Admit DtTm, Dispo DtTm
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_tmp_AHC
Uses L Problem table:	not relevant for this app
Status:	needs review
Implementation Date:	not entered
Backlogged:	No

• Cargo

• SMW

• Categories:  

• form:

Cross-checks for Project AHC.

Consistency Checks

for each matching allied health discipline

• at all times
  • must have an entry for each allied health discipline
  • if there is a date, it must be within the admission
    • nz(date, now()) + nz(time, .9999) must be after admission
    • nz(date, date()) + nz(time, 0) must be before nz(dispo_dttm, now)
  • not yet done - if item "not consulted" there must not be a date or time, and there must not be an AH_C_<the allied health team> entry for consult received

• at complete time
  • if there is a time there has to be a date
  • if item in ("referral received", "Late consult received") then it must have the checkbox checked ("no dttm") or a date
  • item must not be "not entered"

I implemented 'item must not be "not entered" and 40 records in the data I had at the time a "not entered" in complete data. Did I misunderstand the instructions? Or are these correct instructions and should be implemented as that?

• SMW

• Cargo

• Categories

JALT if there is referral sent there must be a referral received entry and a consult dealt with entry Lisa Kaita 11:31, 7 August 2025 (CDT) pt could die in between? consult could go missing? In a way those would be really the ones we would want to know about, no? I suppose we could make it a soft check... Ttenbergen 16:26, 19 August 2025 (CDT) this almost sounds like the opposite of how I would have understood the current instructions. I would have thought those to mean to only enter "consult received" if there was no good data for consult sent. How do we actually want to use this? late answer: how did Julie analyze this? at the time all fields were mandatory, unless there was no consult, current status, collect consult sent and if no data found for this then use consult received. Lisa Kaita 12:59, 13 January 2026 (CST) I don't know, flagging for Julie and putting this on the JALT agenda; collection is still going, so we may still want to implement this. Ttenbergen 14:58, 13 January 2026 (CST)

• SMW

• Cargo

• Categories

Log

• 2025-07-20 - preliminary data review and initial cross check definitions
• 2025-07-02 - collection started