UFN_MATCHINGGIFTPLEDGE_GETCONDITION

Returns all matching gift condition types for a given constituent.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_MATCHINGGIFTPLEDGE_GETCONDITION(
                @ORGANIZATIONID uniqueidentifier
            )
            returns table
            as
            return (
                select
                    ID,
                    MATCHINGGIFTCONDITIONTYPECODEID,
                    dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITIONTYPECODEID) as MATCHINGGIFTCONDITIONTYPE,
                    MATCHINGFACTOR,
                    MAXMATCHANNUAL,
                    MAXMATCHPERGIFT,
                    MAXMATCHTOTAL,
                    MINMATCHPERGIFT,
                    NOTES
                from
                    dbo.MATCHINGGIFTCONDITION
                where
                    ORGANIZATIONID = @ORGANIZATIONID
            )