Project Legacy HSC CCU Loc: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) mNo edit summary |
||
| Line 4: | Line 4: | ||
}} | }} | ||
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 | |||
** 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 == | |||
* Project: '''{{PAGENAME}}''' | |||
* Item: '''CC or CCN''' | |||
* Not used: start_dt and start_tm, integer, float, checkbox, comment | |||
== Data Transition == | |||
{{DT | | |||
* add the relevant lines to [[s_tmp table]] | |||
* transition this data from the [[R_Filter Field]] field. The following query should do it. | |||
INSERT INTO L_TmpV2 ( D_ID, Project, Item ) | |||
SELECT L_Log.D_ID, "Legacy Co-managed" AS Project, L_Log.R_Filter AS Item | |||
FROM L_Log | |||
WHERE (((L_Log.R_Filter) In ("CCN","CC"))); | |||
== Related articles == | |||
{{Related Articles}} | |||