CREATE VIEW vwflowoutcomedetails AS (
 SELECT fod.id,
    fod.name,
    fod.description,
    fod.divisionid,
    dd.name AS divisionname,
    fod.operationid,
        CASE
            WHEN (fod.operationcomplete = '1'::"bit") THEN true
            WHEN (fod.operationcomplete = '0'::"bit") THEN false
            ELSE NULL::boolean
        END AS operationcomplete,
    fod.userid,
    ud.name AS username,
    fod.clientid,
    fod.errormessage,
    fod.errorcode,
    fod.actionname,
    fod.actionstatus,
    fod.updated
   FROM ((flowoutcomedetails fod
     LEFT JOIN divisiondetails dd ON (((fod.divisionid)::text = (dd.id)::text)))
     LEFT JOIN vwuserdetail ud ON (((fod.userid)::text = (ud.id)::text)))
)