R Filter Field: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m (Text replacement - "{{DT" to "{{TT")
mNo edit summary
Line 12: Line 12:
|element_description=Critical care patients on a long term ventilator ([[LTV]]).
|element_description=Critical care patients on a long term ventilator ([[LTV]]).
}}
}}
== [[Conversion from our old diagnosis schema to ICD10/CCI]] ==
== [[Conversion from our old diagnosis schema to ICD10/CCI]] ==
{{TT | ICD/CCI remove once old pt gone }}
{{TT | _dev_CCMDB data remove
{{TT|move into dx and eliminate this field}}
* stop sending this one }}
 
{{TT | _CFE_Data_reconsolidate
* move into dx and eliminate this field}}
 
* [[Chronic dependence on mechanical ventilator]]
* [[Chronic dependence on mechanical ventilator]]
* might be best to move this into a dx field for conversion before ICD10 conversion to not add additional complexity then... Ttenbergen 19:58, 2017 September 16 (CDT)
* might be best to move this into a dx field for conversion before ICD10 conversion to not add additional complexity then... Ttenbergen 19:58, 2017 September 16 (CDT)

Revision as of 15:32, 2021 August 4

 
 
 
 

Legacy Content

This page contains Legacy Content.
  • Explanation: This is a legacy data field, its DataElementEndDate is in the past.
  • Successor: No successor was entered

Click Expand to show legacy content.

Data Element (edit)
Field Name: R_Filter
CCMDB Label: LTV
CCMDB tab: Dispo
Table: L_Log table
Data type: string
Length: 10
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2019/01/01
Sort Index: 26

Critical care patients on a long term ventilator (LTV).

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Conversion from our old diagnosis schema to ICD10/CCI

_dev_CCMDB data remove

  • stop sending this one
  • added: no added date
  • action: no action date
  • Cargo


  • Categories


_CFE_Data_reconsolidate

  • move into dx and eliminate this field
  • added: no added date
  • action: no action date
  • Cargo


  • Categories

Legacy Data

For legacy reasons the actual name of the field in ccmdb_data.mdb and Centralized_data.mdb is R_Filter.

B, H, BH

HSC-CCU Only.

  • Started: Sept 25, 2003
  • Stopped 2005
  • B = CCU patient on B3 only
  • H = CCU patient on H7-CCU only
  • BH = CCU patient on BOTH B3 & H7-CCU during one admission

Purpose was to capture CCU patient location during ICU CCU bed closure and during some renovations.

CC, CCN

HSC & STB-CCU patients only. Tags used for ICU:

  • CC - intubated/ventilated patient in MICU under care of cardiology service or co-managed with MICU attending
  • CCN - not ventilated but requires inotrope support, IABP or central lines in MICU under the care of cardiology service or co-managed with MICU attending

H1C, H1S, H1N

H1C and H1S are H1N confirmed and suspects when we are doing the H1N audit.

Other values

  • 1 22E
  • 5 DAN
  • 1 GRA
  • 1 H3N
  • 11 H4H
  • 9 HB
  • 2 LTR
  • 59 MR9
  • 130 MRT
  • 3 NP
  • 2 U

Julie's review 2017-04-18

Transfer to Tmp

  1. LTV (Long Term Ventilated patients) – 463 records from 1988 to present at all sites ICUs ---> can be moved to tmp or can be a separate field.
  2. H1S, H1C (i.e. H1N suspect and H1N confirm ) - 155 records, 2009 at all sites
  3. CCN/CC (co managed CCU patients intubated/non ventilated) – 633 records from 1989-2004 at STB/HSC MICU
  4. H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU

Delete

  1. U, u (2014) – 2 records only
  2. NP– 3 records only, 1990-1991, HSC
  3. MRT, MR9 - 189 records, from 1989-1992, at HSC MICU/SICU ---> can’t remember this, Trish. If needed, move to tmp.
  4. LTR – 2 records, 2012, at GRA N5
  5. H4H - 11 records, Apr 2005 at HSC H4 ---> start date of H4H is May2005. Do we want to make the service location= H4H?
  6. H3N– 1 record, 2010 at HSC MICU
  7. GRA – 1 record, 2013 at GRA N3
  8. DAN – 5 records, 1998,2000,2001,2003 at HSC MICU
  9. 22E – 1 record, 2005 at STB E5