Project Legacy HSC CCU Loc: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m Ttenbergen moved page Project Legacy Filter H B to Project Legacy HSC CCU Location without leaving a redirect: name as suggested by Julie
Line 24: Line 24:
* transition this data from the [[R_Filter Field]] field. The following query should do it.  
* transition this data from the [[R_Filter Field]] field. The following query should do it.  
  INSERT INTO L_TmpV2 ( D_ID, Project, Item )
  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
  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 ==  
{{Related Articles}}
{{Related Articles}}

Revision as of 10:30, 2023 July 6

Projects
Active?: legacy
Program: CC
Requestor:
Collection start:
Collection end:

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)
  • SMW


  • Cargo


  • Categories


Field use

  • Project: Project Legacy HSC CCU Loc
  • Item: CC or CCN
  • Not used: start_dt and start_tm, integer, float, checkbox, comment


Data Transition

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")));
  • SMW


  • Cargo


  • Categories

Related articles

Related articles:
Retrieved from "https://ccmdb.kuality.ca/index.php?title=Project_Legacy_HSC_CCU_Loc&oldid=159842"