Previous Location field
| 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 |
The most recent previous physical location (with #exceptions) of a patient before arriving at the collection location.
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 the patient is in ER under a service we do not collect ie. cardiology, surgery etc use <site>_ER
If you know the location exactly, you can type it, otherwise click on the dropdown button to view the options
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, GH-CC, HSC_MICU, HSC_SICU, 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.
query of what is currently available
| SQL |
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
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:
- Previous Location - <site>_Ward, e.g. HSC Ward
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.
Prison / Jail / Correctional Institution
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)
| App | Status | |
|---|---|---|
| Check pre acute consistent | CCMDB.accdb | declined |
| Query check tmp ER Boarding Loc should exist if from ER | CCMDB.accdb | declined |
| Function Validate Previous Location | CCMDB.accdb | implemented |
| Query check prev pre-admit consistent | CCMDB.accdb | implemented |
| Check function previous NE Location | CCMDB.accdb | implemented |
| Query check CCI from OR no CCI | CCMDB.accdb | implemented |
| Query check pt from ER | CCMDB.accdb | implemented |
| Query check previous location vs service inconsistent | CCMDB.accdb | retired |
| Check Accept Loc Park | CCMDB.accdb | retired |
| Query check VAP admit must be from ICU | CCMDB.accdb | retired |
| Link suspect mismatch from ours incomplete query | Centralized data front end.accdb | implemented |
| Link suspect not same visitAdmitDtTm query | Centralized data front end.accdb | implemented |
| Query cardiac arrest throughout admission | Centralized data front end.accdb | needs review |
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