STB Med Ward changes: Difference between revisions

Latest revision as of 15:06, 2020 April 1

Starting October 2009 STB is making changes to medicine wards beds. See STB_B5#Historical_Information and STB_E6_B#Historical_Information for details as to what changed.

CCMDB.accdb
- 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

- 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:

@@ Line 1: / Line 1: @@
-Starting October 2009 STB is making changes to medicine wards beds. Also see: [[Site and Location]]
+Starting October 2009 STB is making changes to medicine wards beds. See [[STB_B5#Historical_Information]] and [[STB_E6_B#Historical_Information]] for details as to what changed.
-*'''STB_B5''' - location label changed to '''STB_E6'''.
-**Change date: Oct 14.09 @ 0001 hrs (all patient's admitted to STB_B5 starting October 14.09 @ 0001 hrs 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)
-*'''STB_E6'''- CTU 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
-**B4 location kept to serial 1903
-**started new location ('''5B''') at serial 1904
 ==Program changes required==
-*[[CCMDB.mdb]]
+*[[CCMDB.accdb]]
 **S_Var options (variable 1 & 2)
 **S_Tmp_moves_required
 **S_Locations
-*[[HanDBase]]
+Julie's SAS programs changed as follows for Location, Moves, Variable 1 & 2
-**S_Var1Opts
+*B5 + E6 = E6
-**S_Var2Opts
+*B4 + 5B = 5B
-**S_Locations
-**S_Tmp.pdb (moves)
-*Julie's SAS programs
-*Location, Moves, Variable 1 & 2
-**B5 + E6 = E6
-**B4 + 5B=5B
 **Implications -
@@ Line 64: / Line 35: @@
-{{stub}}
-[[Category: Trish Pending]]
+[[Category: Legacy Data Collection]]