CCMDB Wiki

CCMDB.mdb Change Log 2008: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
 
(45 intermediate revisions by 3 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)


=== Before being able to use on the laptops ===
==December 5, 2008, 1800 hrs.==
* automate the backup to the server
*Tasks have all been completed and rolled out to sites.
* automate a backup to the SD card
*STB is a combined ICU unit know as STB_MICU or BM as of Jan 15.07
* automate checking for new front-end on every log in to the network
*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


=== MI Data Integrity Check ===
*IN MASTER DATABASE for ICU & Medicine (retro to Jan 15.08)
If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.
**converted all STB Location from SICU, to MICU
===ARF & CRF Integrity Check===
**converted all admit/discharge from BS to BM
*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF - Acute Renal Failure|ARF(350)]] or 364 cannot be in admit or complication.
**converted all var 3 or 5 from VS or SV to VM or MV
** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)
**Laura emailed to check her PDA and change any serials with location of STB_SICU to STB_MICU before next send.
***Yes, since I have been further reviewing patient profiles in more detail from the problems that SAS has generated, I see renal insufficiency (364)being coded in admit or complication DX slots for patients who have a comorbid condition of chronic renal failure (351).
[[User:TOstryzniuk|TOstryzniuk]] 18:26, 5 December 2008 (CST)


== The Change Log ==
=== November 4, 2008 ===
===next entry===
 
=== 4 Nov 2008 ===
* adding values for the lab maximums. [[User:Ttenbergen|Ttenbergen]] 16:26, 4 November 2008 (CST)
* 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)
* sent to Trish for testing [[User:Ttenbergen|Ttenbergen]] 16:51, 4 November 2008 (CST)
Line 57: Line 72:
*ROLLED OUT
*ROLLED OUT
[[User:TOstryzniuk|TOstryzniuk]] 19:29, 29 October 2008 (CDT)
[[User:TOstryzniuk|TOstryzniuk]] 19:29, 29 October 2008 (CDT)
**** These new changes are not in our PDA? Where do the pathogen updates go re Syphilis treponema Pallidium  and Lyme Borrelia Burgdorferi ? Shirley Kiesman.
*****Should be on your PDA under Neurolgic dropdown DX list.  77-93 Menigoencehp-Syphilis.
the pathogen subcode used 93 which is labelled Syphilis-Treponema Pallidium.  It is too long to list it under 77-73 with the full bug name.
Let me know if you see it now. [[User:TOstryzniuk|TOstryzniuk]] 16:28, 30 October 2008 (CDT)
****** Thank you Trish They are now in my PDA.
****** We must not have synced our PDA's. It is there! thanks


===September 29, 2008===
===September 29, 2008===
Line 91: 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 121: 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 201: 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 240: 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 291: 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 362: 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 378: 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 389: 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 463: 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"