UFN_PLANNEDGIFT_ASSETS

Returns the assets for a planned gift.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTID	uniqueidentifier	IN

Definition

Copy


            CREATE function dbo.UFN_PLANNEDGIFT_ASSETS(@PLANNEDGIFTID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    ASSETTYPECODEID,
                    DESCRIPTION,
                    VALUE,
                    COSTBASIS,
                    ASSETVALUATIONMETHODCODEID,
                    VALUATIONSOURCE,
                    ADDRESSID,
                    SEQUENCE,
                    dbo.UFN_PLANNEDGIFT_ASSETHOLDERS_TOITEMLISTXML(ID) ASSETHOLDERS
                from
                    dbo.PLANNEDGIFTASSET
                where
                    PLANNEDGIFTID=@PLANNEDGIFTID