Requested CCMDB changes for the next version: Difference between revisions

m Integrity rule for [[Moves | Move]] dates in TMP file: Confirmed that there is a working check that move times are during admission.
Line 13: Line 13:




=== Integrity rule for [[Moves | Move]] dates in TMP file===


*if coming from your own site ER department, the first move TO "item" '''MUST always be''' to same as Hospital Site_Location.
**'''EXCEPTIONS''':
***HSC first move can be to H7N (contingency beds).
***VIC first move can be- S2, N4, N4F (code purple contingency beds)
***GRA first move can be - S2, E4 (contingency beds)
***STB first move can be - A6S
*For patients who DO NOT come directly from site's '''OWN emergency department''' it would be good to have a boolean of YES or NO for:
**parked in ER? if YES then move required
**from contingency bed (exceptions) prior to actual ward admit, if YES, then moved required.
*otherwise, NO move required if from: ICU own site or other sites, OR's, RR's, HOME (ZZ), ambulatory care, XE, YE, ward from other sites, wards from own site.


===[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Notes_field#Apache_secondary_upper_and_lower_limits Apache secondary upper and lower limit verifying abnormal Apache values by collectors using Access]===
===[http://ltc.umanitoba.ca/wikis/ccmdb/index.php/Notes_field#Apache_secondary_upper_and_lower_limits Apache secondary upper and lower limit verifying abnormal Apache values by collectors using Access]===