UFN_MATCHINGGIFTPLEDGE_GETCONDITION_2

Returns all matching gift condition types for a given constituent and organization pair.
Return

Return Type
table
Parameters

Parameter	Parameter Type	Mode	Description
@ORGANIZATIONID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
Definition

Copy


            CREATE function dbo.UFN_MATCHINGGIFTPLEDGE_GETCONDITION_2
            (
                @ORGANIZATIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select 
                    MATCHINGGIFTCONDITION.ID,
                    RELATIONSHIP.ID as [RELATIONSHIPID],
                    MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID,
                    MATCHINGGIFTCONDITION.MATCHINGGIFTCONDITIONTYPECODEID,
                    dbo.UFN_MATCHINGGIFTCONDITIONTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITIONTYPECODEID) as [MATCHINGGIFTCONDITIONTYPE],
                    dbo.UFN_RELATIONSHIPTYPECODE_GETDESCRIPTION(MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID) as [RELATIONSHIPTYPE],
                    MATCHINGGIFTCONDITION.MATCHINGFACTOR,
                    MATCHINGGIFTCONDITION.MAXMATCHANNUAL,
                    MATCHINGGIFTCONDITION.MAXMATCHPERGIFT,
                    MATCHINGGIFTCONDITION.MAXMATCHTOTAL,
                    MATCHINGGIFTCONDITION.MINMATCHPERGIFT,
                    MATCHINGGIFTCONDITION.NOTES,
                    MATCHINGGIFTCONDITION.MATCHTYPECODE,
                    MATCHINGGIFTCONDITION.MATCHTYPE,
                    MATCHINGGIFTCONDITION.BASECURRENCYID
                from dbo.MATCHINGGIFTCONDITION
                left join dbo.MATCHINGGIFTCONDITIONRELATIONSHIP on MATCHINGGIFTCONDITIONRELATIONSHIP.MATCHINGGIFTCONDITIONID = MATCHINGGIFTCONDITION.ID
                left join dbo.RELATIONSHIP on RELATIONSHIP.RELATIONSHIPTYPECODEID = MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID
                    and RELATIONSHIP.RELATIONSHIPCONSTITUENTID = @CONSTITUENTID 
                    and RELATIONSHIP.RECIPROCALCONSTITUENTID = @ORGANIZATIONID
                where MATCHINGGIFTCONDITION.ORGANIZATIONID = @ORGANIZATIONID
            )