R Filter Field

From CCMDB Wiki
Todo.svg

Swiss Army Knife.svg

_CFE_Data_reconsolidate

  • move into ICD10 and tmp - emailed Pagasa Ttenbergen 09:53, 2022 August 4 (CDT)
    • emailed again because the first email didn't explain that the relevant info is under "expand" Ttenbergen 11:42, 2022 August 23 (CDT)
      • Pagasa emailed "done" Aug 23 Ttenbergen 17:19, 2022 September 1 (CDT)
  • figure out last two sets of values - emailed Julie Ttenbergen 09:53, 2022 August 4 (CDT)
    • emailed again because the first email didn't explain that the relevant info is under "expand" Ttenbergen 11:42, 2022 August 23 (CDT)
  • and eliminate this field
  • added:
  • action: 2022-08-25
  • Cargo


  • Categories
Todo.svg

Swiss Army Knife.svg

_after

  • removed field from sending
  • removed field from sending
  • removed field from ccmdb_data
  • remove field from CFE data
  • delete wiki page when done
  • added:
  • action: 2022-08-09
  • Cargo


  • Categories


 
 
 
 

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

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

translation into other fields

Based on Julie's review 2017-04-18

Data processor.svg
  • Emailed Pagasa to please run the following queries to clear out this field. Ttenbergen 09:52, 2022 August 4 (CDT)
  • SMW


  • Cargo


  • Categories
  • LTV (Long Term Ventilated patients) – 463 records from 1988 to present at all sites ICUs --> to Chronic dependence on mechanical ventilator
    • INSERT INTO L_ICD10 ( L_ICD10_ID, D_ID, ICD10_code, Dx_Type, Dx_Priority )
SELECT [D_ID] & "_LTV" AS L_ID, L_Log.D_ID, " Z99.1" AS ICD10, "Comorbid" AS tp, 28 AS Pr
FROM L_Log
WHERE (((L_Log.R_Filter)="LTV"));
  • H1S, H1C (i.e. H1N suspect and H1N confirm ) - 155 records, 2009 at all sites --> to H1N1
    • INSERT INTO L_TmpV2 ( D_Tmp_ID, D_ID, Project, Item, comment_var )
SELECT [D_ID] & "_H1N1_s" AS L_ID, L_Log.D_ID, "H1N suspect" AS tmp_p, "H1N suspect" AS tmp_i, "from R_Filter" AS c
FROM L_Log
WHERE (((L_Log.R_Filter)="H1S"));
  • INSERT INTO L_TmpV2 ( D_Tmp_ID, D_ID, Project, Item, comment_var )
SELECT [D_ID] & "_H1N1_s" AS L_ID, L_Log.D_ID, "H1N confirmed" AS tmp_p, "H1N confirmed" AS tmp_i, "from R_Filter" AS c
FROM L_Log
WHERE (((L_Log.R_Filter)="H1C"));
  • 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
  • UPDATE L_Log SET L_Log.R_Filter = ""
WHERE (((L_Log.R_Filter)="U" Or (L_Log.R_Filter)="u" Or (L_Log.R_Filter)="NP" Or (L_Log.R_Filter)="MRT" Or (L_Log.R_Filter)="MR9" Or (L_Log.R_Filter)="LTR" Or (L_Log.R_Filter)="H4H" Or (L_Log.R_Filter)="H3N" Or (L_Log.R_Filter)="GRA" Or (L_Log.R_Filter)="DAN" Or (L_Log.R_Filter)="22E" Or (L_Log.R_Filter)="H1S" Or (L_Log.R_Filter)="H1C" Or (L_Log.R_Filter)="LTV"));

All Done PTorres 14:48, 2022 August 29 (CDT)

Swiss Army Knife.svg

Don't understand where or how Julie wants these moved, I don't thin we have a tmp project for these; we can make one but then I'd need a clear definition of what these are. Emailed Julie Ttenbergen 09:52, 2022 August 4 (CDT)

  • CCN/CC (co managed CCU patients intubated/non ventilated) – 633 records from 1989-2004 at STB/HSC MICU. Based on the D_ID, the physical location-service involves, CCU, MICU,SICU.
    • looks like similar with ICUOtherService with a twist (i.e. with intub/non ventilated procedures). I think better as a separate tmp project.
    • in the booklet it says - This codes applies to coronary care patients who are deemed too sick for the Coronary Care Unit and are managed or co-managed in the Medical ICU because they required either ventilation, inotropes, central lines or IABP.
    • if this is the definition, I wander when filtered from L_LOG, the D_ID label have CCU, SICU in addition to HSC MICU or STB MICU (showed HSC_CCU--*, HSC_MICU--*, HSC_SICU--*,STB_CCU-*, STB_MICU-*, VIC_MICU-*) . Not sure if VIC_MICU is an entry error but this has acquired dx Debridement-cardiovascular entry, maybe correct. Also maybe the physical location does not matter? --JMojica 14:53, 2022 August 29 (CDT)
  • H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU
    • looks like this is similar with tmp boarding concept except without start dates but only location. I think better to make a separate project than add to current tmp Boarding since these had older data (maybe name the project as HSC CCU Location) --JMojica 14:55, 2022 August 29 (CDT)
  • SMW


  • Cargo


  • Categories

Related articles

Related articles: