UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_GETRELATIONSHIPS

Returns all mapped relation types for a matching gift condition.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MATCHINGGIFTCONDITIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_GETRELATIONSHIPS
            (
                @MATCHINGGIFTCONDITIONID uniqueidentifier
            )
            returns table
            as
            return
            (
                select
                    MATCHINGGIFTCONDITIONRELATIONSHIP.ID,
                    MATCHINGGIFTCONDITIONRELATIONSHIP.RELATIONSHIPTYPECODEID,
                    MATCHINGGIFTCONDITIONRELATIONSHIP.JOBSCHEDULECODEID,
                    MATCHINGGIFTCONDITIONRELATIONSHIP.CAREERLEVELCODEID
                from
                    dbo.MATCHINGGIFTCONDITIONRELATIONSHIP
                where
                    MATCHINGGIFTCONDITIONRELATIONSHIP.MATCHINGGIFTCONDITIONID = @MATCHINGGIFTCONDITIONID
            );