STB Med Ward changes: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
TOstryzniuk (talk | contribs)
mNo edit summary
No edit summary
 
(32 intermediate revisions by 2 users not shown)
Line 1: Line 1:
In October 2009 STB will be making changes to medicine wards beds.
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.
*B5 will move to E5 - Location label will be changed to STB_E6.  The change starts at serial number 6313 onward. The last patient with location STB_B5 is serial 6312.
*B4 will move to B5 sometime mid to late Nov 2009.


==Program changes required==
*[[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
*B5 + E6 = E6
*B4 + 5B = 5B


**Implications -  
**Implications -  
*Option 1 retain label for Var 1 & 2 (ward label) and Julie change report output label.
*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.  
*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.  Not sure this is worth recoding.  Will email my suggestion before posting more here.[[User:TOstryzniuk|TOstryzniuk]] 19:55, 19 October 2009 (CDT)


{{stub}}
*the "move" data in tmpv2 is also affected.
[[Category: Trish Pending]]
*'''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)
 
 
 
[[Category: Legacy Data Collection]]

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.

Program changes required

  • 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

  • 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)