USP_DATALIST_EXTENDEDRELATIONSHIP

A list of extended relationships for a constituent.

Parameters

Parameter	Parameter Type	Mode	Description
@WEALTHID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@SOURCE	nvarchar(100)	IN	Source
@NAME	nvarchar(300)	IN	Name
@COMPANY	nvarchar(300)	IN

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_EXTENDEDRELATIONSHIP
                (
                    @WEALTHID uniqueidentifier,
                    @SOURCE nvarchar(100) = null,
                    @NAME nvarchar(300) = null,
          @COMPANY nvarchar(300) = null
                )
                as
                    set nocount on;

          SELECT ID, PARENTID, VIEWFORMID, MERGEID, COMPANY, MATCHNAME, LASTNAME, RELATIONSHIPNAME, TITLE, LOOKUPID, TYPE, LINKEDCONSTITUENTID, RELATIONSHIPEXISTS
          FROM
          dbo.UFN_WEALTHPOINT_EXTENDEDRELATIONSHIP2(@WEALTHID, @NAME, @SOURCE, @COMPANY)
          order by COMPANY, LASTNAME, RELATIONSHIPNAME asc;