UFN_BBNC_GETRECIPROCALCONSTITMAPID

Returns the integer mapping ID for the reciprocal constituent for the specified Relationship integer mapping ID for Blackbaud Internet Solutions.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETRECIPROCALCONSTITMAPID
            (
                @ID int
            )
            returns int
            as begin
                return (
                    select top (1)
                        [RECIPROCALCONSTITUENT].[SEQUENCEID]
                    from
                        dbo.BBNCRELATIONSHIPIDMAP
                        inner join dbo.RELATIONSHIP on [BBNCRELATIONSHIPIDMAP].[RELATIONSHIPID] = [RELATIONSHIP].[ID]
                        inner join dbo.CONSTITUENT as [RECIPROCALCONSTITUENT] on [RELATIONSHIP].[RECIPROCALCONSTITUENTID] = [RECIPROCALCONSTITUENT].[ID]
                    where
                        [BBNCRELATIONSHIPIDMAP].[ID] = @ID
                    )
            end