STB Med Ward changes: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m →‎STB_B5 to STB_E6: integrating location dat
m →‎STB_B4 to STB_5B: integrated into location article.
Line 1: Line 1:
Starting October 2009 STB is making changes to medicine wards beds. Also see: [[Site and Location table]]
Starting October 2009 STB is making changes to medicine wards beds. Also see: [[Site and Location table]]
== STB_B4 to STB_5B ==
*'''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==
==Program changes required==
*[[CCMDB.mdb]]
*[[CCMDB.mdb]]

Revision as of 10:02, 2015 November 19

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

Program changes required

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

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)