USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_BIO

This datalist returns WealthPiont business ownership biography information that is used by the wealth information dashboard.

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Constituent ID

Definition

Copy



                CREATE procedure dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_BIO
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        BOB.ID,
                        BOB.WPBUSINESSOWNERSHIPID,
                        BOB.NAME,
                        BOB.BIO
                    from 
                        dbo.WPBUSINESSOWNERSHIP BO
                        inner join dbo.WPBUSINESSOWNERSHIPBIOS BOB on BO.ID = BOB.WPBUSINESSOWNERSHIPID
                    where 
                        BO.WEALTHID = @CONSTITUENTID