CCMDB Wiki

Query check ACP Status Collection: Difference between revisions

Created page with "{{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; | DIC_firmness = hard check | DIC_timing = complete | DIC_app = CCMDB.accdb | DIC_coding = query ''check_ACP_Status_Collection_for_LAU'' | DIC_status = | DIC_implementation_date = 2025-03 }} This check is or a temporary entry collected for the LAU Collection Project. Check: * there is..."
 
No edit summary
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Data Integrity Check
{{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;  
| DIC_related_concepts = Admit date and time; Dispo_DtTm; ACP Status Collection for LAU
| DIC_firmness = hard check
| DIC_firmness = hard check
| DIC_timing = complete
| DIC_timing = complete
| 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"
* ([[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 timed]]
* ([[L TmpV2 table]] date_var + time_var) must be after [[Admit date and time]]
{{DL |
* only check on [[RecordStatus]] ="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]].
 
}}
''' the collection project is done, but if we re-start it we should add the following:
* add "date of first should be before last"
'''


== Log ==
== Log ==
* 2025-03-05 - cross check defined
* 2025-03-06 - implemented
* 2025-03-05 - [[cross check]] defined


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


 
[[Category:LAU Collection Project]]
[[Category: CCI Px check‎]]
[[Category:ACP]]
[[Category: LAU Collection Project]]
[[Category: ACP]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_ACP_Status_Collection"