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 this one and 40 records in my test data have a "not entered" in complete data. Did I misunderstand the instructions?

• SMW

• Cargo

• Categories

if there is referral sent there must be a referral received entry and a consult dealt with entryLisa 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?

• SMW

• Cargo

• Categories

Log

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