UFN_PLANNEDGIFT_BENEFICIARIES

Returns the beneficiaries for a planned gift.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy


            CREATE function dbo.UFN_PLANNEDGIFT_BENEFICIARIES(@PLANNEDGIFTID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    BENEFICIARYTYPECODEID,
                    BENEFICIARYCONSTITUENTID,
                    PRIORITYCODE,
                    SEQUENCE
                from
                    dbo.PLANNEDGIFTBENEFICIARY
                where
                    PLANNEDGIFTID=@PLANNEDGIFTID