CCMDB Wiki

Query check Project Consults data: Difference between revisions

← Older edit
No edit summary
m Text replacement - "[[Category: " to "[[Category:"
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{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_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_related_concepts = Admit date and time; Dispo_DtTm; Project Consults data
Line 6: Line 6:
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding =  query ''check_Project_Consults_data''
| DIC_coding =  query ''check_Project_Consults_data''
| DIC_status =
| DIC_status = implemented
| DIC_implementation_date = 2025-03
| DIC_implementation_date = 2025-03-06
}}
}}


Line 13: Line 13:


Check:
Check:
* there is at least one entry for every [[LAU Collection Project]] record
* ([[L_TmpV2 table]] date_var, time_var) must not be null
* "item" is not "not entered"
* ([[L_TmpV2 table]] date_var + time_var) must be before [[Dispo DtTm field]]
* ([[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]]
* ([[L TmpV2 table]] date_var + time_var) must be after [[Admit date and time]]
{{DL |
* "item" is not "not entered"
Is that last one reasonable? I guess it depends on how we want to collect a status that was set before admission to this unit. See question in [[ACP_Status_Collection_for_LAU#Data_Entry_Instructions]].
* there is at least one entry for every [[LAU Collection Project]] record (Project: Consults)
* as long as it is equal to or greater than the admit Dttm, just not prior to [[User:Lkaita|Lisa Kaita]] 08:33, 6 March 2025 (CST)
* only check on [[RecordStatus]]="complete" since a "not entered" record is added automatically for each pt
}}


== Log ==
== Log ==
* 2025-03-05 - cross check defined
* [[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 ==
{{Related Articles}}
{{Related Articles}}


[[Category: LAU Collection Project]]
[[Category:LAU Collection Project]]
[[Category: ACP]]
[[Category:ACP]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_Project_Consults_data"