CCMDB Wiki

CCMDB.mdb Change Log 2008: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
 
(77 intermediate revisions by 5 users not shown)
Line 1: Line 1:
There is another [[CCMDB.mdb_Change_Log_2009 | 2009 CCMDB Change Log]].  This one is so long it has been relegated to the Legacy file.
The '''CCMDB.mdb Change Log''' logs changes made to the [[CCMDB.mdb]], including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general.
The '''CCMDB.mdb Change Log''' logs changes made to the [[CCMDB.mdb]], including lock-downs when one person is making changes so that no one else makes changes at the same time. New entries should be made at the top to be immediately apparent. Discussions should be added at the level of individual changes if they correspond to a change, and at the end of the article if they relate to the change process in general.
When a change is tested and rolled out it is also documented here.
When a change is tested and rolled out it is also documented here.


== The Change Log ==
 
== The 2008 CCMDB Change Log ==
===December 31, 2008===
*763-40 '''VAD''' - Ventricular Assist Device insertion
*added to s_alldiagnosis to CCMDB & Handibase
*copy to Master
*rolled out to sites
* [[User:TOstryzniuk|TOstryzniuk]] 14:46, 31 December 2008 (CST)
 
===December 30, 2008===
*430-01 Pancreas Transplant - Rejection
*added to s_alldiagnosis to CCMDB & Handibase
*copy to Master
*rolled out to sites
*[[User:TOstryzniuk|TOstryzniuk]] 14:14, 30 December 2008 (CST)
 
==December 17, 2008==
*DX code rewording S_alldiagnosis for ACCESS and Handibase.
*code 848-13: Desensitization (ASA, Antibiotic, Plavix).  Was previously only antibiotic desensitization.
*CCMDB updated to Master
*Rolled out to sites.
[[User:TOstryzniuk|TOstryzniuk]] 18:28, 17 December 2008 (CST)
 
==December 5, 2008, 1800 hrs.==
*Tasks have all been completed and rolled out to sites.
*STB is a combined ICU unit know as STB_MICU or BM as of Jan 15.07
*TRISH - need to complete before Dec 5:
**update the '''s_tables''' in''' CCMDB''' &''' Handibase'''.
***'''s_location''' code of STB_SICU - removed.
***'''s_admit/discharge''' to code of BS - removed.
***'''s_var''' 5 - SV (sicu overflow in CICU - removed
***'''s-var 3''' - VS (cicu overflow in SICU - removed
 
*IN MASTER DATABASE for ICU & Medicine (retro to Jan 15.08)
**converted all STB Location from SICU, to MICU
**converted all admit/discharge from BS to BM
**converted all var 3 or 5 from VS or SV to VM or MV
**Laura emailed to check her PDA and change any serials with location of STB_SICU to STB_MICU before next send.
[[User:TOstryzniuk|TOstryzniuk]] 18:26, 5 December 2008 (CST)
 
=== November 4, 2008 ===
* adding values for the lab maximums. [[User:Ttenbergen|Ttenbergen]] 16:26, 4 November 2008 (CST)
* sent to Trish for testing [[User:Ttenbergen|Ttenbergen]] 16:51, 4 November 2008 (CST)
 
===October 29, 2008===
*s-alldiagnosis for CCMDB and Handibase.
'''*DX code updates/repairs/NEW:'''
**199-16 nosebleed added in brackets to be consistent with code label
**199-17 uncontrolled bleeding requires Transfus/OR  (NEW CODE)
**777-5 & 777-6 spelling fix (Dilatation)
**794-27 TIPS - Transjugular Intrahepatic Portosystemic Stent  (not a surgery, done in X-ray) (NEW CODE)
'''*Pathogen updates'''
**pathogen subcode 93 -Syphilis-Treponema Pallidium
**pathogen subcode 94-Lyme-Borrelia Burgdorferi
'''*changes made as per code guide, these are not new codes, just specific listings just like for the Hepatitis code.'''
*Menningoencephalitis codes: '''See ''neurological'' drop down DX list on your PDA'''
**77-65
**77-68
**77-74
**77-79
**77-92
**77-93
**77-95
 
***'''NOTE TO DATA COLLECTORS''': Syphilis code now added.  If '''neurosyphilis''' then use code 77-93 (as per Dr. Kumar).
*Copied to Master on Regional Server
*ROLLED OUT
[[User:TOstryzniuk|TOstryzniuk]] 19:29, 29 October 2008 (CDT)
 
===September 29, 2008===
'''APACHE Glasgow Coma Scale (GCS) - MOTOR drop down list'''
*In ACCESS drop down list for MOTOR - had seven items.  Should only be 6.  item 2 "when spoken to" removed, and the two number 4's have be renumbered. 
*Rolled out from MASTER today[[User:TOstryzniuk|TOstryzniuk]] 06:26, 29 September 2008 (CDT)
 
===September 17, 2008===
Modifiying the program to permit direct entry of data.
[[User:Ttenbergen|Ttenbergen]] 12:39, 17 September 2008 (CDT)
 
===August 6, 2008 18:05===
*Numbers allowed in name field FIXED.  Tested.
*rolled out Master today.
*log showed that all sites updated [[User:TOstryzniuk|TOstryzniuk]] 18:06, 6 August 2008 (CDT)
 
=== July 30 - update to master file only ===
=== July 30 - update to master file only ===
* Deleted the contents of the L_tmp_V2 table because they were causing send errors at HSC. Rolled out.[[User:Ttenbergen|Ttenbergen]] 09:34, 30 July 2008 (CDT)
* Deleted the contents of the L_tmp_V2 table because they were causing send errors at HSC.  
*Rolled out from "Master". [[User:Ttenbergen|Ttenbergen]] 09:34, 30 July 2008 (CDT)
Was this to HSC only?  Didn't seem to make it to other sites?
 
**tested after COPYING from MASTER.  Can still put numbers in NAME field and ACCESS doesn't complain.
**I put my copy in TRISH TEST.
[[User:TOstryzniuk|TOstryzniuk]] 18:08, 30 July 2008 (CDT)


=== July 28 2008 15:45 ===
=== July 28, 2008 15:45 ===
Added check that First name and Last Name are not entirely numerical. Note: it will only catch names that are '''all''' numbers, e.g. if someone accidentally put the PHIN in the name. A fair bit of coding would be necessary to track individual numbers in strings, and I did not implement it.   
Added check that First name and Last Name are not entirely numerical. Note: it will only catch names that are '''all''' numbers, e.g. if someone accidentally put the PHIN in the name. A fair bit of coding would be necessary to track individual numbers in strings, and I did not implement it.   


Copied to Test_Trish.[[User:Ttenbergen|Ttenbergen]] 15:43, 28 July 2008 (CDT)
Copied to Test_Trish.[[User:Ttenbergen|Ttenbergen]] 15:43, 28 July 2008 (CDT)


===July 25. 2008 12:10 ===
===July 25, 2008 12:10 ===
*'''Problem:'''  
*'''Problem:'''  
**1. lab item Voluven not showing up on peripheral PDA's after being synch'd.
**1. lab item Voluven not showing up on peripheral PDA's after being synch'd.
Line 28: Line 118:
**When PDA is synch'd Voluven is now visible on lab drop down list.
**When PDA is synch'd Voluven is now visible on lab drop down list.


**rolled out July 25.08 @ 17:15 hrs.
**rolled out from "MASTER" July 25.08 @ 17:15 hrs.
*[[User:TOstryzniuk|TOstryzniuk]] 16:34, 25 July 2008 (CDT)
*[[User:TOstryzniuk|TOstryzniuk]] 16:34, 25 July 2008 (CDT)


Line 36: Line 126:
*s_Handibase VIEW option for this table was also fixed.  The CC CON view was deleted.
*s_Handibase VIEW option for this table was also fixed.  The CC CON view was deleted.
*s_labs: Voluven added to ACCESS and Handibase lab table. (Lab item #142 in master database)
*s_labs: Voluven added to ACCESS and Handibase lab table. (Lab item #142 in master database)
**Copied to Master on twister and rolled out to all sites. [[User:TOstryzniuk|TOstryzniuk]], 24 July 2008 (CDT)
**Copied to Master on [[Regional Server]] and rolled out to all sites. [[User:TOstryzniuk|TOstryzniuk]], 24 July 2008 (CDT)


=== Jul 2, 2008 ===
=== Jul 2, 2008 ===
Line 116: Line 206:
Nov 10 @ 9:30  
Nov 10 @ 9:30  
Made changes to file sending so StB ICU (old Access) and  
Made changes to file sending so StB ICU (old Access) and  
all other sites can use the same ccmdb.mdb
all other sites can use the same [[CCMDB.accdb]]


Nov 14 @11:00
Nov 14 @11:00
Line 155: Line 245:
Trish added STB ambulatory care to admit from or discharge to.   
Trish added STB ambulatory care to admit from or discharge to.   
We excluded the option of BLANK in the ADMIT from table.
We excluded the option of BLANK in the ADMIT from table.
Copied to MASTER on twister
Copied to MASTER on [[Regional Server]]
Rolled out to all site.
Rolled out to all site.


Line 206: Line 296:
763-21 Thrombolytic infusion Pulmonary Embolus
763-21 Thrombolytic infusion Pulmonary Embolus


Corretion to s-all DX s spelling: Myeglobinemia
Correction to s-all DX s spelling: Myeglobinemia


NEW CODE- as per Dr. Roberts:
NEW CODE- as per Dr. Roberts:
763-38 Line insertion ONLY as primary reason for admission
763-38 Line insertion ONLY as [[Primary Admit Diagnosis]]


Tina working on FILTERS for MOVES for Med database
Tina working on FILTERS for MOVES for Med database
Line 277: Line 367:
Jan 25.08
Jan 25.08
ACCESS and Handibase table updates.
ACCESS and Handibase table updates.
1. s_tmp MOVE-updated to inlcude GRA S2 (orthopedics ward)
1. s_tmp MOVE - updated to inlcude GRA S2 (orthopedics ward)
2. s_ADMITDISCH -update to include St Amant center.  Code AW.
2. s_ADMITDISCH - update to include [[St.Amant]].  Code AW.


Rolled out
Rolled out
Line 293: Line 383:


Jan 31.08 1800 hrs
Jan 31.08 1800 hrs
ACCESS - s-admitdischarge missing St Amant center code AW.
ACCESS - s-admitdischarge missing [[St.Amant]] code AW.
Not sure what happen.  Copy on desktop prior to making change had the change in it.
Not sure what happen.  Copy on desktop prior to making change had the change in it.
Fixed
Fixed
Line 304: Line 394:
Tina DISABLED the cross checking in ACCESS of # of transfusions in tmp
Tina DISABLED the cross checking in ACCESS of # of transfusions in tmp
vs # PC in Lab.   
vs # PC in Lab.   
(cross check was so PC in labs = # of transfusion in
([[cross check]] was so PC in labs = # of transfusion in
tmp before sending allowed).  
tmp before sending allowed).  


Line 378: Line 468:
Update copied up to VIC medicine ONLY
Update copied up to VIC medicine ONLY


[[Category:IT Instructions]]
[[Category:CCMDB.accdb]]
[[Category:Change Logs CCMDB]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=CCMDB.mdb_Change_Log_2008"