Catheter09: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
TOstryzniuk (talk | contribs)
CCMDB_legit, approved, Bureaucrats, Administrators
27,522 edits
mNo edit summary
 
(86 intermediate revisions by 5 users not shown)
Line 1: Line 1:
'''''Note:''' This is a proposed project only at this time. Please feel free to comment if any instructions are unclear, though!''
{{Project
|ProjectActive=legacy
|ProjectProgram=Med
|ProjectRequestor=Kimberly Jabusch
|ProjectCollectionStartDate=2009-10-29
|ProjectCollectionStopDate=2010-01-31
|Project={{PAGENAME}}
}}


The Nursing Leadership Counsel at St Boniface is working on reducing the incidence and duration of urinary catheterizations without appropriate clinical indications for '''medicine''' patients at '''St Boniface General Hospital'''.  We will collect some data for them as part of our temporary studies, initially for three months, but possibly longer pending the results at that time.


== Times ==
{{LegacyContent
|content= }}


*Start Date: will be the week of June 8.09
The Nursing Leadership Counsel at '''St Boniface General Hospital''' is working on '''reducing''' the '''incidence''' and '''duration''' of urinary catheterizations '''without appropriate clinical indications''' for '''medicine''' patients at '''St Boniface General Hospital'''. We will collect some data for them as part of our temporary studies, initially for three months, but possibly longer pending the results at that time.
*Review Date (~75 days after start):
*Preliminary End Date (3 months after start):


* We will start the week of June 8th and pilot the process for a few weeks before vacations start on STB medicine.  First round of vacation starts June 15.  The collector will learn the process before this date and be able implement for all new admissions. 
==[[:Category: Catheter09 Meeting Dates | Catheter09 Meeting Minutes]]==
**Trish meeting with medicine collectors at STB: June 9.09 @ 1300 hrs in MICU Conference Rm.[[User:TOstryzniuk|TOstryzniuk]] 18:31, 5 June 2009 (CDT)
* [[Catheter09_Wednesday, October 28.09]]
*Julie is away last 3 weeks of July.[[User:TOstryzniuk|TOstryzniuk]] 15:54, 2 June 2009 (CDT)
* [[Catheter09 Wednesday, November 25, 2009]]


==Update==
== Dates ==
**Catheter09 items for S_tmp for ccmdb & HanDBase completed.  Will roll out before the end of the week.  See [[CCMDB.mdb Change Log 2009 | CCMDB.mdb Change Log 2009]] for update.  --[[User:TOstryzniuk|TOstryzniuk]] 14:49, 4 June 2009 (CDT)
===Testing Date===
*Testing period October 1-28, 2009
===Start Date===
*Real time start date: All patients who are "discharges" starting '''October 29, 2009'''
===Review Date===
*Review Date (~75 days after start): 15 Dec 2009


=== Discussion ===
===Stop Date===
{{Discussion}}
*'''January 31,2010 @ midnight''''''.--[[User:TOstryzniuk|TOstryzniuk]] 20:01, 27 January 2010 (CST)
* Will this study be impacted by running over the summer months? [[User:Ttenbergen|Ttenbergen]] 17:23, 1 June 2009 (CDT)
*patients that were "admitted" prior to Jan 31.10 midnight, '''you will continue to follow until they are discharged or transferred to another ward from your ward'''.  Once this occurs, the catheter09 study is done for that patient.--[[User:TOstryzniuk|TOstryzniuk]] 17:27, 1 February 2010 (CST)
**Summer is always a challenge. (between May and Aug).  I have 10 weeks of vacation between 3 people with no coverage at this time.  (3 wks in June, 4 wks in July & 3 wks in Aug).  If the program is willing to accept data that is not "immediately" available and up to date and that catch up work can be done in Medical records then it can be done over the summer. (Trish)  
Last patient was discharged long ago, disabling this study in CCMDB. [[User:Ttenbergen|Ttenbergen]] 12:32, 25 February 2011 (CST)
**The vacation free period for STB-MED is Sept 4 to Nov 30.09. (Trish)


== Collection Instructions ==
== Collection Instructions ==
Make a record in L_TmpV2 for every indwelling urinary catheter on your ward. It does not matter whether the patient arrived with it or was catheterized locally.  
Make a record in L_TmpV2 for every indwelling urinary catheter on your ward. It does not matter whether the patient arrived with it or was catheterized locally. '''This data needs to be completed as soon as possible for '''''all''''' patients, not only those who are being sent, since the data is sent for all patients every time data is sent. ''


In the TMP file, every patient must have '''TWO lines''' of entries for '''every foley catheter''' incident.
We need more data than you can put on one line. We could have recorded a line for each data element, but to speed it up for you we combined them on 2 lines as follows:  
We need more data than you can put on one line. We could have recorded a line for each data element, but to speed it up for you we combined them on 2 lines as follows:  
# R-<option> = "Reason" from Item dropdown list; cath event #"1"; "Dr. order" on ''checkbox'';  in date; in time.  
Under '''Item''':
# W-<option> = "Where inserted" from Item dropdown box; cath event #"1";  "UTI post" ''checkbox'';  out date; out time.
# R-"Reason" from Item dropdown list; cath event #"1"; "Dr. order" on ''checkbox'';  in date; in time.  
# W-"Where inserted" from Item dropdown box; cath event #"1";  "UTI post" ''checkbox'';  out date; out time. (may not have a removal date if: died, moved to ICU or moved to another ward with same foley)


For example:  
*For example:  
#Project: Catheter09; Item: “''R-Urinary incontinence''”, cath event # "''1''",  Dr order: “''yes''”, in date: "''12 May,09''" in time: "''10:00''"
'''*1. Project: Catheter09'''
#Project: Catheter09; Item: “''W-HSC A4''”, cath event # "''1''", UTI post: “''no''”, “out date”, "''14 May 0''9", out time, ''14:00''
*Item: “''R-Urinary incontinence''” SEE: ([[Catheter09#Value_-_Actual_.28R.29_.22reason.22_for_insertion_options Go to drop down list options]])
*cath event # "''1''"  
*Dr order: “''yes''”  
*in date: "''12 May,09''"  
*in time: "''10:00''"
 
'''*2. Project: Catheter09'''
*Item: “'' STB_ER''” SEE: ([[Catheter09#Value_Actual_.28W.29_.22where.22_inserted_options Go to drop down list options]])
*cath event # "''1''"
*UTI post: “''no''”,  
*“out date”, "''14 May 0''9"
*out time, ''14:00''


If a patient was catheterized more than once, enter several sets of records. Make sure you finish entering one set of records before starting the next, as the record date/time will be used to group the records.  
If a patient was catheterized more than once, enter several sets of records. Make sure you finish entering one set of records before starting the next, as the record date/time will be used to group the records.  


 
=== "Reason for insertion" data ===
 
Choose the '''first''' item starting with an''' “R-”''' listed under Catheter09’s item list that applies to this patient. The items are specifically ordered so that if you choose the first one that applies we will get the best results.
=== Reason for insertion data ===
Choose the '''first''' item starting with an “R-” listed under Catheter09’s item list that applies to this patient. The items are specifically ordered so that if you choose the first one that applies we will get the best results.


===Catheter event data (int_var_label)===
===Catheter event data (int_var_label)===
Line 45: Line 65:
=== Dr order ===
=== Dr order ===
Check the checkbox if there is a doctor’s order to catheterize in the chart
Check the checkbox if there is a doctor’s order to catheterize in the chart
==== Discussion ====
{{discussion}}
I took out
*should be on the physicians order form.
If it were left as is someone might interpret that as a direction to only consider an order on said form.
Do we explicitly only want written orders on the correct form? If so, the first line should be changed to
* "Check the checkbox if there is a doctor’s order to catheterize '''on a doctor's order form''' in the chart"
Otherwise the point is likely redundant, as I really hope our DCs already know where they would find this. [[User:Ttenbergen|Ttenbergen]] 10:38, 4 June 2009 (CDT)


=== in date, in time (insert) / out date, out time (remove)===
=== in date, in time (insert) / out date, out time (remove)===
Date and time the catheter was inserted or removed.  
Date and time the catheter was inserted or removed.  
* If you can’t find a time, use midnight.
* Make a reasonable effort to find the right time/date
* If the time is in fact midnight, record 23:59
** If you can’t find a '''time''', use midnight
*** If the time is in fact midnight, record 23:59
** If you can't find a '''date''', use your best guess
** If you can't find a '''time or date''', enter your best approximation given the available data


=== "Where" Data ===
=== "Where" Data ===
Choose the place (elements starting with "W-") where the catheter was inserted.
Choose the place (elements starting with "W-") where the catheter was inserted.
===UTI (urinary track infection)===
===UTI (urinary track infection)===
'''IMPORTANT'''
Check the UTI check box for any patient who acquired a UTI while catheterized.
*for a patient to be considered '''positive''' (+ve) for a '''catheter-related''' '''urinary tract infection''', the urine sample must be taken '''> 48 hours after''' the '''catheter''' has been '''inserted'''.
 
For the UTI to be considered catheter related, the positive (+ve) urine sample must be taken between '''>48 hrs after''' the catheter has been inserted and '''<=48 hrs after''' the catheter was removed.


== Data Structure Setup ==
== Data Structure Setup ==
The s_tmp lines driving this will be similar to the following table. These lines need to be added to the s_tmp table on [[CCMDB.mdb]] and on the PDA.
The s_tmp lines driving this will be similar to the following table. These lines need to be added to the s_tmp table on [[CCMDB.accdb]].


{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
{| class="wikitable" border=1 <hiddentext> set to 0 for no borders</hiddentext>
Line 87: Line 102:
|  valign="bottom" | cath event "#"
|  valign="bottom" | cath event "#"
|  valign="bottom" | ~~
|  valign="bottom" | ~~
|  valign="bottom" | Dr order (checkbox marked = Yes)
|  valign="bottom" | '''Dr order''' (checkbox marked = Yes)
|  valign="bottom" | in date
|  valign="bottom" | in date
|  valign="bottom" | in time
|  valign="bottom" | in time
Line 98: Line 113:
|  valign="bottom" | cath event "#"
|  valign="bottom" | cath event "#"
|  valign="bottom" | ~~
|  valign="bottom" | ~~
|  valign="bottom" | UTI (checkbox marked = Yes)
|  valign="bottom" | '''UTI''' (checkbox marked = Yes)
|  valign="bottom" | out date
|  valign="bottom" | out date
|  valign="bottom" | out time
|  valign="bottom" | out time
Line 105: Line 120:
|}
|}


===Study "Catheter09===
*Name of project


=== Value - Actual "reason" options ===
===Study (Project) "Catheter09===
 
=== Value - Actual '''(R) "reason"''' for insertion options ===
''Note: Arrived with is at the top because it should be chosen for anyone arriving from off unit. Since the instructions say to use the first item on the list which applies, sorting it to the top will make it the option chosen for all who arrive catheterized.''
''Note: Arrived with is at the top because it should be chosen for anyone arriving from off unit. Since the instructions say to use the first item on the list which applies, sorting it to the top will make it the option chosen for all who arrive catheterized.''
*R-arrived with foley
*R-arrived with foley
*R-routine foley change (Nov 9.09)--[[User:TOstryzniuk|TOstryzniuk]] 20:18, 9 November 2009 (CST)
*R-urinary incontinence  
*R-urinary incontinence  
*R-acute/chronic retention  
*R-acute/chronic retention  
Line 121: Line 137:
*R-monitoring of hematuria
*R-monitoring of hematuria
*R-patient preference
*R-patient preference
 
*R-unknown
===Instruction===
*no specific instruction listed on PDA


===Catheter event (int_var_label)===
===Catheter event (int_var_label)===
*each foley catheter insertion has 2 lines of information in L_tmp on your PDA.   One for insertion the other for removal.  
*each foley catheter insertion has 2 lines of information in L_tmp. One for insertion the other for removal.  
*an identifier allow collector to group the 2 lines to one event.   
*an identifier allow collector to group the 2 lines to one event.   
*For example for ONE patient:
*For example for ONE patient:
Line 133: Line 147:
*feel free anyone to reword this example.[[User:TOstryzniuk|TOstryzniuk]] 17:38, 3 June 2009 (CDT)
*feel free anyone to reword this example.[[User:TOstryzniuk|TOstryzniuk]] 17:38, 3 June 2009 (CDT)


=== Value Actual "where" inserted options ===
=== Value Actual '''(W) "where"''' inserted options ===
*STB ER  
*W-STB ER  
*STB ICU
*W-STB ICU
*This Ward
*W-This Ward
*Other STB ward  
*W-Other STB ward  
*Other Facility
*W-Other Facility
 
*W-Not Applicable (do not use this option if admitted from ER).  If this item is used you must type reason in comment section.  (not rolled out yet)--[[User:TOstryzniuk|TOstryzniuk]] 09:36, 3 November 2009 (CST)
=== Complete Files Only? ===
{{discussion}}
* Will we need this data only once a patient is sent, or as the recording proceeds? I suspect only as a patient is sent... [[User:Ttenbergen|Ttenbergen]] 17:23, 1 June 2009 (CDT)
** Good question. Follow-up to this is 'Is there a time period the Investigator wanted the outputs to be summarized? Ex. how many catherization days occured for months of July and Aug. The time reference here is either the date inserted or the date removed.  If yes then the data is needed as recording proceeds.  But if the interest is data on a per patient level, then the data is needed once a patient is sent.  The time reference to be used if needed is the Discharge Date.  There will be a long wait for patients having a long stay.' [[User:JMojica|JMojica]] 11:18, 2 June 2009 (CDT)
*** I almost got the impression that Kim and co. will do their own analysis. This would be all the better for you, Julie, since it would save you time. It might be nice to pump it into an Access file for them, that way they can just pivot-table it any way they want - it's really quite slick. I am suggesting this based on the idea that Julie's time is at a premium here. If we use a tool that allows people to do their own investigation, then we don't need to decide ahead of time how to group. I may be underestimating the skill set required, but it sounds like this would be a good group to try with since they said they have some data analysis capability within their group. [[User:Ttenbergen|Ttenbergen]] 10:48, 3 June 2009 (CDT)


== Data Processing ==
== Data Processing ==
Our [[statistician]] will pull the data from the TmpV2_1.mdb file on the regional server. We will provide this data to the requester in the following format:  
Our [[statistician]] will pull the data from the TmpV2_1.mdb file on the regional server. We will provide this data to the requester in the following format:  
:Serial
:Serial
:Site (we don't need site since this is only for StB)
:Site (we don't need site since this is only for STB)
:Location
:Location
:Catheter Event
:Catheter Event
:Reason
:(R)Reason
:Dr.Order
:Dr.Order
:Date & time Inserted
:Date & time Inserted
:Date & time Removed
:Date & time Removed
:Total catheter days(calculated - if this comes in an Access file it can be generated internally right there)
:Number of catheter days per ward admission (calculated as difference between Date & Time Removed and Date & Time Inserted)
:Where inserted
:(W)Where inserted
:Post Insertion (PI) UTI
:Post Insertion UTI (urinary tract infection)
*We will not provide patient identifiers at this time, but if necessary later we can resolve Serial, Site and location to patient identifiers.  
*We will not provide patient identifiers at this time, but if necessary later we can resolve Serial, Site and location to patient identifiers.  


*Summary statistics will be provided like frequencies for  Reasons and PI-UTI  and descriptive stats (N, mean,median, STD, min, max) for Catheter days. [[User:JMojica|JMojica]] 10:22, 2 June 2009 (CDT)
*Summary statistics will be provided: 1)Frequencies for  Reasons, PI-UTI, Dr Orders, Where Inserted and 2)descriptive stats (N, mean,median,sum, Std Dev, min, max) for 'Total Catheter Days per patient' defined as the sum of catheter days of all ward admissions of a given patient.  
** don't use that acronym here, it may mean different things to medical folks in a genitourinary setting ;-) [[User:Ttenbergen|Ttenbergen]] 10:48, 3 June 2009 (CDT)
 
** see above re. whether to analyze this data for them [[User:Ttenbergen|Ttenbergen]] 10:48, 3 June 2009 (CDT)
==Project Wrap up Comments==
*On behalf of the Medicine Program Nursing Leadership Council, thank you to you and your entire team for their assistance with this project.  The preliminary data was shared with the Council last week and this was the baseline data we required to now be able to move on to implementation of the clinical practice guidelines. I have spoken with Julie and she will provide a final report in February 2010.  I do not require a final meeting.  Again, thanks much. Regards,
*Kimberly Jabusch, RN MN BA
*Clinical Nurse Specialist
*St. Boniface General Hospital
*Medicine Program
 
{{Data Integrity Check List|}}
 


[[Category:Special Short Term Projects]]
[[Category:Catheter09]]
  }}

Latest revision as of 12:05, 5 January 2022

Projects
Active?: legacy
Program: Med
Requestor: Kimberly Jabusch
Collection start: 2009-10-29
Collection end: 2010-01-31
  • SMW

(inline)

  • Cargo


  • Categories
  • Form



Legacy Content

This page contains Legacy Content.

  • Explanation: No explanation was entered
  • Successor: No successor was entered

Click Expand to show legacy content.


The Nursing Leadership Counsel at St Boniface General Hospital is working on reducing the incidence and duration of urinary catheterizations without appropriate clinical indications for medicine patients at St Boniface General Hospital. We will collect some data for them as part of our temporary studies, initially for three months, but possibly longer pending the results at that time.

Catheter09 Meeting Minutes

Dates

Testing Date

  • Testing period October 1-28, 2009

Start Date

  • Real time start date: All patients who are "discharges" starting October 29, 2009

Review Date

  • Review Date (~75 days after start): 15 Dec 2009

Stop Date

  • January 31,2010 @ midnight'.--TOstryzniuk 20:01, 27 January 2010 (CST)
  • patients that were "admitted" prior to Jan 31.10 midnight, you will continue to follow until they are discharged or transferred to another ward from your ward. Once this occurs, the catheter09 study is done for that patient.--TOstryzniuk 17:27, 1 February 2010 (CST)

Last patient was discharged long ago, disabling this study in CCMDB. Ttenbergen 12:32, 25 February 2011 (CST)

Collection Instructions

Make a record in L_TmpV2 for every indwelling urinary catheter on your ward. It does not matter whether the patient arrived with it or was catheterized locally. 'This data needs to be completed as soon as possible for all patients, not only those who are being sent, since the data is sent for all patients every time data is sent.

In the TMP file, every patient must have TWO lines of entries for every foley catheter incident. We need more data than you can put on one line. We could have recorded a line for each data element, but to speed it up for you we combined them on 2 lines as follows: Under Item:

  1. R-"Reason" from Item dropdown list; cath event #"1"; "Dr. order" on checkbox; in date; in time.
  2. W-"Where inserted" from Item dropdown box; cath event #"1"; "UTI post" checkbox; out date; out time. (may not have a removal date if: died, moved to ICU or moved to another ward with same foley)
  • For example:

*1. Project: Catheter09

*2. Project: Catheter09

If a patient was catheterized more than once, enter several sets of records. Make sure you finish entering one set of records before starting the next, as the record date/time will be used to group the records.

"Reason for insertion" data

Choose the first item starting with an “R-” listed under Catheter09’s item list that applies to this patient. The items are specifically ordered so that if you choose the first one that applies we will get the best results.

Catheter event data (int_var_label)

Catheter event number, i.e. "1" for the first catheterization, "2" for the second

Dr order

Check the checkbox if there is a doctor’s order to catheterize in the chart

in date, in time (insert) / out date, out time (remove)

Date and time the catheter was inserted or removed.

  • Make a reasonable effort to find the right time/date
    • If you can’t find a time, use midnight
      • If the time is in fact midnight, record 23:59
    • If you can't find a date, use your best guess
    • If you can't find a time or date, enter your best approximation given the available data

"Where" Data

Choose the place (elements starting with "W-") where the catheter was inserted.

UTI (urinary track infection)

Check the UTI check box for any patient who acquired a UTI while catheterized.

For the UTI to be considered catheter related, the positive (+ve) urine sample must be taken between >48 hrs after the catheter has been inserted and <=48 hrs after the catheter was removed.

Data Structure Setup

The s_tmp lines driving this will be similar to the following table. These lines need to be added to the s_tmp table on CCMDB.accdb.

Project Value Instructions int_var_label float_var_label bool_var_label date_var_label time_var_label complete_sent
Catheter09 R-arrived with foley (one line per reason see Wiki Catheter09 cath event "#" ~~ Dr order (checkbox marked = Yes) in date in time TRUE
Catheter09 W-(where inserted). One line per option see Wiki Catheter09 cath event "#" ~~ UTI (checkbox marked = Yes) out date out time TRUE


Study (Project) "Catheter09

Value - Actual (R) "reason" for insertion options

Note: Arrived with is at the top because it should be chosen for anyone arriving from off unit. Since the instructions say to use the first item on the list which applies, sorting it to the top will make it the option chosen for all who arrive catheterized.

  • R-arrived with foley
  • R-routine foley change (Nov 9.09)--TOstryzniuk 20:18, 9 November 2009 (CST)
  • R-urinary incontinence
  • R-acute/chronic retention
  • R-accurate urinary output
  • R-Mgt decubitus ulcer (perineal/sacral wounds)
  • R-palliative care
  • R-hemostasis-active bleeding
  • R-ordered by Urologist
  • R-order pre OP/procedure
  • R-monitoring of hematuria
  • R-patient preference
  • R-unknown

Catheter event (int_var_label)

  • each foley catheter insertion has 2 lines of information in L_tmp. One for insertion the other for removal.
  • an identifier allow collector to group the 2 lines to one event.
  • For example for ONE patient:
    • Reason for insertion of initial catheter would have a cath event #1. The remove of this catheter would also be marked with cath event #1.
    • If another foley is reinserted, then this would be marked as cath event #2. When it is removed, it would also marked as event 2.
  • feel free anyone to reword this example.TOstryzniuk 17:38, 3 June 2009 (CDT)

Value Actual (W) "where" inserted options

  • W-STB ER
  • W-STB ICU
  • W-This Ward
  • W-Other STB ward
  • W-Other Facility
  • W-Not Applicable (do not use this option if admitted from ER). If this item is used you must type reason in comment section. (not rolled out yet)--TOstryzniuk 09:36, 3 November 2009 (CST)

Data Processing

Our statistician will pull the data from the TmpV2_1.mdb file on the regional server. We will provide this data to the requester in the following format:

Serial
Site (we don't need site since this is only for STB)
Location
Catheter Event
(R)Reason
Dr.Order
Date & time Inserted
Date & time Removed
Number of catheter days per ward admission (calculated as difference between Date & Time Removed and Date & Time Inserted)
(W)Where inserted
Post Insertion UTI (urinary tract infection)
  • We will not provide patient identifiers at this time, but if necessary later we can resolve Serial, Site and location to patient identifiers.
  • Summary statistics will be provided: 1)Frequencies for Reasons, PI-UTI, Dr Orders, Where Inserted and 2)descriptive stats (N, mean,median,sum, Std Dev, min, max) for 'Total Catheter Days per patient' defined as the sum of catheter days of all ward admissions of a given patient.

Project Wrap up Comments

  • On behalf of the Medicine Program Nursing Leadership Council, thank you to you and your entire team for their assistance with this project. The preliminary data was shared with the Council last week and this was the baseline data we required to now be able to move on to implementation of the clinical practice guidelines. I have spoken with Julie and she will provide a final report in February 2010. I do not require a final meeting. Again, thanks much. Regards,
  • Kimberly Jabusch, RN MN BA
  • Clinical Nurse Specialist
  • St. Boniface General Hospital
  • Medicine Program

Data Integrity Checks (automatic list)

none found 

 }}
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Catheter09&oldid=153811"