Project Legacy HSC CCU Loc: Difference between revisions

Revision as of 10:30, 6 July 2023

This page contains sparse legacy information we brought in from the old R_Filter Field when it was decommissioned.

	H/B/HB/BH (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU looks like this is similar to Boarding Loc except without start dates and only location. I think better to make a separate project than add to current Boarding Loc since these had older data (maybe name the project as HSC CCU Location) --JMojica 14:55, 2022 August 29 (CDT)

	add the relevant lines to s_tmp table transition this data from the R_Filter Field field. The following query should do it. INSERT INTO L_TmpV2 ( D_ID, Project, Item ) SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item FROM L_Log WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH")));

@@ Line 24: / Line 24: @@
 * transition this data from the [[R_Filter Field]] field. The following query should do it.
   INSERT INTO L_TmpV2 ( D_ID, Project, Item )
-  SELECT L_Log.D_ID, "Legacy Co-managed" AS Project, L_Log.R_Filter AS Item
+  SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item
   FROM L_Log
-  WHERE (((L_Log.R_Filter) In ("CCN","CC")));
+  WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH")));
+}}
 == Related articles ==
 {{Related Articles}}