Edit Data Integrity Check: Query check LAU collection readmission data

Summary (what is the check, one-liner):
links to related pages:	Admit date and timeDispo DtTm (Dispo_DtTm)LAU collection readmission data ×Admit date and time ×Dispo DtTm (Dispo_DtTm) ×LAU collection readmission data
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_LAU_collection_readmission_data''
Implementation date:
Implementation Status:	needs reviewready to implementimplementednot enterednot feasibledeclinedretired
L_Problem (are false positive special cases addressed in table L_Problems - applicable only in CFE):	None/unknown  yes  no
App:	CCMDB.accdbCentralized data front end.accdbTISS28.accdbSAPDSM Labs Consistency check.accdb
Backlogged (is this query cleaned up to date or backlogged? Applicable only in CFE):

Free text:

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]] == Log == * 2025-03-09 - updated check to account for "no readmission" items * 2025-03-06 - implemented * 2025-03-05 - cross check defined == Related Articles == {{Related Articles}} [[Category: LAU Collection Project]]

Save page Show preview Show changes Cancel