Query check LAU collection readmission data: Difference between revisions

Latest revision as of 13:35, 9 March 2025

Data Integrity Checks
Summary:	dates must make sense
Related:	Admit date and time, Dispo_DtTm, LAU collection readmission data
Firmness:	hard check
Timing:	complete
App:	CCMDB.accdb
Coding:	query check_LAU_collection_readmission_data
Uses L Problem table:	not relevant for this app
Status:	implemented
Implementation Date:	implemented
Backlogged:	true

This check is or a temporary entry collected for the LAU Collection Project.

Check:

check these only when RecordStatus = complete
Project = "LAU Readm"
if a readmission, (L_TmpV2 table date_var, time_var) must not be null
for item = "has previous", (L_TmpV2 table date_var + time_var) must be before the Admit date and time
for item = "has later", (L_TmpV2 table date_var + time_var) must be after Dispo DtTm field
don't need to limit this to only LAU collection records since no other records should have this; if a record has the entry it should meet these conditions.
if item indicates no admission then date_var and time_var must be null
there must not be a line with "later not entered"/"previous not entered"
there must be a line with "previous" and a line with "later" for each record in LAU Collection Project

@@ Line 14: / Line 14: @@
 Check:
 * check these only when RecordStatus = complete
+* Project = "LAU Readm"
 * if a readmission, ([[L_TmpV2 table]] date_var, time_var) must not be null
 * for item = "has previous", ([[L_TmpV2 table]] date_var + time_var) must be before the [[Admit date and time]]