USP_DATAFORMTEMPLATE_VIEW_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAIL

The load procedure used by the view dataform template "Prospect Quick Search Business Ownership Detail View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@COMPANY	nvarchar(30)	INOUT	Company
@SECNAME	nvarchar(30)	INOUT	Trade name
@DESCRIPTION	nvarchar(300)	INOUT	Description
@PHONE	nvarchar(20)	INOUT	Phone
@ADDRESS	nvarchar(100)	INOUT	Company address
@MAILINGADDRESS	nvarchar(100)	INOUT	Mailing address
@DUNSNUM	int	INOUT	DUNS
@PRIMARYSICCODE	nvarchar(30)	INOUT	SIC code
@YEARSTARTED	UDT_YEAR	INOUT	Year started
@NUMEMPLOYEES	int	INOUT	# of employees
@HELD	nvarchar(30)	INOUT	Held
@SALES	decimal(18, 0)	INOUT	Sales
@RATIO	decimal(28, 4)	INOUT	Ratio
@VALUATION	decimal(18, 0)	INOUT	Valuation

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PARTIALINFORMATIONSEARCHBUSINESSOWNERSHIPDETAIL
        (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @COMPANY nvarchar(30) = null output,
            @SECNAME nvarchar(30) = null output,
            @DESCRIPTION nvarchar(300) = null output,
            @PHONE nvarchar(20) = null output,
            @ADDRESS nvarchar(100) = null output,
            @MAILINGADDRESS nvarchar(100) = null output,
            @DUNSNUM integer = null output,
            @PRIMARYSICCODE nvarchar(30) = null output,
            @YEARSTARTED dbo.UDT_YEAR = null output,
            @NUMEMPLOYEES integer = null output,
            @HELD nvarchar(30) = null output,
            @SALES decimal = null output,
            @RATIO decimal(28, 4) = null output,
            @VALUATION decimal = null output
        )
        as
            set nocount on;

            set @DATALOADED = 0;

            select
                @DATALOADED = 1,
                @COMPANY = BO.COMPANY,
                @SECNAME = BOD.SECNAME,
                @DESCRIPTION = BOD.DESCRIPTION,
                @PHONE = BO.PHONE,
                @ADDRESS = dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(BO.ADDRESS, '', BO.CITY, BO.STATE, BO.ZIP),
                @MAILINGADDRESS = dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(BOD.MAILINGADDRESS, '', BOD.MAILINGCITY, BOD.MAILINGSTATE, BOD.MAILINGZIP + (case when LEN(BOD.MAILINGZIP4) > 0 then '-' + BOD.MAILINGZIP4 else '' end)),
                @DUNSNUM = BO.DUNSNUM,
                @PRIMARYSICCODE = BOD.PRIMARYSICCODE,
                @YEARSTARTED = BOD.YEARSTARTED,
                @NUMEMPLOYEES = BOD.NUMEMPLOYEES,
                @HELD = BOD.HELD,
                @SALES = BOD.SALES,
                @RATIO = BOD.RATIO,
                @VALUATION = BOD.VALUATION
            from
                dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPDETAIL BOD
            join
                dbo.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIP BO on BO.ID = BOD.PARTIALINFORMATIONSEARCHRESULT_BUSINESSOWNERSHIPID
            where
                BO.ID = @ID