Service tmp entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
No edit summary
 
(27 intermediate revisions by 4 users not shown)
Line 7: Line 7:
}}
}}


This isn't so much a project as a change to [[Service/Location]] collection to allow us to collect more than one [[Service/Location]] per patient-program-stay. See [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] for why we needed to change to this.  
This data encodes which service is taking care of a patient. See [[Definition of a Critical Care Laptop Admission]] / [[Definition of a Medicine Laptop Admission]] for info on when a new profile should be started.  


== Data Collection Instructions ==
== Data Collection Instructions ==
Line 21: Line 21:
*Use tmp fields:
*Use tmp fields:
** project: '''Service'''
** project: '''Service'''
** item: '''no service entered''' is added by default to each new patient entered
** item: '''no service entered''' is added by default to each new profile entered
*** change this to the applicable service; this will be the service as listed in the [[Cognos Report Integrator]] tools (see [[s_Cognos_Services table]] for a list of applicable services).
*** change this to the applicable service; this will be the service as listed in the [[Cognos Report Integrator]] tools (see [[s_Cognos_Services table]] for a list of applicable services).
**select the appropriate service from the dropdown list
**select the appropriate service from the dropdown list


==== DtTm to use ====
==== DtTm to use ====
* date: '''Service Start DtTm''' date as per collector best estimate
* Edit the Service Start DtTm in the [[Patient Viewer Tab Cognos ADT2]]
* time: '''Service Start DtTm''' time as per collector best estimate
* If you are changing the Service Start DtTm, please check to make sure that the [[Visit Admit DtTm]] is either before or the same as the Service Start DtTm
** the '''first Service Start DtTm'''  must be the same as [[Accept DtTm]], if that field is required to be filled for this profile
* value is initially entered in [[CSS]] as per [[Using Cognos2 to keep track of patients]]
 
* once patient is discharged, set as per [[Definition of a Critical Care Laptop Admission]] or [[Definition of a Medicine Laptop Admission]]; except if within 30 min of time in Cognos, use Cognos time <!-- as per ICU Database Task Group Meeting – April 15, 2021 #4 -->
* set as per [[Definition of a Critical Care Laptop Admission]] or [[Definition of a Medicine Laptop Admission]]
** at this point also update the first [[Boarding Loc]] DtTm as per [[DtTm for First Boarding Loc and First Service]]
* Enter the Service Start DtTm in the [[Patient Viewer Tab Cognos ADT2]]; you can click on this DtTm to automatically populate it into the [[Accept_DtTm field]]
* {{First Service and Boarding Loc same}}
 
{{Discuss |
* Are the following actually specific to STB or are they general instructions? Are some of them still required now that we are unifying the definition of the two fields?
** at the last task meeting I was at, it was agreed that each hospital would enter the dates/times that are most accurate.  We were asked to say on the WIKI what we are doing at each site, so this is what is written here.  It is my belief that HSC still uses Cognos for their date/time entries.  And yes, these instructions would be required for the single field entries. [[Accept DtTm]] {{=}} [[Service tmp entry]] start time & [[Arrive DtTm]] {{=}} [[Boarding Loc]] time
*** OK, I think there has been further discussion of this since...
----
*at StB, the [[Accept DtTm]] for ICU patients coming from ER is taken from the orders.  If the time is written after the patient has already arrived to the ICU, the [[Accept DtTm]] is the same time as the arrive time
* at STB, the ICU team is considered as having accepted the patient when they arrive on the scene if the patient is successfully resuscitated and goes to a unit
* at STB, if the patient is coming from the Cath Lab, or the OR, the [[Accept DtTm]] and arrive time will be the same as this is when they are considered to have assumed care of the patient.  This time is obtained from the ICU flowsheet.
}}


=== Direct Admissions/Transfers ===
For patients who have been accepted from another hospital '''but have a wait time in ER''' (who used to be called Direct Admissions/Parked in ER), use the [[Visit Admit DtTm]] shown in [[Patient Viewer Tab Cognos ADT2]].


{{Todo
| who = Tina
| question = 
* Since that's already available in ADT2 tab, should we have a way to click to fill this date into the Service DtTm? It would likely be a button on each line that would set that line's dt and tm to the relevant parts of the single field [[Visit Admit DtTm]]. [[User:Ttenbergen|Ttenbergen]] 10:55, 2021 April 29 (CDT)
** that would be great! [[User:Lkaita|Lisa Kaita]] 20:04, 2021 April 30 (CDT)
| todo_added = 2021 April 30
| todo_action =
}}


