CREATE VIEW vwoutboundcampaign AS (
 SELECT c.id AS campaign_id,
    c.name AS campaign_name,
    c.campaignstatus AS campaign_status,
    c.contactlist AS contact_list_id,
    c.contactlistname AS contact_list_name,
    c.dialingmode AS dial_mode,
    c.queue AS queue_id,
    qd.name AS queue_name,
    c.division AS division_id,
    c.divisionname AS division_name,
    (round(c.previewtimeoutseconds))::integer AS preview_time_seconds,
    c.abandonrate AS abandon_rate,
    c.script AS script_id,
    c.scriptname AS script_name,
    c.rulesetids AS dialing_rule_set_id,
    c.dnclistids AS dnc_list_id,
    ((c.campaignstatus)::text = 'on'::text) AS active_flag,
    'GenesysCloud'::character varying(50) AS source_system,
    (c.created)::timestamp(3) without time zone AS created_ts,
    (c.updated)::timestamp(3) without time zone AS updated_ts
   FROM (odcampaigndetails c
     LEFT JOIN queuedetails qd ON (((qd.id)::text = (c.queue)::text)))
)