Project Legacy HSC CCU Loc: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older edit
mNo edit summary
 
(5 intermediate revisions by 2 users not shown)
Line 7: Line 7:
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.


{{DT|
* H/B/HB/BH  (HSC CCU at H7, B3 or both) – 1100 records from 2003 – 2006 at HSC CCU
* 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) --[[User:JMojica|JMojica]] 14:55, 2022 August 29 (CDT)   
* 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) --[[User:JMojica|JMojica]] 14:55, 2022 August 29 (CDT)   
}}
 


== Field use ==
== Field use ==
Line 19: Line 16:


== Data Transition ==
== Data Transition ==
* add the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT)
* added the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT)
{{Discuss |  who = Pagasa |
* Pagasa transitioned this data from the [[R_Filter Field]] field using the following query [[User:PTorres|PTorres]] 14:27, 2023 July 19 (CDT)
* Please transition this data from the [[R_Filter Field]] field. The following query should do it. [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT)
  INSERT INTO L_TmpV2 ( D_ID, Project, Item, D_Tmp_ID )
}}
  SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item, [D_ID] & "-LHCCULoc_imp" AS D_Tmp_ID
  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
  FROM L_Log
  WHERE (((L_Log.R_Filter) In ("H", "B", "HB", "BH")));
  WHERE (((L_Log.R_Filter) In ("H","B","HB","BH")));
 
== Related articles ==  
== Related articles ==  
{{Related Articles}}
{{Related Articles}}

Latest revision as of 08:45, 27 July 2023

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

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)

Field use

  • Project: Project Legacy HSC CCU Loc
  • Item: H, B, HB or BH
  • Not used: start_dt and start_tm, integer, float, checkbox, comment

Data Transition

INSERT INTO L_TmpV2 ( D_ID, Project, Item, D_Tmp_ID )
SELECT L_Log.D_ID, "Legacy HSC CCU Location" AS Project, L_Log.R_Filter AS Item, [D_ID] & "-LHCCULoc_imp" AS D_Tmp_ID
FROM L_Log
WHERE (((L_Log.R_Filter) In ("H","B","HB","BH")));

Related articles

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