USP_SIMPLEDATALIST_EXTENDEDRELATIONSHIP_SOURCES
This simple list returns all of the sources for extended relationships.
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_EXTENDEDRELATIONSHIP_SOURCES as
select distinct
WS.SOURCE +
case WSM.[WEALTHTABLE]
when 'WPBUSINESSOWNERSHIP' then ' (Businesses)'
when 'WPPRIVATEFOUNDATION' then ' (Foundation affiliation)'
when 'WPNONPROFITAFFILIATION' then ' (Nonprofit affiliation)'
else ''
end as VALUE,
WS.SOURCE +
case WSM.[WEALTHTABLE]
when 'WPBUSINESSOWNERSHIP' then ' (Businesses)'
when 'WPPRIVATEFOUNDATION' then ' (Foundation affiliation)'
when 'WPNONPROFITAFFILIATION' then ' (Nonprofit affiliation)'
else ''
end as LABEL
from
dbo.WEALTHSOURCE WS
left join dbo.WEALTHSOURCEMAPPING WSM on
WS.ID = WSM.WEALTHSOURCEID
where
WSM.WEALTHTABLE in ('WPBUSINESSOWNERSHIP', 'WPNONPROFITAFFILIATION', 'WPPRIVATEFOUNDATION')