Query check LAU collection readmission data: Difference between revisions
Ttenbergen (talk | contribs) Created page with "{{Data Integrity Check | DIC_summary = dates must make sense | DIC_related_concepts = Admit date and time; Dispo_DtTm; | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''LAU_collection_readmission_data'' | DIC_status = | DIC_implementation_date = 2025-03 }} This check is or a temporary entry collected for the LAU Collection Project. Check: * for "" entries, (L_TmpV2 table date_var + time_var) must be before t..." |
Ttenbergen (talk | contribs) No edit summary |
||
| Line 13: | Line 13: | ||
Check: | Check: | ||
* for "" | * for item = "has previous", ([[L_TmpV2 table]] date_var + time_var) must be before the [[Admit date and time]] | ||
* for "" | * 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. | |||
== Log == | == Log == | ||