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
 
(31 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.  (no moves to E6 to date though, B5 haven't checked).  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)