CCMDB Wiki

Query check CCI vs LOS count days component: Difference between revisions

← Older edit
mNo edit summary
mNo edit summary
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{Data Integrity Check
{{Data Integrity Check
|DIC_summary=Confirm that [[CCI Collection Mode]] [[CCI collect count days]] items don't have a count > [[LOS]].
|DIC_summary=Confirm that [[CCI Collection Mode]] or [[CCI Component]] [[CCI collect count days]] items don't have a count > [[LOS]].
|DIC_related_concepts=LOS; Dispo DtTm; Service tmp entry; ECMO, VA; ECMO, VV
|DIC_related_concepts=LOS; Dispo DtTm; Service tmp entry;  
|DIC_firmness=hard check
|DIC_firmness=hard check
|DIC_timing=incomplete
|DIC_timing=complete
|DIC_coding=query ''check_CCI_vs_LOS_count_days''
|DIC_coding=query ''check_CCI_vs_LOS_count_days_component''
|DIC_status=ready to implement
|DIC_implementation_date=2022-02-10
|DIC_status=implemented
|DIC_app=CCMDB.accdb
|DIC_app=CCMDB.accdb
|DIC_backlogged=No
|DIC_backlogged=No
}}
}}
As of 2022-02-10 there currently aren't any component entries with [[CCI collect count days]] but I only realized it after I built the query.


== Log ==
* 2022-05-11 - changed from using [[Function LOS()|Function LOS()]] to using [[Function LOS int()|Function LOS int()]]
* 2022-02-10 - implemented


== Related articles ==
== Related articles ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Query_check_CCI_vs_LOS_count_days_component"