CCMDB Wiki

Query check ACP Status Collection: Difference between revisions

← Older editNewer edit →
No edit summary
No edit summary
Line 6: Line 6:
| DIC_app = CCMDB.accdb
| DIC_app = CCMDB.accdb
| DIC_coding =  query ''check_ACP_Status_Collection_for_LAU''
| DIC_coding =  query ''check_ACP_Status_Collection_for_LAU''
| DIC_status =
| DIC_status = implemented
| DIC_implementation_date = 2025-03
| DIC_implementation_date = 2025-03-06
}}
}}


Line 13: Line 13:


Check:
Check:
* Project IN ("ACP first", "ACP last")
* there is at least one entry for every [[LAU Collection Project]] record
* there is at least one entry for every [[LAU Collection Project]] record
* "item" is not "not entered"
* "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 |
* only check on [[Record_Status]]="complete" since a "not entered" record is added automatically for each pt
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]].
 
* as long as equal to or before admit dttm not prior to [[User:Lkaita|Lisa Kaita]] 08:34, 6 March 2025 (CST)
** you mean "equal to or after", correct? [[User:Ttenbergen|Ttenbergen]] 13:14, 6 March 2025 (CST)}}
**yes, sorry
== Log ==
== Log ==
* 2025-03-06 - implemented
* 2025-03-05 - cross check defined
* 2025-03-05 - cross check defined


Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_ACP_Status_Collection"