Previous Location field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
Line 33: Line 33:
If a patient '''changes programs''' (as in Critical Care vs medicine) while still in ER, use the previous service as the previous location. This is because we use "previous location" to link a hospital stay together, so the previous laptop would list this patient and we want to be able to connect.  
If a patient '''changes programs''' (as in Critical Care vs medicine) while still in ER, use the previous service as the previous location. This is because we use "previous location" to link a hospital stay together, so the previous laptop would list this patient and we want to be able to connect.  
{{Ex|
{{Ex|
A patient is collected on a laptop as an EMIP and then admitted to HSC Critical care while still in the ER. The Critical Care laptop would use "HSC_Med" as previous location. }}
A patient is collected on a laptop as an EMIP and then admitted to HSC Critical care while still in the ER. The Critical Care laptop would use "HSC_Med" as previous location and also as [[Pre-admit Inpatient Institution]]. }}


==== Data collection units that have a '''mix''' of different physician serve types ====  
==== Data collection units that have a '''mix''' of different physician serve types ====  

Revision as of 11:25, 27 July 2021

Data Element (edit)
Field Name: Previous_Location
CCMDB Label: Previous Location
CCMDB tab: Dispo
Table: L_Log table
Data type: number
Length: long integer
Program: Med and CC
Created/Raw: Raw
Start Date: 2016-07-01
End Date: 2300-01-01
Sort Index: 37
Data Dependencies(Reports/Indicators/Data Elements): No results

[[DataElementDescription::The most recent previous physical location (with #exceptions) of a patient before arriving at the collection location. ]]

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

For each patient,

  • enter the option that most closely matches:
  • if you know the situation but nothing on the list matches closely, enter other - known but not listed
  • if the situation is unknown, enter Not known

If you know the location exactly, you can type it. Otherwise press the "?" button to take you to the S dispo chooser‎ to help filter options if desired.

Borrowed Bed Or Pt Boarding On Other Unit

For direct transfers within the Winnipeg region, should we enter the Last Boarding Location as the Previous Location ? No because these are only temporary location. Use the service taking care of the patient : <site>_Med, <site>_CC, HSC_IICU, STB MICU, STB_ICCS, STB_ACCU.

"Can we remove the items that are no longer Service/Locations, Previous Locations, Pre-admit Inpatient Institutions or dispo locations from the dropdowns?"

We can and will remove them, but that can only happen once no more laptops use them. We will need to keep track of this and then remove them when ready. If I removed them now, then any box that currently has them enter would misbehave.

SQL query of what is currently available   
SELECT s_dispo.location_name, s_dispo.Site, s_dispo.active, s_dispo.inpatient, s_dispo.previous_location, s_dispo.s_location, s_dispo.dispo
FROM s_dispo
WHERE (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.inpatient)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.previous_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.s_location)=True)) OR (((s_dispo.Site)>"") AND ((s_dispo.active)=True) AND ((s_dispo.dispo)=True));
  • query of what is currently used: query z_s_dispo_inactivatable

Where to find this information

If patient came from a different Winnipeg hospital this should be recorded in the “Visit History” on the EPR, but sometimes it is missing. Can also use paper chart sent to your hospital from the sending hospital for information.

Exceptions

EMIPs/ECIPs changing services

If a patient changes programs (as in Critical Care vs medicine) while still in ER, use the previous service as the previous location. This is because we use "previous location" to link a hospital stay together, so the previous laptop would list this patient and we want to be able to connect.

Example:   

A patient is collected on a laptop as an EMIP and then admitted to HSC Critical care while still in the ER. The Critical Care laptop would use "HSC_Med" as previous location and also as Pre-admit Inpatient Institution.

Data collection units that have a mix of different physician serve types

We have a few units in the Region that have a mix of different services (internal medicine, surgical, family medicine etc).

  • HSC_B3 - is a mix of day surgery & internal medicine patients
  • any others?

For patients from these units:

  • If patient was an internal medicine there, enter <site>_Med
  • If not a internal medicine patient, enter the <site>_Ward

from HSC psych unit

Code patient from POU (pysch evaluation unit @ HSC) as "HSC ambulatory care" - it's not an inpatient ward.

Dialysis unit as previous location

For patient from Dialysis unit, use that unit as previous location. Pre acute living situation field would be the unit they came from right before, if applicable.

Heart Cath Lab vs OR as previous location

When a procedure (e.g valve replacement) is done in the cath lab before the pt arrives on your unit, enter Cath Lab if done in Cath Lab and put OR if done in OR.

Patients from day surgery

For patients admitted from day surgery units, enter:

this is wrong 
  • SMW


  • Cargo


  • Categories

Homeless Patients

If a homeless patient is admitted directly then code them as admitted from home. Usually they would be via ER, of course, and you'd code them as that.

If a patient is admitted from prison, jail or a correctional institution, code this as an admission from "Institution NOS".

See Prison / Jail / Correctional Institution for additional info.

Data Use

This data is used for tracking where most of the traffic on our units/wards comes from. For starters it will be reported to Critical Care (Randy Martin), who was also the requestor of this data.

Cross Checks

Data Integrity Checks (automatic list)

none found

Implementation

The field is populated with options from the s_dispo table.

Legacy

This field is part of the 2016 Time and Place changes.

It a combination of our previous

Related articles: