CCMDB Wiki

Service tmp entry: Difference between revisions

← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,815 edits
No edit summary
 
(89 intermediate revisions by 8 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 ==
You can use the [["Make Service" button]] in [[Patient Viewer Tab Cognos ADT2]] to generate and populate these entries.


=== 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 [[Cognos SubServices 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
 
==== DtTm to use ====
* Edit the Service Start DtTm in the [[Patient Viewer Tab Cognos ADT2]]
* 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
* value is entered from [[CSS]] as per [[Using Cognos2 to keep track of patients]]
* 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]]
 
=== 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.
* 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. 
 
==== Specifically for STB Critical Care ====
Special rules apply to [[STB CICU Admissions start at Arrive DtTm]].


{{Discuss|
=== Direct Admissions/Transfers ===
* What date and time are we attaching to this? Accept or Arrive? [[User:Surbanski|Surbanski]] 09:16, 2020 October 16 (CDT)
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.  
** It would be better to think of it as "the time the next service started (as per Cognos and also as per EPR)". For the first entry that should be the same as the [[Accept DtTm]], but for any further entries (and those are why we made this), they would NOT be the Accept DtTm. Ttenbergen 09:31, 2020 October 16 (CDT)
**I am not clear here - the first entry should be the start date of the current service  (same as Accept_DtTm) and not the time of next service start date?  The start of the next service would imply the end of the current (or prior) service. the difference between the next service start and current service start is the LOS  of the current service.  The last service start date will be subtracted to the DISPO date to get the LOS of the last service.  We should make it consistent with the Boarding loc which is based on arrive date. --[[User:JMojica|JMojica]] 10:03, 2020 October 16 (CDT)  }}


{{Discuss|
==== From Code Blue / [[Respiratory arrest]] ====
* Just to be clear and as an example for STB Med program a generic entry of STB_Med is entered into the [[Service/Location]] field on the Dispo page with a service location entry on the Tmp page?
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.  
* Yes. Ttenbergen 09:31, 2020 October 16 (CDT)}}


== Loose ends ==
{{Boarding Loc, Service content}}
None of these are show-stoppers, just some notes on future improvements.
{{DT |
* This project does might eventually replace [[ICUotherService]]; we will still need this item in the event that both the bed and the service are both borrowed. Administration at STB want this data.
}}
{{DT |
* should be able to add something to [[Cognos Admitter]] and [[Patient Viewer Tab Cognos ADT]] that facilitates entering this; will delay that until we have collected this for a few weeks; if we find these entries to be identical to Cognos data we might not need to enter them at all but instead import them directly, but not until we have checked consistency.
}}
{{DT|I am trying to enter my first critical care patient at HSC. There are multiple choices (dozens) for HSC critical care, and it is not evident which one I should be choosing. I think that it would be a lot more intuitive if the choices are limited to Critical Care-surgical, Critical Care-medical, and Critical care-Intermediate.[[User:Mlagadi|Mlagadi]] 09:01, 2020 October 16 (CDT) }}


== data checks ==
{{DT |
* add a cross check to make sure this is not left as "no service entered"
}}
{{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 ==
Line 56: Line 62:
[[Category:Overflow]]
[[Category:Overflow]]
[[Category:PatientFollow Project]]
[[Category:PatientFollow Project]]
[[Category:Cognos Report Integrator]]
[[Category:Admit/Discharge]]
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Service_tmp_entry"