Service tmp entry
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
You can use the "Make Service" button in Patient Viewer Tab Cognos ADT2 to generate and populate these entries.
How to enter this
- Use tmp fields:
- project: Service
- item: no service entered is added by default to each new patient 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).
- select the appropriate service from the dropdown list
DtTm to use
- 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 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.
- 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.
Example: |
|
- 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
- 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
- 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
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 Service tmp entry as it is clearly marked in the EPR.
![]() |
|
When does collection start?
see
Item - Special instruction for HSC Critical Care
There are two extra options "HSC Critical Care - MICU" and "HSC Critical Care - SICU" that should be used...
![]() |
|
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 Checks (automatic list)
App | Status | |
---|---|---|
Query check minimal data set incomplete | CCMDB.accdb | implemented |
Query check tmp service or location duplicate | CCMDB.accdb | implemented |
Query check tmp service and program consistency | CCMDB.accdb | implemented |
Query check tmp Service and Boarding Loc during admission timeframe | CCMDB.accdb | implemented |
Query check CCI TISS NrDays GT LOS | CCMDB.accdb | implemented |
Query check CCI TISS NrDays LT LOS | CCMDB.accdb | implemented |
Query check tmp Boarding Loc Service first same | CCMDB.accdb | implemented |
Query check CCI vs LOS count days component | CCMDB.accdb | implemented |
Query check CCI vs LOS count days picklist | CCMDB.accdb | implemented |
Query check no consecutive same BL or Service | CCMDB.accdb | implemented |
Query check ICD10 date | CCMDB.accdb | implemented |
Query check CCI Date | CCMDB.accdb | implemented |
Query s tmp Boarding Loc date item | CCMDB.accdb | implemented |
Check duplicate patient | CCMDB.accdb | implemented |
Query check CCI TISS Pharm Vasoactive | CCMDB.accdb | implemented |
Query check tmp 2 BL TR S same tm | CCMDB.accdb | implemented |
Data Use
Critical care and Medicine programs want to know this to better understand patient flow and bed utilization.