Query check tmp AHC: Difference between revisions

Revision as of 17:30, 21 November 2025

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

Cross-checks for Project AHC.

	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)

	others?

Related articles:
S tmp table (← links) Requested CCMDB changes for the next version (← links) Dispo DtTm field (← links) Portal related pages with questions (← links) Data Integrity Checks (← links) Query s tmp apostrophe in comment (← links) Admit DtTm (← links) Project AHC (← links)

@@ Line 15: / Line 15: @@
 * must have an entry to send
 * dttms within admission
-* dttms must be chronological for groupings linked by int_var
-* if there is an option entry the consult can not be "never addressed"
 {{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)