Project Legacy HSC CCU Loc: Difference between revisions
Ttenbergen (talk | contribs) |
|||
| Line 17: | Line 17: | ||
== Data Transition == | == Data Transition == | ||
* added 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) | ||
* Pagasa transitioned this data from the [[R_Filter Field]] field using the following query [[User:PTorres|PTorres]] 14:27, 2023 July 19 (CDT) | |||
INSERT INTO L_TmpV2 ( D_ID, Project, Item, D_Tmp_ID ) | 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 | 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 | ||