CCMDB Wiki

Requested CCMDB changes for the next version: Difference between revisions

← Older editNewer edit →
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
No edit summary
Line 1: Line 1:
== Requested CCMDB '''changes''' for the ''next version'' ==
''see the [[:Category: Development Documentation | Development Documentation Category]] for other development logs''
* see [[CCMDB.mdb Change Log 2009]] for changes that have been rolled out to sites.


=== Updates required for Laptops ===
== Updates required for Laptops ==
* automate the backup to the [[Regional Server]]
* automate the backup to the [[Regional Server]]
* automate a backup to the SD card
* automate a backup to the SD card
Line 9: Line 8:
* look into possibility of automatically downloading WIKI guide to laptop each day that it is synch'd.  (portable version of guideline)--[[User:TOstryzniuk|TOstryzniuk]] 20:11, 4 April 2009 (CDT)
* look into possibility of automatically downloading WIKI guide to laptop each day that it is synch'd.  (portable version of guideline)--[[User:TOstryzniuk|TOstryzniuk]] 20:11, 4 April 2009 (CDT)


=== QA Functionality ===
== QA Functionality ==


==== Facilitate exchange of patient discharge times ====
=== Facilitate exchange of patient discharge times ===
DCs have to know the discharge times for patients arriving at their wards from another collected ward. We should automate that rather than have them exchange manually. Might be an extension of the status file for Julie...[[User:Ttenbergen|Ttenbergen]] 16:05, 3 February 2009 (CST)
DCs have to know the discharge times for patients arriving at their wards from another collected ward. We should automate that rather than have them exchange manually. Might be an extension of the status file for Julie...[[User:Ttenbergen|Ttenbergen]] 16:05, 3 February 2009 (CST)
* moved a note into [[Admit, Transfer and Discharge date and time]], as this is unrelated to updates to the program. [[User:Ttenbergen|Ttenbergen]] 09:27, 11 February 2009 (CST)
* moved a note into [[Admit, Transfer and Discharge date and time]], as this is unrelated to updates to the program. [[User:Ttenbergen|Ttenbergen]] 09:27, 11 February 2009 (CST)


==== Logging errors in the CCMDB.mdb ====
=== Logging errors in the CCMDB.mdb ===
Add a table to the CCMDB that records every time an error is generated with the following details:  
Add a table to the CCMDB that records every time an error is generated with the following details:  
* Date/time of error
* Date/time of error
Line 24: Line 23:
Make that table sync to a central repository on send.
Make that table sync to a central repository on send.


===Defer or in Discussion===
===Under Discussion===
====ARF & CRF & ARI Integrity Check====
These requested changes can not be processed until the questions about them have been answered.
*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid then [[ARF]]  (Diagnosis (350) or [[ARI]] (364) cannot be in admit or complication. (see [[CRF vs ARF, ARI, Renal Transplant]])
 
===ARF & CRF & ARI Integrity Check===
As per [[CRF vs ARF, ARI, Renal Transplant]]:
*if [[CRF - Chronic Renal Failure|CRF (351)]] in comorbid  
** then [[ARF]]  (Diagnosis (350) or [[ARI]] (364) cannot be in admit or complication.  


{{Discussion}}
{{Discussion}}
 
====Discussion====
=====Discussion=====
* The 364 is new since the discussion about the cleaner. What is it about? [[User:Ttenbergen|Ttenbergen]] 15:55, 5 November 2008 (CST)
* 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).
**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 article [[CRF vs ARF, ARI, Renal Transplant]] also mentions something about transplant. Is that still accurate? [[User:Ttenbergen|Ttenbergen]] 14:12, 18 February 2009 (CST)
*The article [[CRF vs ARF, ARI, Renal Transplant]] also mentions something about transplant. Is that still accurate? [[User:Ttenbergen|Ttenbergen]] 14:12, 18 February 2009 (CST)


Line 41: Line 43:
=====Discussion=====
=====Discussion=====
*Right now [[CCMDB.mdb]] uses dd-mmm-yyyy, e.g. 12 Jan 2009. This is less ambiguous than the standard set out on the wiki. I think it's the better option since it eliminates the chance for transposition errors. I think we should use this format for collection. This does not affect how it is sent to Ed, or how it is stored in Ed's program. If Trish is OK with this, this section should be removed from the change log and [[Date and Time Format]] should be updated accordingly. [[User:Ttenbergen|Ttenbergen]] 12:58, 12 February 2009 (CST)
*Right now [[CCMDB.mdb]] uses dd-mmm-yyyy, e.g. 12 Jan 2009. This is less ambiguous than the standard set out on the wiki. I think it's the better option since it eliminates the chance for transposition errors. I think we should use this format for collection. This does not affect how it is sent to Ed, or how it is stored in Ed's program. If Trish is OK with this, this section should be removed from the change log and [[Date and Time Format]] should be updated accordingly. [[User:Ttenbergen|Ttenbergen]] 12:58, 12 February 2009 (CST)
** starting the one-week clock to accept this change since it has not been disputed. [[User:Ttenbergen|Ttenbergen]] 10:44, 23 April 2009 (CDT)


====take out Autopsy YES OR NO====
*ACCESS program is affected because of the way S or E is tied to autopsy on PDA.
*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)
*'''Approved, leave blank'''.[[User:TOstryzniuk|TOstryzniuk]] 05:24, 19 January 2009 (CST)
{{Discussion}}
=====Discussion=====
Julie and Dr. Garland are currently working on moving the whole survive/expire issue into a "Dispo" field. I suggest we wait until they are done rather than implementing this twice. The advantage is that their change will use a data approach (discharge-to has a table) whereas editing the survive/expire options would be a manual change on HanDBase (notoriously unreliable). [[User:Ttenbergen|Ttenbergen]] 13:56, 10 February 2009 (CST)


====APACHE II Screen====
====APACHE II Screen====
*get rid of fields that are not long being collected on the APACHE II screen (SAPS II items).
 
*total Bilirubin, CPAP, urine CC;s, Urea,SAP_Systolic,
*also - eliminate '''APACHE II Active TX field'''.
**DONE- CCMDB Ver 4.0 onward
====APACHE II ACTIVE TX-eliminate this====
====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).
*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).
Line 66: Line 58:
* are you saying that ccmdb.mdb will not allow sending a pt with unchecked active tx? [[User:Ttenbergen|Ttenbergen]] 14:25, 11 February 2009 (CST)
* are you saying that ccmdb.mdb will not allow sending a pt with unchecked active tx? [[User:Ttenbergen|Ttenbergen]] 14:25, 11 February 2009 (CST)
**'''YES'''.[[User:TOstryzniuk|TOstryzniuk]] 13:35, 9 March 2009 (CDT)
**'''YES'''.[[User:TOstryzniuk|TOstryzniuk]] 13:35, 9 March 2009 (CDT)
*** Where is this field in Access, I don't see it on the APACHE screen.[[User:Ttenbergen|Ttenbergen]] 10:44, 23 April 2009 (CDT)


====[[Registry Patient Type]] - eliminate this field====
====[[Registry Patient Type]] - eliminate this field====
Line 78: Line 71:




====s_Fi02 table in Handibase====
*The S_FI02  (note: with a zero rather than a capital o) is a relic we have been unable to get rid of due to technical problems. It is the mis-spelled table name for S_FIO2 (i.e. capital o). Nothing can be done about it until the PDAs are all gone, so this should be taken out of the change log. (see [[S FI02]] for details; remove the link from there if this is taken out of here.)
[[User:Ttenbergen|Ttenbergen]] 13:30, 10 February 2009 (CST)




Line 95: Line 84:
[[Category: Questions IT]]
[[Category: Questions IT]]
[[Category: Questions]]
[[Category: Questions]]
[[Category: Development Documentation]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Requested_CCMDB_changes_for_the_next_version"