=== When does collection start? ===
==== Code Blue ====
see
See [[Definition_of_a_Critical_Care_Laptop_Admission#From_Code_Blue]] for when a profile should start in case of a code blue.
* [[Definition of a Critical Care Laptop Admission]]
* [[Definition of a Medicine Laptop Admission]]


==== Specifically for STB Critical Care ====
'''Special rules apply to [[STB CICU Admissions start at Arrive DtTm]] '''


==== Item - Special instruction for HSC Critical Care ====
*at StB, the Service tmp date and time for ICU patients coming from ER is taken from the orders.  If the time is written after the patient has already arrived to the ICU, the Service tmp date and time is the same time as the [[Boarding Loc]] time
HSC Critical Care services (''except "HSC Critical Care / Intermediate", which is entered as is)'' should be entered as "HSC Critical Care - MICU", "HSC Critical Care - SICU".
* if the patient is coming from the Cath Lab, or the OR, the time is obtained from the ICU flowsheet


For HSC MICU, COGNOS generally lists the service as Critical Care Medicine, on occasion other services will be listed eg. Critical Care internal medicine A, or Critical care Respiratory etc but this is usually followed by a second entry that is Critical Care Medicine. These should be changed to HSC Critical Care-MICU.
=== Direct Admissions/Transfers ===
 
For patients who have been accepted from another hospital '''but have a wait time in ER''' (who used to be called Direct Admissions/Parked in ER), use the [[Visit Admit DtTm]] shown in [[Patient Viewer Tab Cognos ADT2]]. You can use the [["VA" button]] to fill it in.
For HSC SICU, COGNOS generally lists the service as "Critical Care" followed by a surgical service, for eg. Critical Care Acute Care Trauma, Critical Care Neurosurgery, Critical Care Thoracic Surgery, Critical Care Orthopedics etc. These should be changed to HSC Critical Care - SICU.
 
There are a few services that can be mapped to either HSC Critical Care MICU or HSC Critical Care SICU
 
*HSC Critical Care / Adult General
*HSC Critical Care / Amputee
*HSC Critical Care / General
*HSC Critical Care / Intensive Care
*HSC Critical Care / Obstetrics
*HSC Critical Care / Oncology
 
These will require further investigation by reading through the chart or EPR documents before you make the decision to map it to HSC Critical Care-MICU or HSC Critical Care-SICU


=== Which service to use when several are listed for the same timeframe ===
=== Which service to use when several are listed for the same timeframe ===
Occasionally Cognos may list several services with the same dttm. See [[Process for bad data in Cognos]].
Use what you know to be correct from chart and your knowledge of your hospital.


{{Data Integrity Check List}}
{{Data Integrity Check List}}


== Data Use ==
== Data Use ==
Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.
This data is used to facilitate [[Using Cognos2 to keep track of patients]].  


== SAS Program ==
== Legacy / Background ==
 
This isn't so much a project as a change to [[Service/Location]] collection to allow us to collect more than one [[Service/Location]] per patient-program-stay. See [[Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry]] for why we needed to change to this.
== Background ==
We initially planned to change to a single profile per program collection mode, but then gradually reverted to a single profile per service for all critical care profiles.


==Related articles ==
==Related articles ==

Latest revision as of 11:47, 2024 February 22

Projects
Active?: active
Program: CC and Med
Requestor: internal
Collection start: 2020-10-15
Collection end:

This data encodes which service is taking care of a patient. See Definition of a Critical Care Laptop Admission / Definition of a Medicine Laptop Admission for info on when a new profile should be started.

Data Collection Instructions

You can use the "Make Service" button in Patient Viewer Tab Cognos ADT2 to generate and populate these entries.

How to enter this

Add an additional entry for service only if the service changes during their stay.

Example:   
  • E.G. patient X is in the ER and is accepted by HSC A medicine on Oct 15,2020@0900, On Oct 17,2020 @1500 HSC H medicine takes over his care
  • in the TMP select Project Service, Item choose HSC A medicine, column E enter Oct 15,2020, Column M enter 0900
  • second entry in TMP would be project Service, Item choose HSC H medicine, Column E enter Oct 17,2020, Column M enter 1500
  • Use tmp fields:
    • project: Service
    • item: no service entered is added by default to each new profile entered
    • select the appropriate service from the dropdown list

DtTm to use


Code Blue

See Definition_of_a_Critical_Care_Laptop_Admission#From_Code_Blue for when a profile should start in case of a code blue.

Specifically for STB Critical Care

Special rules apply to STB CICU Admissions start at Arrive DtTm

  • at StB, the Service tmp date and time for ICU patients coming from ER is taken from the orders. If the time is written after the patient has already arrived to the ICU, the Service tmp date and time is the same time as the Boarding Loc time
  • if the patient is coming from the Cath Lab, or the OR, the time is obtained from the ICU flowsheet

Direct Admissions/Transfers

For patients who have been accepted from another hospital but have a wait time in ER (who used to be called Direct Admissions/Parked in ER), use the Visit Admit DtTm shown in Patient Viewer Tab Cognos ADT2. You can use the "VA" button to fill it in.

Which service to use when several are listed for the same timeframe

Use what you know to be correct from chart and your knowledge of your hospital.

Data Integrity Checks (automatic list)

 AppStatus
Query check CCI vs LOS count days picklistCCMDB.accdbimplemented
Query check tmp 2 BL TR S same tmCCMDB.accdbimplemented
Query check CCI TISS Pharm VasoactiveCCMDB.accdbimplemented
Check duplicate patientCCMDB.accdbimplemented
Query s tmp Boarding Loc date itemCCMDB.accdbimplemented
Query check CCI DateCCMDB.accdbimplemented
Query check ICD10 dateCCMDB.accdbimplemented
Query check no consecutive same BL or ServiceCCMDB.accdbimplemented
Query check minimal data set incompleteCCMDB.accdbimplemented
Query check CCI vs LOS count days componentCCMDB.accdbimplemented
Query check tmp Boarding Loc Service first sameCCMDB.accdbimplemented
Query check CCI TISS NrDays LT LOSCCMDB.accdbimplemented
Query check CCI TISS NrDays GT LOSCCMDB.accdbimplemented
Query check tmp Service and Boarding Loc during admission timeframeCCMDB.accdbimplemented
Query check tmp service and program consistencyCCMDB.accdbimplemented
Query check tmp service or location duplicateCCMDB.accdbimplemented
Query check CCI CXR vs LOSCCMDB.accdbneeds review

Data Use

This data is used to facilitate Using Cognos2 to keep track of patients.

Legacy / Background

This isn't so much a project as a change to Service/Location collection to allow us to collect more than one Service/Location per patient-program-stay. See Change from Service Location to Service, Boarding Loc and Transfer Ready DtTm tmp entry for why we needed to change to this. We initially planned to change to a single profile per program collection mode, but then gradually reverted to a single profile per service for all critical care profiles.

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Service_tmp_entry&oldid=160847"