Previous Location field

From CCMDB Wiki
Jump to navigation Jump to search
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 of a patient before arriving at the collection location.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


For exceptions, see

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 location missing/unknown

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.

For wards where we don't collect, enter e.g. HSC_ward. For wards where we do collect enter the actual ward as available in the dropdown.

Example

For example, a patient arriving from Selkirk Hospital via the local ER would have the ER coded in the Previous Location field and Selkirk coded in the Pre-admit Inpatient Institution field.

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.

direct admit / transfer

see Direct admit / Parked in ER

from 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.

  • "We are aware that this may affect categorization under APACHE II but will collect like this for now. This will need to be dealt with when we move to ICD10." - Julie, I don't know what this comment is about, I just came across it when cleaning out things we need to take care of in going to ICD10. I can't think of what we would need to take care of here, if you can't either please take the comment out.
  • SMW


  • Cargo


  • Categories


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 2 different services (internal medicine, surgical, family medicine etc).

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

For patients from these units:

  • If patient is an internal medicine patient: enter the unit name (eg. VIC_S3)
  • If patient is not a internal medicine patient, enter the generic hospital ward (e.g. VIC Ward); this will allow you to enter the Previous Service field with a physician service other than "Medicine".

Patients from day surgery

For patients admitted from day surgery units, enter:

  • Previous Location - <your hospital> Ward, e.g. HSC Ward
  • Previous Service - General Surgery (or other surgical service listed in drop down.

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".

If applicable also code ICD10 Imprisonment/incarceration.

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)

 AppStatus
Check pre acute consistentCCMDB.accdbdeclined
Query check tmp ER Boarding Loc should exist if from ERCCMDB.accdbdeclined
Function Validate Previous LocationCCMDB.accdbimplemented
Query check prev pre-admit consistentCCMDB.accdbimplemented
Check function previous NE LocationCCMDB.accdbimplemented
Query check CCI from OR no CCICCMDB.accdbimplemented
Query check pt from ERCCMDB.accdbimplemented
Query check previous location vs service inconsistentCCMDB.accdbretired
Check Accept Loc ParkCCMDB.accdbretired
Query check VAP admit must be from ICUCCMDB.accdbretired
Link suspect mismatch from ours incomplete queryCentralized data front end.accdbimplemented
Link suspect not same visitAdmitDtTm queryCentralized data front end.accdbimplemented
Query cardiac arrest throughout admissionCentralized data front end.accdbneeds 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

Related articles

Related articles: