Edit Data Integrity Check: Query check tmp AHC

Are you logged on?

You do not have permission to edit this page, for the following reason:

The action you have requested is limited to users in the group: CCMDB_legit.

Summary (what is the check, one-liner):
links to related pages:
Firmness (is this a warning only (soft check) or will it stop sending (hard check) - applicable only in CCMDB.accdb app):	None/unknown hard check soft check
Timing (does this query run for all records or only complete ones):	None/unknown complete always
Name of the function or query this is implemented as:	query ''check_tmp_AHC''
Implementation date:
Implementation Status:
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown Yes No
App:
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

{{DISPLAYTITLE:Query check_tmp_AHC}} 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 {{DL| ** 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? }} {{DL| * if there is referral sent there must be a referral received entry and a consult dealt with entry[[User:Lkaita|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... [[User:Ttenbergen|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? }} == Log == * 2025-07-20 - preliminary data review and initial cross check definitions * 2025-07-02 - collection started == Related articles == {{Related Articles}} [[Category:Tmp check]]

Explain your edit, if you think it needs explanation (e.g. "as discussed with ...", or "content moved to ...", or "duplicate content, see ..."):

This is a minor edit

Watch this page

Cancel