| description:
|
spot_ha_devices:<br /><div> SELECT row_number() OVER (ORDER BY eth_spot_hazard_task_evw.uniquerowid)::oid AS objectid,</div><div> next_globalid() AS globalid,</div><div> spot_hazard_dev_evw.dev_haz_id AS report_id,</div><div> spot_hazard_dev_evw.dev_cont_type AS cont_type,</div><div> spot_hazard_dev_evw.eo_model,</div><div> spot_hazard_dev_evw.eo_device,</div><div> spot_hazard_dev_evw.eo_device_other,</div><div> spot_hazard_dev_evw.dev_amount AS amount,</div><div> eth_spot_hazard_task_evw.cont_id,</div><div> eth_spot_hazard_task_evw.report_dt,</div><div> eth_spot_hazard_task_evw.status,</div><div> eth_spot_hazard_task_evw.admin1name,</div><div> eth_spot_hazard_task_evw.admin2name,</div><div> eth_spot_hazard_task_evw.admin3name,</div><div> eth_spot_hazard_task_evw.ops_validation_status,</div><div> eth_spot_hazard_task_evw.im_validation_status,</div><div> eth_spot_hazard_task_evw.shape,</div><div> 'Spot Task'::text AS source_table</div><div> FROM spot_hazard_dev_evw</div><div> LEFT JOIN eth_spot_hazard_task_evw ON spot_hazard_dev_evw.dev_haz_id::text = eth_spot_hazard_task_evw.cont_id::text</div><div> WHERE eth_spot_hazard_task_evw.ops_validation_status::text = 'validated'::text AND eth_spot_hazard_task_evw.im_validation_status::text !~~ 'rejected'::text;<br /><br />HA_devices:<br /><div> SELECT row_number() OVER (ORDER BY eth_hazard_area_v2_evw.uniquerowid)::oid AS objectid,</div><div> next_globalid() AS globalid,</div><div> haz_dev_evw.dev_haz_id AS report_id,</div><div> haz_dev_evw.dev_cont_type AS cont_type,</div><div> haz_dev_evw.eo_model,</div><div> haz_dev_evw.eo_device,</div><div> haz_dev_evw.eo_device_other,</div><div> haz_dev_evw.dev_amount AS amount,</div><div> eth_hazard_area_v2_evw.cont_id,</div><div> eth_hazard_area_v2_evw.report_dt,</div><div> eth_hazard_area_v2_evw.status,</div><div> eth_hazard_area_v2_evw.admin1name,</div><div> eth_hazard_area_v2_evw.admin2name,</div><div> eth_hazard_area_v2_evw.admin3name,</div><div> eth_hazard_area_v2_evw.ops_validation_status,</div><div> eth_hazard_area_v2_evw.im_validation_status,</div><div> eth_hazard_area_v2_evw.shape,</div><div> 'HA'::text AS source_table</div><div> FROM haz_dev_evw</div><div> LEFT JOIN eth_hazard_area_v2_evw ON haz_dev_evw.dev_haz_id::text = eth_hazard_area_v2_evw.cont_id::text</div><div> WHERE eth_hazard_area_v2_evw.ops_validation_status::text = 'validated'::text AND eth_hazard_area_v2_evw.im_validation_status::text !~~ 'rejected'::text AND eth_hazard_area_v2_evw.im_validation_status::text !~~ 'Remove'::text;</div><br /></div> |