Project Legacy HSC CCU Loc: Difference between revisions

(6 intermediate revisions by 2 users not shown)

Line 7:

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

** 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 ==

Line 19:

Line 16:

== 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.~~

INSERT INTO L_TmpV2 ( D_ID, Project, Item, 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, [D_ID] & "-LHCCULoc_imp" AS D_Tmp_ID

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

WHERE (((L_Log.R_Filter) In ("H","B","HB","BH")));

}}

== Related articles ==

@@ Line 7: / Line 7: @@
 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
-** 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 ==
@@ Line 19: / Line 16: @@
 == 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.
+  INSERT INTO L_TmpV2 ( D_ID, Project, Item, 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, [D_ID] & "-LHCCULoc_imp" AS D_Tmp_ID
-  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")));
+  WHERE (((L_Log.R_Filter) In ("H","B","HB","BH")));
-}}
 == Related articles ==
 {{Related Articles}}