Project Legacy HSC CCU Loc: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
Line 16: | Line 16: | ||
== Data Transition == | == Data Transition == | ||
* | * added the relevant lines to [[s_tmp table]] [[User:Ttenbergen|Ttenbergen]] 11:43, 2023 July 6 (CDT) | ||
{{Discuss | who = Pagasa | | {{Discuss | who = Pagasa | | ||
* 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) | * 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) | ||
Line 24: | Line 24: | ||
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}} |
Revision as of 10:45, 6 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
- added the relevant lines to s_tmp table Ttenbergen 11:43, 2023 July 6 (CDT)
![]() |
|
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")));
Related articles
Related articles: |