-- *************************************************************************** --
-- VIEW (Anderson): USM_TENANT
--
--   contains combination fields of (all usm_tenant_ext + subset of ca_tenant)
--   ca_tenant (name, service_provider,contact,location,inactive will be excluded)
--
-- *************************************************************************** --
CREATE VIEW USM_TENANT AS
SELECT
    c.id,
    --c.name,
    c.tenant_number,
    --c.service_provider,
    --c.contact,
    c.logo,
    --c.description,
    c.phone_number,
    c.fax_number,
    c.alt_phone,
    --c.location,
    --c.inactive,
    c.version_number,
    c.creation_user,
    c.creation_date,
    c.last_update_user,
    c.last_update_date,
    c.tenant,
    c.ldap_tenant_group,
    c.parent,
    c.fkey_group,
    c.subtenants_ok,
    c.subtenant_group,
    c.supertenant_group,
    c.relatedtenant_group,
    c.tenant_depth,
    c.tou_id,
    u.*
FROM ca_tenant c full outer join usm_tenant_ext u on (c.id = u.ca_tenant_uuid)
GO
GRANT SELECT ON  [dbo].[USM_TENANT] TO [usmgroup]
GRANT INSERT ON  [dbo].[USM_TENANT] TO [usmgroup]
GRANT DELETE ON  [dbo].[USM_TENANT] TO [usmgroup]
GRANT UPDATE ON  [dbo].[USM_TENANT] TO [usmgroup]
GO