View source for Query check Project Consults data

{{DISPLAYTITLE:query check_Project_Consults_data }}{{Data Integrity Check
| DIC_summary = every [[LAU Collection Project]] must have an entry, and the date must make sense
| DIC_related_concepts = Admit date and time; Dispo_DtTm; Project Consults data
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_app = CCMDB.accdb
| DIC_coding =  query ''check_Project_Consults_data''
| DIC_status = implemented
| DIC_implementation_date = 2025-03-06
}}

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

Check:
* ([[L_TmpV2 table]] date_var, time_var) must not be null
* ([[L_TmpV2 table]] date_var + time_var) must be before [[Dispo DtTm field]]
* ([[L TmpV2 table]] date_var + time_var) must be after [[Admit date and time]]
* "item" is not "not entered"
* there is at least one entry for every [[LAU Collection Project]] record (Project: Consults)
* only check on [[RecordStatus]]="complete" since a "not entered" record is added automatically for each pt

== Log ==
* [[CCMDB.accdb Change Log 2025#2025-03-14-1 | 2025-03-14-1]] - tweak to allow blank date and time when there is no consult
* [[CCMDB.accdb Change Log 2025#2025-03-06|2025-03-06]] - implemented
* 2025-03-05 - cross check defined

== Related Articles ==
{{Related Articles}}

[[Category: LAU Collection Project]]
[[Category: ACP]]