Patient copier button: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (→‎Copying Comorbids from one profile to an existing profile: Cleaned up discussion. Looks like further automation of comorb cut and paste is a no-go)
 
(43 intermediate revisions by 14 users not shown)
Line 1: Line 1:
{{Potential Change}}
[[File:Patient copier button.png |300px | thumb | Patient copier button in [[CCMDB.accdb]] ]]
We are thinking about adding functionality to CCMBD.mdb but want to make sure it is worthwhile. Also, we want to know a bit more about the proposal to prioritize it against other tasks.  


We hear repeatedly about patients being shuffled back and forth between units, or being re-admitted after very short absences from the unit. Sometimes a record for the patient is still on CCMDB from the previous admission.  
The patient copier button [[image:Patient Copy button.png]] on [[Patient List]] or [[Patient Viewer Tab Cognos ADT2]] creates a new profile for the same patient. It asks for the new serial number and then copies the following info:
* [[Pat_ID]]
* [[Last Name]]
* [[First Name]]
* [[PHIN]]
* [[DOB]]
* [[Chart]]
* [[Notes]]
* [[Province]]
* [[Sex]]
* [[R_Filter]]
* [[Postal Code]]
* [[Pre acute living situation]]
* any [[Comorbid Diagnoses]]
 
== Caution ==
* please do a quick cross check to the EPR or paper chart when you copy to make sure we don't copy bad data; automating this will make some of the cross checks Pagasa runs less able to catch problems, so please take the extra seconds to make sure the things you are about to copy are right
* do not start hoarding discharged and sent patients to use it or you will be breaking PHIA since we are only allowed to keep a working dataset on our laptops
 
== Copying Comorbids from one profile to an existing profile ==
We can actually copy and paste [[Comorbid Diagnoses]] from one profile to an existing profile.
 
# Highlight the comorbid diagnoses you want to copy by clicking the box on the left of the first comorbid diagnosis (beside the small box where we check the primary diagnosis) and dragging it down to the last diagnosis you want to copy.
# Once all the Comorbids are highlighted, Copy them by pressing the Ctrl button and C on the keyboard at the same time (Ctrl+C)
# Close the profile where you copied the diagnoses.
# Go to the existing profile where you want to enter the copied diagnoses. (Please double check that you have the right patient profile)
# Click on the triangle in the box on the left of the bottom / last diagnosis line where you want the diagnoses entered.
# Paste the copied diagnoses by pressing the Ctrl button and V on the keyboard at the same time (Ctrl+V)
 
We discussed whether the comorbids should just be copied with the profile at the original profile copy, but they will usually not be entered yet at that time, so it would be the wrong point in the process. At a later point, since a "to" profile will always need to be identified, adding a button for this is really not feasible. Looks like manual copy and paste is the best way to do this.
 
== Related articles ==
{{Related Articles}}
 
