Service tmp entry: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m Text replacement - "Cognos SubServices table" to "s_Cognos_Services table"
mNo edit summary
Line 31: Line 31:
*second entry in TMP would be '''project Service''', '''Item''' choose HSC H medicine, Column E enter Oct 17,2020, Column M enter 1500
*second entry in TMP would be '''project Service''', '''Item''' choose HSC H medicine, Column E enter Oct 17,2020, Column M enter 1500
  }}
  }}
=== Which service to use when several are listed for the same timeframe ===
{{Discuss | who = Julie |
* 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)
** I'd like that, too. The problem is SICU - AFAIK they are an "open unit" so all sorts of services play there, and therefore show up in Cognos. I made a list that reflects Cognos. We should bring this up to Julie to see what she needs, we might be able to get away with what you suggest. I will flag this for Julie, but if it isn't dealt with by the time the next task meeting comes around, please bring it up then. Ttenbergen 23:32, 2020 October 18 (CDT)
}}


== Loose ends ==
== Loose ends ==
Line 36: Line 42:
{{DT |  
{{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.
* 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.
}}
{{Discuss | who = Julie |
* 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)
** I'd like that, too. The problem is SICU - AFAIK they are an "open unit" so all sorts of services play there, and therefore show up in Cognos. I made a list that reflects Cognos. We should bring this up to Julie to see what she needs, we might be able to get away with what you suggest. I will flag this for Julie, but if it isn't dealt with by the time the next task meeting comes around, please bring it up then. Ttenbergen 23:32, 2020 October 18 (CDT)
}}
}}


=== Facilitate viewing and entering Service tmp ===
=== Facilitate viewing and entering Service tmp ===
{{Discuss |
It might be easier to enter these if we were able to see Cognos data for [[Service tmp entry]] separately from [[Boarding Loc]]. I am working on a [[Cognos2]] setup for this, more to come.  
* should be able to add something to [[Cognos Admitter]] and [[Patient Viewer Tab Cognos ADT]] that facilitates entering and viewing this; will delay that until we have collected this for a little while; 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. And if we can stop entering Accept and Arrive, and service location becomes trivial we can safe space.  
{{TT | when I get [[Cognos2]] set up I will need to clean this out }}
The thing is, that tab is getting very full, and I will need to either make fonts smaller or squeeze an area to show even fewer lines. I wonder how best to do that in a way that works for collectors. It’s on the “later” pile for now, but for sure something I want to deal with. Open to suggestions. Ttenbergen 12:24, 2020 October 16 (CDT)
}}


== data checks ==
== data checks ==

Revision as of 09:11, 5 November 2020

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

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.

Data Collection Instructions

  • Are we adding the date and time that each service takes over? Where do we find this information on EPR? (blezak)
    • Good point. The data is in the Cognos Admitter; what was the "Accept DtTm equiv" and only visible if pt came from ER is now the Service Start DtTm, and always visible. Change is in v2020-10-21-1. If that answers the question, please remove the discussion. If not, please elaborate. Ttenbergen 18:15, 2020 October 21 (CDT)
  • SMW


  • Cargo


  • Categories

How to enter this

  • Use tmp fields:
    • project: Service
    • item: no service entered is added by default to each new patient entered
    • select the appropriate service from the dropdown list
    • date: Service Start DtTm date as per Cognos EPR Report
    • time: Service Start DtTm time as per Cognos EPR Report
      • for pts coming from ER this dttm will be the same as Accept DtTm, but we want it for non-ER pts as well
      • the first entry for Boarding Loc and for Service tmp entry need to have the same date and time because we only care about the portion of time in that earliest location that was under our service. So, e.g. if in ER the pt is accepted initially by surgery we don't care about the unit start date and time until our service takes over.

Add a new 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

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

  • 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.Mlagadi 09:01, 2020 October 16 (CDT)
    • I'd like that, too. The problem is SICU - AFAIK they are an "open unit" so all sorts of services play there, and therefore show up in Cognos. I made a list that reflects Cognos. We should bring this up to Julie to see what she needs, we might be able to get away with what you suggest. I will flag this for Julie, but if it isn't dealt with by the time the next task meeting comes around, please bring it up then. Ttenbergen 23:32, 2020 October 18 (CDT)
  • SMW


  • Cargo


  • Categories

Loose ends

None of these are show-stoppers, just some notes on future improvements.

  • 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.
  • SMW


  • Cargo


  • Categories

Facilitate viewing and entering Service tmp

It might be easier to enter these if we were able to see Cognos data for Service tmp entry separately from Boarding Loc. I am working on a Cognos2 setup for this, more to come.

when I get Cognos2 set up I will need to clean this out

  • added: no added date
  • action: no action date
  • Cargo


  • Categories

data checks

  • add a cross check to make sure this is not left as "no service entered"
  • SMW


  • Cargo


  • Categories

Data Integrity Checks (automatic list)

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

Data Use

Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.

SAS Program

Background

Related articles

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