Project Legacy Co-managed: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) No edit summary |
||
| (7 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|ProjectActive=legacy | |ProjectActive=legacy | ||
|ProjectProgram=CC | |ProjectProgram=CC | ||
|ProjectCollectionStartDate=1989 | |||
|ProjectCollectionStopDate=2004 | |||
}} | }} | ||
This page contains sparse legacy information we brought in from the old [[R_Filter Field]] when it was decommissioned. | This page contains sparse legacy information we brought in from the old [[R_Filter Field]] when it was decommissioned. | ||
| Line 7: | Line 9: | ||
* 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. | * 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. | ||
* The concept is related to the later project [[ | * The concept is related to the later project [[Intended1stSrvc]] with a twist (i.e. with intub/non ventilated procedures). | ||
* In our old documentation booklet it said "''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. ''" | * In our old documentation booklet it said "''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. ''" | ||
| Line 17: | Line 19: | ||
* Item: '''CC or CCN''' | * Item: '''CC or CCN''' | ||
* Not used: start_dt and start_tm, integer, float, checkbox, comment | * Not used: start_dt and start_tm, integer, float, checkbox, comment | ||
== Data Transition == | |||
* added the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT) | |||
* Pagasa transitioned this data from the [[R_Filter Field]] field using the following query. [[User:PTorres|PTorres]] 14:29, 2023 July 19 (CDT) | |||
INSERT INTO L_TmpV2 ( D_ID, Project, Item, D_Tmp_ID ) | |||
SELECT L_Log.D_ID, "Legacy Co-managed" AS Project, L_Log.R_Filter AS Item, [D_ID] & "-LCM_import" AS D_Tmp_ID | |||
FROM L_Log | |||
WHERE (((L_Log.R_Filter) In ("CCN","CC"))); | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||