ad_allroles_v

SELECT 0 AS ad_client_id,

    0 AS ad_org_id,

    ad_role.ad_role_id AS ad_allroles_v_id,

    ad_role.ad_role_uu AS ad_allroles_v_uu,

    ad_role.created,

    ad_role.createdby,

    ad_role.updated,

    ad_role.updatedby,

    ad_role.isactive,

    ad_role.name,

    ad_role.description,

    ad_role.userlevel,

    ad_role.ismanual,

    ad_role.isshowacct,

    ad_role.ispersonallock,

    ad_role.ispersonalaccess,

    ad_role.iscanexport,

    ad_role.iscanreport,

    ad_role.isaccessallorgs,

    ad_role.ischangelog,

    ad_role.preferencetype,

    ad_role.isuseuserorgaccess,

    ad_role.ismasterrole,

    ad_role.isaccessadvanced,

    ad_role.roletype,

    ad_role.ad_client_id AS ad_allclients_v_id

   FROM ad_role;