UFN_SELECTION_CONSTITUENT_AFFILIATESPONSORS

Returns all constituents with active affiliate sponsorships.

Return

Return Type
table

Definition

Copy



CREATE function dbo.UFN_SELECTION_CONSTITUENT_AFFILIATESPONSORS()
returns table
as return
    select distinct SPONSORSHIP.CONSTITUENTID ID
    from dbo.SPONSORSHIP
    inner join dbo.SPONSORSHIPAFFILIATEPROGRAM on SPONSORSHIPAFFILIATEPROGRAM.ID = SPONSORSHIP.SPONSORSHIPPROGRAMID
    where SPONSORSHIP.STATUSCODE = 1;