CCU Service Tracking: Difference between revisions

(19 intermediate revisions by 5 users not shown)

Line 1:

~~'' for tracking which service sent to an ICU, see~~ [[Service ~~Sending to ICU~~]] ~~instead~~

{{Project

|ProjectActive=legacy

|ProjectProgram=CC

|ProjectRequestor=Unknown/legacy

|ProjectCollectionStartDate=2010-10-01

|ProjectCollectionStopDate=2016-07-07

|Project=CCU Service Tracking

}}

{{LegacyContent

|explanation=was replaced as part of [[2016 Time and Place changes]]

|successor=[[Previous Service field]]

|content=

== Purpose ==

Line 5:

Line 16:

== Data Collection Instructions ==

For patients occupying a STB MICU bed~~, that during their stay in MICU~~ have been under Cardiology Service at any time, enter the service they are admitted under. If the service changes during the stay, enter a new tmp entry for the new service as well.

For patients occupying a STB MICU or CICU bed and have been under Cardiology Service (as opposed to Cardiac Surgery) at any time, enter the service they are admitted under in tmp. If the service changes during the stay, enter a new tmp entry for the new service as well.

If a patient occupying a STB MICU bed remains under ~~MICU~~ coverage their entire stay, there is no need to make a tmp entry for CCU Service at all.

If a patient occupying a STB MICU or CICU bed remains under their own service coverage their entire stay, there is no need to make a tmp entry for CCU Service at all.

Use tmp fields:

* Project: '''CCU_Service'''

* Item: '''CCU''' or '''MICU'''

* Item: '''CCU''' or '''MICU''' or '''CICU'''

* start_dt: '''date of service change'''

* start_tm: '''time of service change'''

** If the pt arrives under Cardiology (CCU) service the date and time for this tmp entry will be the same as the admission date and time to MICU.

~~=== should this be available for collection for CCU as well ===~~

~~{{discussion}}~~

* Received request from Julie/Laura to add ability to collect this to CCU laptop. Waiting for clarification because I thought all of CCU was cardiology, so there would be no need to collect this. Ttenbergen 18:50, 2016 March 25 (CDT)

**CICU was the request (not CCU). CICU is the Surgical ICU for Cardiac Surgery. Pt type usually in this unit is "surgery". We need the option of using CCU tracking in this unit because, at times, this is where they are put when MICU is full. CCU currently cannot take patients that have IABP's or are intubated so, when this happens, they have to be located in one of the ICU's at STB (either MICU or CICU). FYI: a new CCU is being built that will accommodate these types of patients. (The estimated time of this unit opening is June 2016).--[[User:LKolesar|LKolesar]] 09:23, 2016 March 29 (CDT)

*** Sorry, I meant CICU, not CCU. I thought all CICU patients are cardiology as far as sending service is concerned. Not so? See further up, "If a patient occupying a STB MICU bed remains under MICU coverage their entire stay, there is no need to make a tmp entry for CCU Service at all. " Or is that one ''actually'' talking CCU? Is that where I am getting confused, is that acronym used in multiple ways? - Ttenbergen 10:17, 2016 March 31 (CDT)

== Start/End Dates ==

*Start: 2015-Jun-01

** added data back from Oct 1, 2010

*End: ~~there is no planned end date~~

*End: July 7, 2016 (we moved to using [[Previous Service field]]

=== pre-start data===

*Julie will go back to October 2010 to make all the profiles reflect the new method of tracking CCU service (previously had made another profile when the service changed, (ie start under cardiology then another profile if MICU took over care). This will be fixed for the sake of consistency of data.--[[User:LKolesar|LKolesar]] 13:37, 2015 August 11 (CDT)

** Done (07Aug2015) and all the patients under Cardiology service with admit dates from Oct 1, 2010 to May 31, 2015 are appended in L_TmpV2 table of CFE. Included are those with whole stay at MICU under Cardiology service (N=586) and the 13 cases found with partial stay under Cardiology service (i.e. they have 2 records in L_TmpV where the first one denotes the CCU service and the second one is the change to MICU service). [[User:JMojica|JMojica]] 17:00, 2015 August 11 (CDT)

=={{CCMDB Data Integrity Checks}}==

==CCMDB Data Integrity Checks==

* query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any

* query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time)

Line 37:

Line 43:

== SAS Program ==

* The data is saved in table L_TmpV2 under project 'CCU Service' of the centralized_data.mdb

* The SAS program that reads the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas

* The SAS program that reads the data is in {{S:\MED\MED_CCMED}}Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas

== Details ==

STB/MICU -Merged files

== ~~See also~~ ==

We had 13 patients edited manually - combined to one admission (CCU in MICU under CCU care then transferred to MICU service. instead of having 2 admission in MICU, made it one. The CCU Service Tracking in TMP had been updated due to these changes (i.e. two rows containing ITEM=CCU and start date_time=admit date_time in CCU service as well as ITEM=MICU and start date_time=admit date_time in MICU service were added for each D_ID).

~~STB/~~MICU ~~Location changing "PtType" from Medical to Cardiac~~.

~~We had 7 patients edited manually~~**

*STB_MICU-26117

* ~~Serial#~~STB_MICU-28043

**Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-26128.

* ~~Serial#~~STB_MICU-28205

*STB_MICU-26611

* ~~Serial#~~STB_MICU-28233

**Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26611 and deleted STB_MICU-26626

* ~~Serial#~~STB_MICU-28330

*STB_MICU-26683

* ~~Serial#~~STB_MICU-28629

**Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26683 and deleted STB_MICU-26695

* ~~Serial#~~STB_MICU-28727

*STB_MICU-27144

* ~~Serial#~~STB_MICU-28884

**Merged into one all tables except old tiss in July 23, 2015. Old tiss fixed and added May 10, 2017. Kept 26117 and deleted STB_MICU-27161

[[User:PTorres|PTorres]] 10:02, 2015 October 2 (CDT)

*STB_MICU-27861

*No new process needed these was old edit and only put now so we have record.

**Merged into one July 23, 2015. Kept 27861 and deleted STB_MICU-27876

*STB_MICU-27917

**Merged into one July 23, 2015. Kept 27917 and deleted STB_MICU-27930

*STB_MICU-28043

**Merged into one July 23, 2015. Kept 28043 and deleted STB_MICU-28048

*STB_MICU-28205

**Merged into one July 23, 2015. Kept 28205 and deleted STB_MICU-28216

*STB_MICU-28233

**Merged into one July 23, 2015. Kept 28233 and deleted STB_MICU-28244

*STB_MICU-28330

**Merged into one July 23, 2015. Kept 28330 and deleted STB_MICU-28340

*STB_MICU-28629

**Merged into one July 23, 2015. Kept 28629 and deleted STB_MICU-28652

*STB_MICU-28727

**Merged into one July 23, 2015. Kept 28727 and deleted STB_MICU-28741

*STB_MICU-28884

**Merged into one July 23, 2015. Kept 28884 and deleted STB_MICU-28901

--[[User:PTorres|PTorres]] 10:02, 2015 October 2 --(CDT)[[User:PTorres|PTorres]] 16:54, 2017 May 10 (CDT)

@@ Line 1: / Line 1: @@
-'' for tracking which service sent to an ICU, see [[Service Sending to ICU]] instead
+{{Project
+|ProjectActive=legacy
+|ProjectProgram=CC
+|ProjectRequestor=Unknown/legacy
+|ProjectCollectionStartDate=2010-10-01
+|ProjectCollectionStopDate=2016-07-07
+|Project=CCU Service Tracking
+}}
+{{LegacyContent
+|explanation=was replaced as part of [[2016 Time and Place changes]]
+|successor=[[Previous Service field]]
+|content=
 == Purpose ==
@@ Line 5: / Line 16: @@
 == Data Collection Instructions ==
-For patients occupying a STB MICU bed, that during their stay in MICU have been under Cardiology Service at any time, enter the service they are admitted under. If the service changes during the stay, enter a new tmp entry for the new service as well.
+For patients occupying a STB MICU or CICU bed and have been under Cardiology Service (as opposed to Cardiac Surgery) at any time, enter the service they are admitted under in tmp. If the service changes during the stay, enter a new tmp entry for the new service as well.
-If a patient occupying a STB MICU bed remains under MICU coverage their entire stay, there is no need to make a tmp entry for CCU Service at all.
+If a patient occupying a STB MICU or CICU bed remains under their own service coverage their entire stay, there is no need to make a tmp entry for CCU Service at all.
 Use tmp fields:
 * Project: '''CCU_Service'''
-* Item: '''CCU''' or '''MICU'''
+* Item: '''CCU''' or '''MICU''' or '''CICU'''
 * start_dt: '''date of service change'''
 * start_tm: '''time of service change'''
 ** If the pt arrives under Cardiology (CCU) service the date and time for this tmp entry will be the same as the admission date and time to MICU.
-=== should this be available for collection for CCU as well ===
-{{discussion}}
-* Received request from Julie/Laura to add ability to collect this to CCU laptop. Waiting for clarification because I thought all of CCU was cardiology, so there would be no need to collect this. Ttenbergen 18:50, 2016 March 25 (CDT)
-**CICU was the request (not CCU).  CICU is the Surgical ICU for Cardiac Surgery.  Pt type usually in this unit is "surgery".  We need the option of using CCU tracking in this unit because, at times, this is where they are put when MICU is full.  CCU currently cannot take patients that have IABP's or are intubated so, when this happens, they have to be located in one of the ICU's at STB (either MICU or CICU).  FYI:  a new CCU is being built that will accommodate these types of patients.  (The estimated time of this unit opening is June 2016).--[[User:LKolesar|LKolesar]] 09:23, 2016 March 29 (CDT)
-*** Sorry, I meant CICU, not CCU. I thought all CICU patients are cardiology as far as sending service is concerned. Not so? See further up, "If a patient occupying a STB MICU bed remains under MICU coverage their entire stay, there is no need to make a tmp entry for CCU Service at all. " Or is that one ''actually'' talking CCU? Is that where I am getting confused, is that acronym used in multiple ways? - Ttenbergen 10:17, 2016 March 31 (CDT)
 == Start/End Dates ==
 *Start: 2015-Jun-01
 ** added data back from Oct 1, 2010
-*End: there is no planned end date
+*End: July 7, 2016 (we moved to using [[Previous Service field]]
 === pre-start data===
 *Julie will go back to October 2010 to make all the profiles reflect the new method of tracking CCU service (previously had made another profile when the service changed, (ie start under cardiology then another profile if MICU took over care). This will be fixed for the sake of consistency of data.--[[User:LKolesar|LKolesar]] 13:37, 2015 August 11 (CDT)
 ** Done (07Aug2015) and all the patients under Cardiology service with admit dates from Oct 1, 2010 to May 31, 2015 are appended in  L_TmpV2 table of CFE. Included are those with whole stay at MICU under Cardiology service (N=586) and the 13 cases found with partial stay under Cardiology service  (i.e. they have 2 records in L_TmpV where the first one denotes the CCU service and the second one is the change to MICU service). [[User:JMojica|JMojica]] 17:00, 2015 August 11 (CDT)
-=={{CCMDB Data Integrity Checks}}==
+==CCMDB Data Integrity Checks==
 * query ''s_tmp_CCU_Service_shouldntve'' - no pt not STB_MICU can have any
 * query ''s_tmp_CCU_Service_twins'' - can't have two entries that are the same (ie same service and time)
@@ Line 37: / Line 43: @@
 == SAS Program ==
 * The data is saved in table L_TmpV2 under project 'CCU Service' of the centralized_data.mdb
-* The SAS program that reads the data is in X:\Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas
+* The SAS program that reads the data is in {{S:\MED\MED_CCMED}}Julie\SAS_CFE\CFE_macros\CFE_CCUServiceTracking.sas
+== Details ==
+STB/MICU -Merged files
-== See also ==
+We had 13 patients edited manually - combined to one admission  (CCU in MICU under CCU care then transferred to MICU service. instead of having 2 admission in MICU, made it one.  The CCU Service Tracking in TMP had been updated due to these changes (i.e. two rows containing  ITEM=CCU and start date_time=admit date_time in CCU service as well as  ITEM=MICU and start date_time=admit date_time in MICU service  were added for each D_ID).
-STB/MICU Location changing "PtType" from Medical to Cardiac.
-We had 7 patients edited manually**
+*STB_MICU-26117
-* Serial#STB_MICU-28043
+**Merged into one all tables except old tiss in July 23, 2015.  Old tiss fixed and added May 10, 2017.  Kept 26117 and deleted STB_MICU-26128.
-* Serial#STB_MICU-28205
+*STB_MICU-26611
-* Serial#STB_MICU-28233
+**Merged into one all tables except old tiss in July 23, 2015.  Old tiss fixed and added May 10, 2017.  Kept 26611 and deleted STB_MICU-26626
-* Serial#STB_MICU-28330
+*STB_MICU-26683
-* Serial#STB_MICU-28629
+**Merged into one all tables except old tiss in July 23, 2015.  Old tiss fixed and added May 10, 2017.  Kept 26683 and deleted STB_MICU-26695
-* Serial#STB_MICU-28727
+*STB_MICU-27144
-* Serial#STB_MICU-28884
+**Merged into one all tables except old tiss in July 23, 2015.  Old tiss fixed and added May 10, 2017.  Kept 26117 and deleted STB_MICU-27161
-[[User:PTorres|PTorres]] 10:02, 2015 October 2 (CDT)
+*STB_MICU-27861
-*No new process needed these was old edit and only  put now so we have record.
+**Merged into one July 23, 2015.  Kept 27861 and deleted STB_MICU-27876
+*STB_MICU-27917
+**Merged into one July 23, 2015.  Kept 27917 and deleted STB_MICU-27930
+*STB_MICU-28043
+**Merged into one July 23, 2015.  Kept 28043 and deleted STB_MICU-28048
+*STB_MICU-28205
+**Merged into one July 23, 2015.  Kept 28205 and deleted STB_MICU-28216
+*STB_MICU-28233
+**Merged into one July 23, 2015.  Kept 28233 and deleted STB_MICU-28244
+*STB_MICU-28330
+**Merged into one July 23, 2015.  Kept 28330 and deleted STB_MICU-28340
+*STB_MICU-28629
+**Merged into one July 23, 2015.  Kept 28629 and deleted STB_MICU-28652
+*STB_MICU-28727
+**Merged into one July 23, 2015.  Kept 28727 and deleted STB_MICU-28741
+*STB_MICU-28884
+**Merged into one July 23, 2015.  Kept 28884 and deleted STB_MICU-28901
+--[[User:PTorres|PTorres]] 10:02, 2015 October 2 --(CDT)[[User:PTorres|PTorres]] 16:54, 2017 May 10 (CDT)
 see also [[STB Cardiac Care patients]]
+{{Data Integrity Check List|}}
-[[Category: St Boniface Hospital Office (Critical Care)]]
+}}
-[[Category: Site Specific Collection Guide]]
+[[Category:L TmpV2 Data]]
-[[Category: L_TmpV2 Data]]
+[[Category:Legacy Overflow]]
-[[Category: Special Short Term Projects]]
-[[Category: All Projects ICU only]]