Previous Location field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
JMojica (talk | contribs)
CCMDB_legit, admin, approved, Administrators
2,787 edits
No edit summary
 
(24 intermediate revisions by 4 users not shown)
Line 1: Line 1:
{{DISPLAYTITLE:Previous_Location field}}
{{Data_element
{{Data_element
| field_name = Previous_Location
| field_name = Previous_Location
Line 17: Line 18:
* enter the option that most closely matches:  
* enter the option that most closely matches:  
{{PrePrevDispo listing}}
{{PrePrevDispo listing}}
* if the patient is a direct admission use <site>_UC, <Site>_ER, <site>_ward, <site>_Med, <site>_ICU or temporary location depending on the scenario (see direct admit scenarios below)
* if you know the situation but nothing on the list matches closely, enter '''other - known but not listed'''
* 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 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 the patient is in ER under a service we do not collect ie. cardiology, surgery etc use <site>_ER
{{DL | what is the [[Pre-admit Inpatient Institution]] entry for this case? --[[User:JMojica|JMojica]] 13:37, 29 July 2025 (CDT)
* That is what we need to decide we should probably keep it consistent with EMIP concept, however, for SICU we generally disregard the surgical service (when in ER) unless they were truly an inpt on a ward [[User:Lkaita|Lisa Kaita]] 13:59, 30 July 2025 (CDT)}}
If you know the location exactly, you can type it, otherwise click on the dropdown button to view the options


If you know the location exactly, you can type it, otherwise click on the dropdown button to view the options
=== 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.


=== Borrowed Bed Or Pt Boarding On Other Unit ===
=== 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.
* Use the [[Boarding Loc]] of the service taking care of the patient:<site>_Med, GH-CC, HSC_MICU, HSC_SICU, HSC_IICU, STB MICU, STB_ICCS, STB_ACCU.
{{Discuss| To clarify for LAU inpatients ie. Oak, Conc, Vic, etc. often will be transferred to the facility UC for stabilization and sometimes be returned to originating unit in the LAU facility or will transfer out to STB ER for further assessment or as a direct to STB ER or a STB med unit. In the direct scenarios is the previous location coded as the LAU inpatient unit or the LAU UC? Thanks! ````
{{Discuss|
* Does LUA mean Lower Acuity Unit?  It is not specifically listed in the dispo table - can we consider it as '''generic <site> ward'''?  If LAU is an inpatient location, maybe the choice  for preadmit inpt location is '''<site> Ward'''  and the previous location is '''STB ER''' if transfer out to STB ER or '''STB Med''' if direct transfer to STB Med  or '''<site> ward''' if returning back to the LAU facility. --[[User:JMojica|JMojica]] 11:38, 2024 February 26 (CST)
* for consistency, should this also use the [[Template:PrePrevDispo listing]]? Actually, what does this even mean for previous location? And what do you do if the patient comes from med?
}}
}}
{{Location dropdown cleanup}}


=== Where to find this information ===
=== Direct Admit Scenarios ===  
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.
*inpatients from CON, OAK, VIC who are direct transfers to HSC/STB/GRA, the [[Pre-admit Inpatient Institution]] and [[Previous Location]] will be <site>_ward, even if the patient spends time in that site's UC prior to transfer. If not yet an inpatient from CON/OAK/VIC and transfer is from their UC, then previous location is the <site>_UC. 
*For direct transfers from HSC/STB/GRA, if an inpatient, and no in-between temporary location, the [[Pre-admit Inpatient Institution]] is the same as [[Previous Location]] (e.g. GH_med, or HSC_MICU)
**if there is a temporary location in-between, then [[Previous Location]] is equal to the temporary location (e.g. OR, RR, Cath Lab, Dialysis, IR or Other procedure location) and [[Pre-admit Inpatient Institution]] would be the previous <site>_inpatient location
**If not yet an inpatient from HSC/STB/GRA and coming from <other site> ER then previous location is <other site> ER, and the [[Pre-admit Inpatient Institution]] would be not applicable
*If a [[homeless]] patient is admitted directly then code them as admitted from home.  
*If a patient is admitted directly from prison, jail or a correctional institution, code this as an admission from '''"Institution NOS"'''. See [[Prison / Jail / Correctional Institution]] for additional info.


=== Exceptions ===
=== 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). For patients from these units:
We have a few units in the Region that have a mix of different services (internal medicine, surgical, family medicine etc).  
** If patient was under internal medicine service, enter <site>_Med
** If '''not''' under internal medicine service, enter the <site>_Ward
*for Riverview and [[Deer Lodge (DLC)]], see [[Chronic Health Facility]] see [[Pre-admit Inpatient Institution field]] or the various wards that are considered an inpatient location
*patients from POU (psych evaluation unit @ HSC) as "HSC ambulatory care" - This is not an inpatient ward.
*patients admitted from day surgery units, enter <site>_ambulatory care, e.g. this is not considered to be an inpatient location see [[Pre-admit Inpatient Institution field]]


*HSC_B3 - is a mix of day surgery & internal medicine patients
{{Pre-admit, Previous content}}
* any others?


For patients from these units:
{{Location dropdown cleanup}}
* 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
 
==== [[HSC Stepdown Units]] ====
 
==== [[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 ==
== Data Use ==
Line 77: Line 65:


== Legacy ==
== Legacy ==
{{Change to collecting prison as "Institution NOS"}}
=== pre-2016 ===
This field is part of the [[2016 Time and Place changes]].
This field is part of the [[2016 Time and Place changes]].


Line 87: Line 78:
{{Related Articles}}
{{Related Articles}}


[[Category: 2016 Time and Place changes]]
[[Category:2016 Time and Place changes]]
[[Category: Admit/Discharge]]
[[Category:Admit/Discharge]]
[[Category: Registry Data]]
[[Category:Registry Data]]
[[Category: Data Collection Guide]]
[[Category:Data Collection Guide]]

Latest revision as of 22:56, 30 July 2025


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

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 the patient is a direct admission use <site>_UC, <Site>_ER, <site>_ward, <site>_Med, <site>_ICU or temporary location depending on the scenario (see direct admit scenarios below)
  • 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

what is the Pre-admit Inpatient Institution entry for this case? --JMojica 13:37, 29 July 2025 (CDT)

  • That is what we need to decide we should probably keep it consistent with EMIP concept, however, for SICU we generally disregard the surgical service (when in ER) unless they were truly an inpt on a ward Lisa Kaita 13:59, 30 July 2025 (CDT)
  • SMW


  • Cargo


  • Categories

If you know the location exactly, you can type it, otherwise click on the dropdown button to view the options

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.

Borrowed Bed Or Pt Boarding On Other Unit

  • Use the Boarding Loc of the service taking care of the patient:<site>_Med, GH-CC, HSC_MICU, HSC_SICU, HSC_IICU, STB MICU, STB_ICCS, STB_ACCU.
  • for consistency, should this also use the Template:PrePrevDispo listing? Actually, what does this even mean for previous location? And what do you do if the patient comes from med?
  • SMW


  • Cargo


  • Categories

Direct Admit Scenarios

  • inpatients from CON, OAK, VIC who are direct transfers to HSC/STB/GRA, the Pre-admit Inpatient Institution and Previous Location will be <site>_ward, even if the patient spends time in that site's UC prior to transfer. If not yet an inpatient from CON/OAK/VIC and transfer is from their UC, then previous location is the <site>_UC.
  • For direct transfers from HSC/STB/GRA, if an inpatient, and no in-between temporary location, the Pre-admit Inpatient Institution is the same as Previous Location (e.g. GH_med, or HSC_MICU)
    • if there is a temporary location in-between, then Previous Location is equal to the temporary location (e.g. OR, RR, Cath Lab, Dialysis, IR or Other procedure location) and Pre-admit Inpatient Institution would be the previous <site>_inpatient location
    • If not yet an inpatient from HSC/STB/GRA and coming from <other site> ER then previous location is <other site> ER, and the Pre-admit Inpatient Institution would be not applicable
  • If a homeless patient is admitted directly then code them as admitted from home.
  • If a patient is admitted directly from prison, jail or a correctional institution, code this as an admission from "Institution NOS". See Prison / Jail / Correctional Institution for additional info.

Exceptions

  • We have a few units in the Region that have a mix of different services (internal medicine, surgical, family medicine etc). For patients from these units:
    • If patient was under internal medicine service, enter <site>_Med
    • If not under internal medicine service, enter the <site>_Ward
  • for Riverview and Deer Lodge (DLC), see Chronic Health Facility see Pre-admit Inpatient Institution field or the various wards that are considered an inpatient location
  • patients from POU (psych evaluation unit @ HSC) as "HSC ambulatory care" - This is not an inpatient ward.
  • patients admitted from day surgery units, enter <site>_ambulatory care, e.g. this is not considered to be an inpatient location see Pre-admit Inpatient Institution field

Instructions that apply to both Pre-admit Inpatient Institution and Previous Location

Special Case - Temporary locations

Special Case - ... what is the case?

  • direct admissions to the ER that are under a service that we do not collect, and then are admitted to either an ICU or medicine service, while still physically in the ER

the Previous Location: <site>_ward; Pre-admit Inpatient Institution would also be <site>_ward

  • for EMIP or ECIP follow instructions on those wiki pages


I can not remember which particular data collection instruction applies only to those two that is related to sending someone to the ED, but then, my brain is full. This template was to contain the instructions collectors need to enter this, and then link to an index page with reasons, implications and decision point info. That page is Patients who appear to transfer from in-patient situation to Emergency Room.

"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

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_from_ED_and_prev_location_same_siteCCMDB.accdbready to implement
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
Link_suspect_visitAdmitDtTm_mult_to-from-home queryCentralized data front end.accdbready to implement
Query cardiac arrest throughout admissionCentralized data front end.accdbready to implement

Implementation

The field is populated with options from the s_dispo table.

Legacy

Change to collecting Prison as "Institution NOS"

Before 2018-12-21 we would have coded an admission from jail as previous location "Home". With CCMDB.mdb_Change_Log_2018#2018-12-21 we added the option "Institution NOS".

pre-2016

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=167243"