Requested CCMDB changes for the next version: Difference between revisions

TOstryzniuk (talk | contribs)
Line 5: Line 5:
Clean up batch file to get rid of the old data where names were just ccmdb.mdb [[User:Ttenbergen|Ttenbergen]] 13:54, 9 February 2011 (CST)
Clean up batch file to get rid of the old data where names were just ccmdb.mdb [[User:Ttenbergen|Ttenbergen]] 13:54, 9 February 2011 (CST)


=== Move dates in TMP file===
=== Integrity rule for Move dates in TMP file===
*Move date/time in TMP file should not be BEFORE admission date/time or AFTER discharge date/time.
*Move date/time in TMP file should NOT be BEFORE admission date/time or AFTER discharge date/time.
*if coming from the ER department first move should be to same ward location.
*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 bed).
**'''EXCEPTIONS''':  
**VIC except for overflows - {{Discussion}}? which units are they Shirley and Hazel?
***HSC first move can be to H7N (contingency beds).
**GRACE except for overflow - {{Discussion}}? Steph & Sheila, which ones are they?
***VIC first move can be- S2, N4, N4F (code purple contingency beds)
***GRA first move can be - S2, W4, E4 (contingency beds  {{Discussion}} Steph or Sheila?
***STB first move can be - A6S
 
*NO move required if a move to is: ICU, OR, HOME (ZZ),


=== protect serial numbers ===
=== protect serial numbers ===