Previous Location field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
mNo edit summary
m (→‎Bed Borrows: tweak so template doesn't break)
Line 36: Line 36:


{{Discuss |  
{{Discuss |  
* In the event that both the bed and the service are borrowed: ie. STB MICU borrows a bed in CICU under CICU service then patient is transferred to STB medicine units-for the medicine profile does the Previous Location = Pre Admit Inpatient Institution ie. STB_MICU? Does previous service = Critical care in these instances?}}
* In the event that both the bed and the service are borrowed: ie. STB MICU borrows a bed in CICU under CICU service then patient is transferred to STB medicine units-for the medicine profile does the Previous Location mean Pre Admit Inpatient Institution ie. STB_MICU? Does previous service mean Critical care in these instances?}}


{{ex | MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as the previous location NOT SICU (which is the actual physical location). }}
{{ex | MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as the previous location NOT SICU (which is the actual physical location). }}

Revision as of 10:45, 2020 January 23

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

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 admitted to your Service Location came from one of our collection locations which was borrowing a bed elsewhere, i.e. not physically located there, then use the collection location as previous location, not the physical location.

  • In the event that both the bed and the service are borrowed: ie. STB MICU borrows a bed in CICU under CICU service then patient is transferred to STB medicine units-for the medicine profile does the Previous Location mean Pre Admit Inpatient Institution ie. STB_MICU? Does previous service mean Critical care in these instances?
  • SMW


  • Cargo


  • Categories
Example:   
MICU patient borrows a bed in SICU. The patient goes to D4. D4 should then put MICU as the previous location NOT SICU (which is the 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.

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

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

For patients from these units:

  • 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: