CCMDB Wiki

CCMDB.mdb Change Log 2008: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
 
(64 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.


== Requested changes for the next version ==
=== Admit-from and discharge-to for ICU can't be current location ===
a. The admit From should never be the same as the Hospital and Location code (ex.  FROM = HM, Hosp=HSC, Loc=MICU)
b. The discharge To should never be the same as the Hospital and Location code (ex. Hosp=HSC, Loc=MICU, To = HM) As 8(b)


=== Ensure discharge time = 0:00 can't get through ===
== The 2008 CCMDB Change Log ==
to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working
===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)


=== Must be able to delete completed files inside Access ===
===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)


=== Must be able to enter new files into Access ===
==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


=== Before being able to use on the laptops ===
*IN MASTER DATABASE for ICU & Medicine (retro to Jan 15.08)
* automate the backup to the server
**converted all STB Location from SICU, to MICU
* automate a backup to the SD card
**converted all admit/discharge from BS to BM
* automate checking for new front-end on every log in to the network
**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)


== The Change Log ==
=== 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===
===October 29, 2008===
'''*DX code updates/repairs:'''
*s-alldiagnosis for CCMDB and Handibase.
'''*DX code updates/repairs/NEW:'''
**199-16 nosebleed added in brackets to be consistent with code label
**199-16 nosebleed added in brackets to be consistent with code label
**199-17 uncontrolled bleeding requires Transfus/OR
**199-17 uncontrolled bleeding requires Transfus/OR (NEW CODE)
**777-5 & 777-6 spelling fix (Dilatation)
**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 updates'''
**Syphilis -Treponema Pallidium
**pathogen subcode 93 -Syphilis-Treponema Pallidium
**Lyme-Borrelia Burgdorferi
**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.'''
'''*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-65
**77-68
**77-68
Line 39: Line 68:
**77-95
**77-95


***'''NOTE TO DATA COLLECTORS''': Syphilis code now added.  If neurosyphilis then use code 77-93 (as per Dr. Kumar).
***'''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)
[[User:TOstryzniuk|TOstryzniuk]] 19:29, 29 October 2008 (CDT)


Line 65: Line 96:
[[User:TOstryzniuk|TOstryzniuk]] 18:08, 30 July 2008 (CDT)
[[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 95: 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 175: 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 214: 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 265: 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 336: 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 352: 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 363: 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 437: 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"