Project Legacy Co-managed: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| (6 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
|ProjectActive=legacy | |ProjectActive=legacy | ||
|ProjectProgram=CC | |ProjectProgram=CC | ||
|ProjectCollectionStartDate=1989 | |||
|ProjectCollectionStopDate=2004 | |||
}} | }} | ||
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. | ||
| Line 17: | Line 19: | ||
* Item: '''CC or CCN''' | * Item: '''CC or CCN''' | ||
* Not used: start_dt and start_tm, integer, float, checkbox, comment | * Not used: start_dt and start_tm, integer, float, checkbox, comment | ||
== Data Transition == | |||
* 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:29, 2023 July 19 (CDT) | |||
INSERT INTO L_TmpV2 ( D_ID, Project, Item, D_Tmp_ID ) | |||
SELECT L_Log.D_ID, "Legacy Co-managed" AS Project, L_Log.R_Filter AS Item, [D_ID] & "-LCM_import" AS D_Tmp_ID | |||
FROM L_Log | |||
WHERE (((L_Log.R_Filter) In ("CCN","CC"))); | |||
== Related articles == | == Related articles == | ||
{{Related Articles}} | {{Related Articles}} | ||