Previous Location field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
(→‎Bed Borrows: Previous Location exception -bed borrow)
Line 33: Line 33:
=== Exceptions ===
=== Exceptions ===
==== Bed Borrows ====
==== Bed Borrows ====
If a patient is admitted to from of our collection locations but was borrowing a bed elsewhere, i.e. not physically located there, then '''use the collection location''' as previous location, not the physical location.  
If a patient is '''admitted to''' from of one of our collection locations but was borrowing a bed elsewhere, i.e. not physically located there, then '''use the collection location''' as previous location, not the physical location.  
{{ex | MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as their previous location NOT SICU (which is their actual physical location). }}
{{ex | MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as their previous location NOT SICU (which is their actual physical location). }}


Revision as of 16:10, 2019 April 25

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 (except #Bed Borrows) 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.

Exceptions

Bed Borrows

If a patient is admitted to from of one of our collection locations but was borrowing a bed elsewhere, i.e. not physically located there, then use the collection location as previous location, not the physical location.

Example:    
MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as their previous location NOT SICU (which is their actual physical location).

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

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)

 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:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Previous_Location_field&oldid=136555"