STB Med Ward changes

Starting October 2009 STB is making changes to medicine wards beds. Also see: Site and Location

• STB_B5 - location label changed to STB_E6.
  • Change date: Oct 14.09 @ 0001 hrs (all patient's admitted or transferred into to STB_B5 starting October 14.09 @ 0001 hrs onward will have location, move or var 1 or 2 changed to STB_E6).
    • (stop at serial 6310)
    • (stop at serial 4597-Deb's PDA every 86-100)
      • Once Gayle has sent in all patients that were admitted to B5 prior to Oct 14th, then STB_B5 in S_Location table will be removed.

• STB_E6-change date: Oct 14.09 @ 0001 hrs.
  • (start new location at serial 6311)
  • (start at serial 4598 -Deb's every 86-100)

• STB_B4 -Location label will be changed to STB_5B.
  • Change Date: Nov 17.09 @0001 hrs (all patient's admitted or transferred into to STB B4 starting November 17.09 @0001 hrs onward will have location, move or var 1 or 2 coded as STB_5B).
    • stop at serial 1903)

• STB_5B - Change date: Nov 17.09 @ 0001 hrs
  • (start new location at serial 1904)

Program changes required

• CCMDB.mdb
  • S_Var options (variable 1 & 2)
  • S_Tmp_moves_required
  • S_Locations

• HanDBase
  • S_Var1Opts
  • S_Var2Opts
  • S_Locations
  • S_Tmp.pdb (moves)

Julie's SAS programs changed as follows for Location, Moves, Variable 1 & 2

• B5 + E6 = E6
• B4 + 5B = 5B

• • Implications -
• Option 1 retain label for Var 1 & 2 (ward label) and Julie change report output label.
• Option 2 change ward label in S tables for HanDBase & Access, programmer write code to remap all Var 1 & 2 codes in MEDTMX, Julie rewrite SAS codes.

• the "move" data in tmpv2 is also affected.
• MOVE data in TmpV2 as of October 19.09:
  • no moves to E6
  • B5-total number - 2196 moves recorded as of Oct 19.09
  • B4- total number - 401 moves recorded as of Oct 19.09

• Var 1 - total number of codes with B4 in field:
  • 59
• Var 1 - total number of codes with B5 in field:
  • 520
• Var 1 - total number of codes with E6 in field:
  • 8 (Pagasa to recode to EE6)
• Var 2 - total number of codes with B4 in field:
  • 915
• Var 2 - total number of codes with B5 in field:
  • 115

Var 2 - total number of codes with E6 in field:

• • 66 (Pagasa to recode to EE6)

Template:Stub