CREATE VIEW vwsubuserlicensedata AS (
 SELECT l.keyid,
    l.userid,
    l.username AS licensedusername,
    l.email AS licensedemail,
    l.licenseid,
    l.licensename,
    l.licensetype,
    l.licenseassignmentdate,
    l.licenseremovaldate,
    l.licenseactive,
    l.copilotlicense,
    l.divisionid,
    l.updated AS licenseupdated,
    ud.name AS username,
    ud.email AS useremail,
    ud.state AS userstate,
    ud.department,
    ud.title,
    ud.manager AS managerid,
    md.name AS managername,
    dd.name AS divisionname,
    dd.homedivision
   FROM (((subuserlicensedata l
     LEFT JOIN userdetails ud ON (((l.userid)::text = (ud.id)::text)))
     LEFT JOIN userdetails md ON (((ud.manager)::text = (md.id)::text)))
     LEFT JOIN divisiondetails dd ON (((l.divisionid)::text = (dd.id)::text)))
  WHERE ((ud.id IS NOT NULL) AND ((ud.state)::text IS DISTINCT FROM 'deleted'::text))
)