USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_OWNERSHIP2

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

Parameters

Parameter	Parameter Type	Mode	Description
@BUSINESSOWNERSHIPID	uniqueidentifier	IN	Business Ownership ID

Definition

Copy



                create procedure dbo.USP_DATALIST_WEALTHINFORMATIONDASHBOARDBUSINESSOWNERSHIP_OWNERSHIP2
                (
                    @BUSINESSOWNERSHIPID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        BOO.ID,
                        BOO.NAME,
                        BOO.PERCENTOWNERSHIP,
                        BOO.VALUE
                    from 
                        dbo.WPBUSINESSOWNERSHIPOWNERSHIP BOO
                    where 
                        BOO.WPBUSINESSOWNERSHIPID = @BUSINESSOWNERSHIPID