USP_DATALIST_PARTIALINFORMATIONSEARCHRESULTS_BUSINESSOWNERSHIP

Returns a list of business ownership results for a search criteria.
Parameters

Parameter	Parameter Type	Mode	Description
@PARTIALINFORMATIONSEARCHCRITERIAID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_PARTIALINFORMATIONSEARCHRESULTS_BUSINESSOWNERSHIP (
                    @PARTIALINFORMATIONSEARCHCRITERIAID uniqueidentifier
                ) as
                    set nocount on;

                    select
                        PISRBO.[ID],
                        case PISRBO.[CONFIDENCE]
                            when '0' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_0_16.png'
                            when '1' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_1_16.png'
                            when '2' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_2_16.png'    
                            when '3' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_3_16.png'
                            when '4' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_4_16.png'         
                            when '5' then
                                'catalog:Blackbaud.AppFx.WealthPoint.Catalog.dll,Blackbaud.AppFx.WealthPoint.Catalog.level_5_16.png'    
                        end as [STATUSICON],
                        PISRBO.[CONFIDENCE],
                        PISRBO.[DUNSNUM],
                        coalesce(nullif(dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDNAMEFULL('', PISRBO.FIRSTNAME, PISRBO.MIDDLENAME, PISRBO.LASTNAME, PISRBO.SUFFIX), ''), PISRBO.FULLNAME) as [NAME],
                        PISRBO.[COMPANY],
                        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(PISRBO.ADDRESS, '', PISRBO.CITY, PISRBO.STATE, PISRBO.ZIP) as [ADDRESS],
                        PISRBO.[PHONE] as [PHONE],
                        PISRBO.[MATCHTYPE],
                        case 
                            when PISRBO.[ADDRESS] <> '' or PISRBO.[CITY] <> '' or PISRBO.[STATE] <> '' or PISRBO.[ZIP] <> '' then
                                1
                            else
                                0
                        end as [HASCOMPANYADDR]
                    from
                        dbo.[PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP] PISRBO
                    where
                        PISRBO.[PARTIALINFORMATIONSEARCHCRITERIAID] = @PARTIALINFORMATIONSEARCHCRITERIAID
                    order by
                        [CONFIDENCE] desc;