USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_OWNERSHIP

This datalist returns WealthPiont business ownership ownership 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_OWNERSHIP
                (
                    @CONSTITUENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        BOO.ID,
                        BOO.WPBUSINESSOWNERSHIPID,
                        BOO.NAME,
                        BOO.PERCENTOWNERSHIP,
                        BOO.VALUE
                    from 
                        dbo.WPBUSINESSOWNERSHIP BO
                        inner join dbo.WPBUSINESSOWNERSHIPOWNERSHIP BOO on BO.ID = BOO.WPBUSINESSOWNERSHIPID
                    where 
                        BO.WEALTHID = @CONSTITUENTID