[Gusdev-rad-issues] added view for RAD3.ElementResultImp

[Elisabetta M. <man...@pc...>]

We are creating the following new view to accomodate QuantArray results:

CREATE VIEW RAD3.QuantArrayElementResult AS SELECT
  element_result_id,
  element_id,
  composite_element_result_id,
  quantification_id,
  subclass_view,
  foreground AS intensity,
  background,
  foreground_sd AS intensity_sdev,
  background_sd AS background_sdev,
  float1 As x_location,
  float2 AS y_location,
  float3 AS diameter,
  float4 AS area,
  float5 AS footprint,
  float6 AS circularity,
  float7 AS spot_uniformity,
  float8 AS bkg_uniformity,
  float9 AS sn_ratio,
  float10 AS confidence,
  tinyint1 AS diameter_filter
  tinyint2 AS area_filter,
  tinyint3 AS footprint_filter,
  smallint1 AS circularity_filter,
  smallint2 AS spot_uniformity_filter,
  smallint3 AS bkg_uniformity_filter,
  int1 AS sn_ratio_filter,
  int2 AS replicate_filter,
  int3   AS ignore_filter,
  modification_date,
  user_read,
  user_write,
  group_read,
  group_write,
  other_read,
  other_write,
  row_user_id,
  row_group_id,
  row_project_id,
  row_alg_invocation_id
FROM ElementResultImp
WHERE subclass_view = 'QuantArrayElementResult' WITH CHECK OPTION;
--

CREATE OR REPLACE VIEW Rad3ver.QuantArrayElementResultVer AS
  SELECT
  element_result_id,
  element_id,
  composite_element_result_id,
  quantification_id,
  subclass_view,
  foreground AS intensity,
  background,
  foreground_sd AS intensity_sdev,
  background_sd AS background_sdev,
  float1 As x_location,
  float2 AS y_location,
  float3 AS diameter,
  float4 AS area,
  float5 AS footprint,
  float6 AS circularity,
  float7 AS spot_uniformity,
  float8 AS bkg_uniformity,
  float9 AS sn_ratio,
  float10 AS confidence,
  tinyint1 AS diameter_filter
  tinyint2 AS area_filter,
  tinyint3 AS footprint_filter,
  smallint1 AS circularity_filter,
  smallint2 AS spot_uniformity_filter,
  smallint3 AS bkg_uniformity_filter,
  int1 AS sn_ratio_filter,
  int2 AS replicate_filter,
  int3   AS ignore_filter,
  modification_date,
  user_read,
  user_write,
  group_read,
  group_write,
  other_read,
  other_write,
  row_user_id,
  row_group_id,
  row_project_id,
  row_alg_invocation_id,
  version_alg_invocation_id,
  version_date,
  version_transaction_id
FROM RAD3ver.ElementResultImpVer WHERE subclass_view =
'QuantArrayElementResult'
WITH CHECK OPTION
--