View source for Query check Project OT PT Consults

{{DISPLAYTITLE:Query check_Project_OT_PT_Consults}}{{Data Integrity Check
| DIC_summary = every [[LAU OT/PT consults]] 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_OT_PT_Consults''
| 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: OTPT Consults)
* only check on [[RecordStatus]]="complete" since a "not entered" record is added automatically for each pt

== Log ==
* 2025-03-...
* 2025-03-13 - cross check defined

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

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