CCMDB Wiki

CCMDB.mdb Change Log 2008: Difference between revisions

← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
 
(27 intermediate revisions by 3 users not shown)
Line 1: Line 1:
{{Discussion}}
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.
Tina, should we make a new change long for 2009? This one is so long should go into Legacy file and for 2009 just include items from 2008 that you want.[[User:TOstryzniuk|TOstryzniuk]] 14:30, 29 December 2008 (CST)


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 CCMDB changes for the next version ==


===take out Autopsy YES OR NO===
== The 2008 CCMDB Change Log ==
*ACCESS program is affected because of the way S or E is tied to autopsy on PDA.
===December 31, 2008===
*PDA Reader or master database utility programs are not affected if this field is left BLANK.
*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)


[[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 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)


===Patient TYPE for Registry - eliminate this field===
*ACCESS program is affected because it requires this field to be filled in before sending is allowed.
*PDA Reader or master database utility programs are not affected if this field is left BLANK
[[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)
===APACHE II ACTIVE TX-eliminate this===
*ACCESS program is affected because it makes this a required field (though my understanding is that many data collectors have set default for boxed to be checked).
*PDA Reader or master database utility programs are not affected if this field is left BLANK
[[User:TOstryzniuk|TOstryzniuk]] 16:29, 12 December 2008 (CST)
=== 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 ===
to implement check mentioned in [[Admit, Transfer and Discharge date and time]] but not currently working
=== Must be able to delete completed files inside Access ===
=== Must be able to enter new files into Access ===
=== Before being able to use on the laptops ===
* automate the backup to the server
* automate a backup to the SD card
* automate checking for new front-end on every log in to the network
=== MI Data Integrity Check ===
If 102-10 you must not use any another 102 with a subcode. update [[Myocardial infarction]] when done.
===ARF & CRF & ARI Integrity Check===
*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF (Diagnosis)|ARF(350)]] or [[Acute Renal Insufficiency | ARI (364)]] cannot be in admit or complication.
** The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)
***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).
== The Change Log ==
==December 17, 2008==
==December 17, 2008==
*DX code rewording S_alldiagnosis for ACCESS and Handibase.
*DX code rewording S_alldiagnosis for ACCESS and Handibase.
Line 98: 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 162: 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 242: 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 281: 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 332: 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 403: 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 419: 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 430: 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 504: 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"