Previous Service field

From CCMDB Wiki
Jump to navigation Jump to search
Data Element (edit)
Field Name: Previous_Service
CCMDB Label: Previous Service
CCMDB tab: Dispo
Table: L_Log
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: 38

The most recent "originating service" for those patient's who where already in a prior inpatient location before coming to their current service location.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Collection Instruction

For each patient,

  • enter the option that most closely matches
    • for medicine ward-to-ward moves, code "medicine" as previous service
    • for ICU-to-ICU moves, code "Critical Care" if no other specific service is documented
    • for pt from ER, code "Emergency Medicine" unless a different service had accepted them and is handing them off to Medicine
  • for pt direct from ambulatory care not via ER, code "not applicable"
  • if the service is not listed, code "other (known but not on list)"
    • in these cases we don't care about the details; if we see too many others we may add additional options in future

From Cardiac Cath Lab

A patient goes to emergency, then is sent to the cardiac cath lab for an angiogram. The pt can't really go to the cath lab without a cardiologist involved, so sending service would be cardiology. (as discussed at 2016-06 team meeting)

from OR

If a patient comes from an OR/RR, code the responsible surgical service as previous service.

Nursing Home Wards (HSC/GRA)

We treat patients that went through the HSC/GRA Nursing Home as having been discharged. So, admission from there should be as if admitted from home, so put "not applicable" into the Previous Service field. This does not affect the Visit Admit DtTm field definition - remember, that is defined by EPR entry.

from EMIP via ER

The case of VIC ER to STB EMIP to VIC ER to VIC Ward is a bit tricky because STB EMIP signify being an inpatient under Medicine service before going to VIC ER. WIKI defines Previous Service as the "originating service" for those patient's who where already in a prior inpatient location. It would be easier to define the previous service if this is a case of direct transfer to VIC Medicine service and parked only in VIC ER. This is a good question - which to use, Emergency Medicine or Medicine? Since it is known that there is prior inpatient service, I am more on the second one 'Medicine'. This can be a similar case when the previous location is Operating or Recovery and the responsible surgical service is coded as previous service. If coming from home to another ER to own ER to own Ward, then previous service is clearly Emergency medicine.

admission from a unit partly collected by us

see Previous_Location_field#from_a_unit_that_is_partly_collected_by_us.2C_and_partly_not.

Template:Discussion What are people entering for patients coming from a Nursing Station? Are you putting "other (known, but not on list)"? Mlagadi 15:17, 2017 April 11 (CDT)

    • We have a down list of nursing stations specific in MB and if it is outside MB, we indicate the generic province -nursing station (e.g. British Columbia - Nursing station, Alberta - Nursing station, etc.) Do you know the name of the nursing station or is it outside MB? JMojica 16:45, 2017 April 11 (CDT)

Data Use

Patients with Previous Location field critical care must have Previous Service field critical care, and patients from medicine must have previous service medicine.

Sending service to ICU will be reported to the Critical Care Director.

Template:CCMDB Data Integrity Checks

  • Can't be empty.

Not sure if the following makes sense in new context, but moved here from the tmp article: Template:Discussion

  • Query s_tmp_Service_Sending_to_ICU - Error if:
    • not admitted from inpatient location ((S AdmitDischarge.inpatient = true)) but has "Srv to ICU" entry
    • admitted from inpatient location and one of
      • no "Srv to ICU" entry
      • has "Srv to ICU" = "z_not applicable" and no comment

Right now our consistency check would not allow someone from other hosp via ER. We won't be able to do this check until we have Pre-admit Inpatient Institution field. I will take that check out for now. Ttenbergen 11:50, 2015 June 24 (CDT) Template:Discussion


Implementation

The field is populated with options from the s_previous_service table.

Legacy

For medicine this concept is related to ER Wait.

For critical care this concept is related to Service Sending to ICU.