{{LegacyContent|
We have at times thought about adding functionality to CCMBD.mdb to copy some patient information into a new record.
 
We hear repeatedly about patients being shuffled back and forth between units, or being readmitted after very short absences from the unit. Sometimes a record for the patient is still on CCMDB from the previous admission.  
During a recent meeting we discussed the possibility of having a button in the patient record. When that button is pushed, a new patient entry would be generated that would copy a subset of the information of the existing record. The collector would be prompted for a Serial number for the new record.
During a recent meeting we discussed the possibility of having a button in the patient record. When that button is pushed, a new patient entry would be generated that would copy a subset of the information of the existing record. The collector would be prompted for a Serial number for the new record.


== How useful would this be? ==
== How useful would this be? ==
* On a guess, how many patient records a week would be affected by this? {{discussion}}
Poll to collectors says that they would use this somewhere between 1x/week and 1x/month.


Critical care:
Assuming it takes 5 minutes to re-enter this data manually and only 1 with this tool, a savings of 4 minutes, and 20 data collectors encountering this on average 2x/month, this would add up to >2.6hrs a month.


* CON_MICU -
== Can't encourage hoarding... ==
* GRA_MICU -Once in a while
We can't keep data for discharged patients on the laptops too long for PHIA reasons (we are allowed only "current data"). This tool would encourage keeping older data. So, we would need to add a limit. Proposal: Don't allow sending if there are records with RecordStatus "sent" whose discharge date is more than a week ago.
* HSC_MICU -
* HSC_SICU -
* OAK_MICU -
* STB_CCU -
* STB_CVICU -
* STB_MISI -
* VIC_ICU -
 
Medicine:
 
* GRA_N3 - a few times a month
* GRA_N5 -
* HSC_A4 -
* HSC_B3 -
* HSC_D4 -
* HSC_H4 -
* STB_E5 - 1 per week
* STB_E6 - 1 per week
* VIC_S4 - 0 to 6 per month
* VIC_S5/N5/S3


== What would be the right things to copy? ==
== What would be the right things to copy? ==
Line 40: Line 56:
* put previous location into admit from? Again, could make this optional...
* put previous location into admit from? Again, could make this optional...
* comorbids?
* comorbids?
* for medicine: tasks? seems like they would not usually change...
** Con mentioned that they could change Ttenbergen 17:51, 2016 December 1 (CST)
* for medicine: tasks? seems like they would not usually change...{{discussion}}
**This may not be the case. For example a patient is admitted to Hobs with severe sepsis and unable to perform any of his ADL and has a foley in situ. His ADL would be all major assist.He is then transferred to A4 two weeks later and only requires a minimal assist with his bath, is able to be up and about on the ward independently and his foley had been removed in Hobs. On admission to A4 his ADL in completely different plus he requires far less nursing time for his care.--[[User:CMarks|CMarks]] 12:52, 2015 September 30 (CDT)
*** there would be exceptions like that for many fields. do you think that more often than not ADLs stay same? Or, is the probability such that copying them would be likely to increase errors more than it would ease collection? Ttenbergen 16:50, 2015 October 2 (CDT)
**as a data collector on a very busy renal ward, with lots of diabetic dialysis patients, the most important things to copy (for me) would be the demographics (dispo page), and the comorbids. The comorbids shouldn't change much. (You may have to add more comorbids to any subseqent patient profiles, but you wouldn't really be taking any away.) My diabetic renal patients can have as many as two dozen comorbids. Also, I have the situation of multiple admits with the same patient occurring very frequently. This past Tuesday alone, I had four sets of duplicate patients. As well, when you are entering as many as two dozen comorbids on just one profile, it takes a lot longer than five minutes per profile. In summery, this would be such a helpful tool to be able to use. I would be one happy data collector if this could be set up. [[User:DPageNewton|DPageNewton]] 08:18, 2019 August 1 (CDT)
 
== Log ==
* discussed again as part of [[PatientFollow Project]]
**Copier button to do following:
*** get new Serial
*** run L_Log_copier query with that Serial
*** run L_ICD10_copier query with that Serial
 
* email from Deb 2019-07-30, referred her to this page
 
* Task Team Meeting Discussion and Decision 2018-09-11
**Pros:  would save ~5 min per patient to re-enter.
**Cons: would need to be analyzed and defined before implementation and would have low priority for implementation, and would risk perpetuating inaccuracies.
**We decided that on a balance we are better off without this feature. Ttenbergen 11:01, 2018 September 11 (CDT)
 
* We discussed today the possibility of copying diagnoses and putting them as "tentative" instead of admit or acquired. That would introduce other complexity, eg we would need to be sure that won't cause Julie or Pagasa problems. Overall not as simple as it initally seems. Maybe we need to step back and say only copying demographics? Ttenbergen 17:51, 2016 December 1 (CST)
}}

Latest revision as of 15:53, 2021 August 3

Patient copier button in CCMDB.accdb

The patient copier button on Patient List or Patient Viewer Tab Cognos ADT2 creates a new profile for the same patient. It asks for the new serial number and then copies the following info:

Caution

  • please do a quick cross check to the EPR or paper chart when you copy to make sure we don't copy bad data; automating this will make some of the cross checks Pagasa runs less able to catch problems, so please take the extra seconds to make sure the things you are about to copy are right
  • do not start hoarding discharged and sent patients to use it or you will be breaking PHIA since we are only allowed to keep a working dataset on our laptops

Copying Comorbids from one profile to an existing profile

We can actually copy and paste Comorbid Diagnoses from one profile to an existing profile.

  1. Highlight the comorbid diagnoses you want to copy by clicking the box on the left of the first comorbid diagnosis (beside the small box where we check the primary diagnosis) and dragging it down to the last diagnosis you want to copy.
  2. Once all the Comorbids are highlighted, Copy them by pressing the Ctrl button and C on the keyboard at the same time (Ctrl+C)
  3. Close the profile where you copied the diagnoses.
  4. Go to the existing profile where you want to enter the copied diagnoses. (Please double check that you have the right patient profile)
  5. Click on the triangle in the box on the left of the bottom / last diagnosis line where you want the diagnoses entered.
  6. Paste the copied diagnoses by pressing the Ctrl button and V on the keyboard at the same time (Ctrl+V)

We discussed whether the comorbids should just be copied with the profile at the original profile copy, but they will usually not be entered yet at that time, so it would be the wrong point in the process. At a later point, since a "to" profile will always need to be identified, adding a button for this is really not feasible. Looks like manual copy and paste is the best way to do this.

Related articles

Related articles:

Legacy Content

This page contains Legacy Content.
  • Explanation: No explanation was entered
  • Successor: No successor was entered