USP_DATALIST_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILEXECS

Returns a list of executives for a company that has a business ownership record.

Parameters

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

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAILEXECS(
    @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID uniqueidentifier
)
as
    set nocount on;

    select 
        EXECS.ID,
        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDNAMEFULL(EXECS.PREFIX, EXECS.FIRST, EXECS.MIDDLE, EXECS.LAST, EXECS.SUFFIX) NAME,
        EXECS.TITLE,
        dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(EXECS.ADDRESS, '', EXECS.CITY, EXECS.STATE, EXECS.ZIP) HOMEADDRESS,
        case 
            when EXECS.[ADDRESS] <> '' or EXECS.[CITY] <> '' or EXECS.[STATE] <> '' or EXECS.[ZIP] <> '' then
                1
            else
                0
        end as [HASHOMEADDR],
        EXECS.YEAROFBIRTH,
        EXECS.GENDER

    from 
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL_EXECS EXECS
    join
        dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL DETAIL on DETAIL.ID = EXECS.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAILID
    where 
        DETAIL.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID = @PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID