ACP Status Collection in ICU: Difference between revisions

Line 68: Line 68:


== {{CCMDB Data Integrity Checks}} ==
== {{CCMDB Data Integrity Checks}} ==
=== Checks at sending time ===
Error triggers if a patient exists who
* pt is ICU pt
* RecordStatus is complete
* one of the following is true
** there is not at least one entry in tmp with project = "ACP Source"
** project = "ACP Source" or "ACP Status" and item = "enter"
** no date or no integer
then won't be able to send anyone.
In normal operation such a patient should not be possible to set to "complete", this is a double-check.
Implemented as query ''s_tmp_ACP'' in [[CCMDB.mdb_Change_Log_2016#2016-May-04]]
=== pairs of records ===
If a record does not have a paired partner with same tmp integer there will be an error. Query ''s_tmp_ACP_unpaired''.
=== Check at Complete-time ===
Can't check patient complete if the Item for an entry for this project is "enter" or "".
Implemented in VBA in [[CCMDB.mdb_Change_Log_2016#2016-May-04]]
==== Incomplete patients ====
==== Incomplete patients ====
* ACP entries must be paired
* ACP entries must be paired