Pharmacy collection: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
 
(133 intermediate revisions by 9 users not shown)
Line 1: Line 1:
these instructions are to come into effect 2012-01-01
The Critical Care Database collects [[Drugs Collected]] for '''critical care patients'''. The Medicine Program does '''not''' collect any pharmacy information.
please test as you get a chance!


Collect pharmacy data for '''critical care patients''' admitted after midnight 2012-01-01 into the Pharmacy Flowsheet.  
== How to enter the data ==
In the [[Patient viewer]], go to the [[Patient Viewer Tab Pharm_Flow]].  


The Data Collector in the Medicine Program do '''not''' collect any pharmacy information.  
For the drugs listed in the row with a date at the start, enter the '''number of days''' for which a [[Drugs Collected | drug]] was given.


Continue collection of pharmacy for old patients as per old instructions. Let Tina know when the last pt with data in the old sheet is gone.  
For the drugs with check boxes, check the box if the drug was given '''even once during the admission'''. These drugs are not counted.  


{{discussion}}
Only collect the [[Drugs Collected | drugs]] specifically listed.
'''what does a new collector need to know to collect pharmacy correctly?'''[[User:Ttenbergen|Ttenbergen]] 19:13, 8 December 2011 (CST)


== TISS / Pharm corellation ==
=== Data Entry Hints ===
The following items on your pharmacy form should be confirmed against the corresponding items on the [[:Category:TISS|TISS]]:
*double-click into a cell to up it by 1 (or in case of 0/1 drugs, to toggle between 0 and 1
* inotropes, heparin, antiarrythmic marked in you history notes and pharmacy form <what TISS items?>
*hover over a cell to get a popup with the drugs that are part of any of the groups we collect
* check that TISS # 76 or 77 is marked against the antibiotics on the MAR
*today's date automatically is put into the line when you enter a new line. This also helps to keep track of when you last counted drugs.  
* check that Tiss 71 is marked when pt had potassium via central line;
*you can change the date using the "+" and "-" buttons, and enter today's date using the "*" button
* check #70 is marked if patient is on Vasopressin.
=== discussion ===
{{discussion}} '''which of these are still relevant? pls. just remove ones that no longer are.'''[[User:Ttenbergen|Ttenbergen]] 19:02, 8 December 2011 (CST)


== temp note - delete after Dec 2011 ==
=== Data Collection Hints ===
Streptomycin was initially listed as to-be-collected for both aminoglycosides and anti-tb drugs; discussed with Dr. Garland and we will collect this only under anti-TB drugs. [[User:Ttenbergen|Ttenbergen]] 16:09, 9 December 2011 (CST)
*When reviewing the MAR for all drugs or flow sheets for infusions you may find it helpful to make a pencil mark after the drugs you have counted up to so that when you look at it again, the same drugs are not duplicate counted.


== Data Integrity Checks ==
=== multiple lines for different days collected ===
None as of now, but I will add some as we get used to this. For example:
To provide functionality similar to paper flow sheets you can add a line per day of collection. It is not mandatory to use multiple lines, the functionality is there only for data collector convenience.
* each patient has to have at least one line of no entries
You don't need to list entries for a given day, the lines are there only allow you to break down your work if a patient stays for a long time.  
Values entered over multiple lines will be added up before sending; a listing for the sum wasn't included due to space restrictions.


== things to finish before go-live ==
=== no double-counting ===
* roll out new ccmdb_data
* If 2 drugs are in the same category, only count one day for each category (don't double count).
* inform Pagasa of change in process, update [[Pharmacy Collection HSC]]
* If a patient is on a combination of oral and intravenous for the same drug, only count the drug once per day regardless of administration route.
* inform HSC Pharmacy of change in process, update [[Pharmacy Collection HSC]]
* reconfirm whether [[Pharmacy Collection Form]] is still used
** added to email to collectors to inform about this update, waiting for answers[[User:Ttenbergen|Ttenbergen]]


[[Category: Pharmacy | *]]
=== No PCA  ===
Do not collect drugs administered via PCA ([https://secure.wikimedia.org/wikipedia/en/wiki/Patient-controlled_analgesia Patient-controlled analgesia]) which is intermittent. As discussed and agreed by ICU task team - Dr. Allan Garland.
 
=== No epidural or intravertebral administration ===
We do not collect epidural or intravertebral.
 
=== oral/nasogastric tube drugs===
Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted (e.g. specified continuous infusions would be an exception).
 
{{Data Integrity Check List}}
 
== Legacy Info ==
* after 2012-09-25
** Reduced number of drugs collected in [[L Pharm Flowsheet table]]
** started to collect some as yex/no boolean variables in [[L_Log table]]
 
* after 2012-01-01
** values collected into [[L Pharm Flowsheet table]]
** HSC collects like other sites
** change-over based on date of drug, so for profiles that straddle the change date some data could be in old and in new setup
 
* prior to 2012-01-01
** HSC labs were imported
** other sites were all collected as counts in [[L_Pharm]] table
 
== Related articles ==
{{Related Articles}}
 
[[Category:Pharmacy| *]]

Latest revision as of 11:28, 2022 February 17

The Critical Care Database collects Drugs Collected for critical care patients. The Medicine Program does not collect any pharmacy information.

How to enter the data

In the Patient viewer, go to the Patient Viewer Tab Pharm_Flow.

For the drugs listed in the row with a date at the start, enter the number of days for which a drug was given.

For the drugs with check boxes, check the box if the drug was given even once during the admission. These drugs are not counted.

Only collect the drugs specifically listed.

Data Entry Hints

  • double-click into a cell to up it by 1 (or in case of 0/1 drugs, to toggle between 0 and 1
  • hover over a cell to get a popup with the drugs that are part of any of the groups we collect
  • today's date automatically is put into the line when you enter a new line. This also helps to keep track of when you last counted drugs.
  • you can change the date using the "+" and "-" buttons, and enter today's date using the "*" button

Data Collection Hints

  • When reviewing the MAR for all drugs or flow sheets for infusions you may find it helpful to make a pencil mark after the drugs you have counted up to so that when you look at it again, the same drugs are not duplicate counted.

multiple lines for different days collected

To provide functionality similar to paper flow sheets you can add a line per day of collection. It is not mandatory to use multiple lines, the functionality is there only for data collector convenience. You don't need to list entries for a given day, the lines are there only allow you to break down your work if a patient stays for a long time. Values entered over multiple lines will be added up before sending; a listing for the sum wasn't included due to space restrictions.

no double-counting

  • If 2 drugs are in the same category, only count one day for each category (don't double count).
  • If a patient is on a combination of oral and intravenous for the same drug, only count the drug once per day regardless of administration route.

No PCA

Do not collect drugs administered via PCA (Patient-controlled analgesia) which is intermittent. As discussed and agreed by ICU task team - Dr. Allan Garland.

No epidural or intravertebral administration

We do not collect epidural or intravertebral.

oral/nasogastric tube drugs

Be sure to collect all intravenous and oral preparations for each drug unless otherwise noted (e.g. specified continuous infusions would be an exception).

Data Integrity Checks (automatic list)

 AppStatus
Check Sub PharmCheckCCMDB.accdbimplemented
Query check CCI TISS Pharm VasoactiveCCMDB.accdbimplemented

Legacy Info

  • after 2012-01-01
    • values collected into L Pharm Flowsheet table
    • HSC collects like other sites
    • change-over based on date of drug, so for profiles that straddle the change date some data could be in old and in new setup
  • prior to 2012-01-01
    • HSC labs were imported
    • other sites were all collected as counts in L_Pharm table

Related articles

Related articles: