CCMDB Wiki

Service tmp entry: Difference between revisions

← Older edit
Ppiche (talk | contribs)
CCMDB_legit
1,641 edits
No edit summary
 
(48 intermediate revisions by 5 users not shown)
Line 4: Line 4:
|ProjectRequestor=internal
|ProjectRequestor=internal
|ProjectCollectionStartDate=2020-10-15
|ProjectCollectionStartDate=2020-10-15
|Project=Boarding Loc
|Project=Service tmp
}}
}}


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 Program Admission]] / [[Definition of a Medicine Program Admission]] for info on when a new profile should be started.  


== Data Collection Instructions ==
== Data Collection Instructions ==
Line 13: Line 13:


=== How to enter this ===
=== How to enter this ===
Add an additional entry for service only if the service changes during their stay. (see [[#Which service to use when several are listed for the same timeframe]] below.
{{Ex |
*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:
*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 [[Cognos EPR Report]]
* Edit the Service Start DtTm in the [[Patient Viewer Tab Cognos ADT2]]
** time: '''Service Start DtTm''' time as per [[Cognos EPR Report]]
* If you are changing the Service Start DtTm, make sure that the [[Visit Admit DtTm]] is either before or the same as the Service Start DtTm
*** for pts coming from ER this dttm will be the same as [[Accept DtTm]], but we want it for non-ER pts as well
* value is entered from [[CSS]] as per [[Using Cognos2 to keep track of patients]]
*** the '''first Service Start DtTm''' must be the same as admission date and time  either [[Accept DtTm]] or [[Arrive DtTm]] as per [[Definition of a Critical Care Laptop Admission]] or [[Definition of a Medicine Laptop Admission]].
* for the '''first''' [[Service tmp entry]] per admission: once patient is discharged and before setting [[RecordStatus]] to "complete", update as per [[DtTm for First Boarding Loc and First Service]]
* the Service may start after the first [[Boarding Loc]], since a patient may well already be in a location when a service takes over ( see [[Boarding_Loc#Why_do_we_use_the_actual_unit_start_dttm_rather_than_the_time_they_became_our_pt_on_a_unit]] for more info)


Add an additional entry for service only if the service changes during their stay.
=== Which service to use when several are listed for the same timeframe ===
{{Ex |
* use what you know to be correct from chart and your knowledge of your hospital.
*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
* exclude services that are not relevant to the current admission, or are an obvious entry error ie. if there are two service entries for an ICU admission that are one minute apart, but one is HSC critical care general surgery and the other is just HSC general surgery, exclude the HSC general surgery service as this is not an ICU service. 
*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
}}


*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]]
==== Specifically for STB Critical Care ====
*at StB, the accept 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 accept time is the same time as the arrive time
Special rules apply to [[STB CICU Admissions start at Arrive DtTm]].
* 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 time 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 ===
=== 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 ID date and time for the {{PAGENAME}} as it is clearly marked in the EPR.
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.
{{Discuss |
* Is the Visit ID date and time in EPR the same as the [[Visit Admit DtTm]]? If so, that's already available in ADT2 tab, so would be easiest to grab from there. I could even set up CCMDB to have a button in the tmp lines to drag the time in from that field.
** Yes, the same thing, but not sure what you mean by dragging the time, could collectors click on it?
 
}}
 
=== When does collection start? ===
see
* [[Definition of a Critical Care Laptop Admission]]
* [[Definition of a Medicine Laptop Admission]]


==== From Code Blue / [[Respiratory arrest]] ====
See [[Definition of a Critical Care Program Admission#From Code Blue / Respiratory arrest]] for when a profile should start in case of a code blue.


==== Item - Special instruction for HSC Critical Care ====
{{Boarding Loc, Service content}}
There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...
{{Discuss | who = Julie |
* When should the new options be used rather than the other service entries for HSC?
**if I understand it correctly, when the list of these services appear in Cognos, since they do not map well to MICU or SICU, the DC must specified which service is appropriate : MICU or SICU.  In reporting, I need to separate the data belonging to MICU and SICU service.  If you would like to add "HSC Critical Care - MICU" and "HSC Critical Care - SICU", we need to add them to s_Cognos_Services.xlsx
***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
**::: - --[[User:JMojica|JMojica]] 14:18, 2021 April 6 (CDT)
* if you mean [[S Cognos Services table]] then I am not sure we really need to add them there... that is the list of services that come in from Cognos, and these don't come in from Cognos. Actually, what we would need to do is make sure we remove the ambiguous items that came via Cognos into the s_tmp table that we don't want people to use any longer, so that people are forced to instead use our made up ...SICU and ...MICU ones. Julie and Tina might need to discuss this in our questions meeting on Thursday.
}}
 
=== 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]].


{{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 ==
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Service_tmp_entry"