UFN_SELECTION_CONSTITUENT_LAPSEDMULTIYEARDONOR

Returns all constituents that meet the 'Lapsed multiple years' lifecycle donor state.

Return

Return Type
table

Definition

Copy



CREATE function dbo.UFN_SELECTION_CONSTITUENT_LAPSEDMULTIYEARDONOR()
returns table
as return
(      
    select 
        CONSTITUENTID as ID
    from 
        dbo.REVENUELIFECYCLE        
    where
        REVENUELIFECYCLE.DONORSTATECODE = 7
)