USP_DATAFORMTEMPLATE_VIEW_WPBUSINESSOWNERSHIP_ORG

The load procedure used by the view dataform template "Organization WealthPoint Business Ownership 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.
@SOURCE	nvarchar(100)	INOUT	Source
@COMPANY	nvarchar(100)	INOUT	Company
@SICNAME	nvarchar(100)	INOUT	Trade name
@LINE_OF_BUSINESS_DESCRIPTION	nvarchar(50)	INOUT	Description
@PHONE	nvarchar(20)	INOUT	Phone
@ADDRESS	nvarchar(300)	INOUT	Company address
@MAILINGADDRESS	nvarchar(300)	INOUT	Mailing address
@DUNS	nvarchar(10)	INOUT	DUNS
@SIC_CODE	nvarchar(4)	INOUT	SIC code
@YEAR_STARTED	UDT_YEAR	INOUT	Year started
@EMPLOYEES_TOTAL	int	INOUT	# of employees
@HELD	nvarchar(100)	INOUT	Held
@SALES_VOLUME	money	INOUT	Sales
@VALUATION	money	INOUT	Valuation
@PERCENTAGE	decimal(20, 4)	INOUT	% ownership
@OWNERSHIPVALUE	money	INOUT	Ownership value
@CNOTES	nvarchar(1024)	INOUT	Notes
@WPBUSINESSOWNERSHIPBIOS	xml	INOUT	Biographical information
@WPBUSINESSOWNERSHIPOWNERSHIP	xml	INOUT	Ownership information

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPBUSINESSOWNERSHIP_ORG (
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,

    @SOURCE nvarchar(100) = null output,
    @COMPANY nvarchar(100) = null output,
    @SICNAME nvarchar(100) = null output,
    @LINE_OF_BUSINESS_DESCRIPTION nvarchar(50) = null output,

    @PHONE nvarchar(20) = null output,

    @ADDRESS nvarchar(300) = null output,
    @MAILINGADDRESS nvarchar(300) = null output,

    @DUNS nvarchar(10) = null output,
    @SIC_CODE nvarchar(4) = null output,
    @YEAR_STARTED dbo.UDT_YEAR = null output,
    @EMPLOYEES_TOTAL int = null output,
    @HELD nvarchar(100) = null output,
    @SALES_VOLUME money = null output,
    @VALUATION money = null output,
    @PERCENTAGE decimal(20,4) = null output,
    @OWNERSHIPVALUE money = null output,

    @CNOTES nvarchar(1024) = null output,

    @WPBUSINESSOWNERSHIPBIOS xml = null output,
    @WPBUSINESSOWNERSHIPOWNERSHIP xml = null output
) as begin

    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,

        @SOURCE = BO.SOURCE,
        @COMPANY = BO.COMPANY,
        @SICNAME = BO.SICNAME,
        @LINE_OF_BUSINESS_DESCRIPTION = BO.LINE_OF_BUSINESS_DESCRIPTION,

        @PHONE = BO.PHONE,

        @ADDRESS = dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(BO.LINE1, '', BO.CITY, BO.STATE, BO.ZIP),
        @MAILINGADDRESS = dbo.UFN_PARTIALINFORMATIONSEARCH_BUILDADDRESS(BO.MAILINGLINE1, '', BO.MAILINGCITY, BO.MAILINGSTATE, BO.MAILINGZIP),

        @DUNS = coalesce(RBO.DUNS, ''),
        @SIC_CODE = BO.SIC_CODE,
        @YEAR_STARTED = BO.YEAR_STARTED,
        @EMPLOYEES_TOTAL = BO.EMPLOYEES_TOTAL,
        @HELD = BO.HELD,
        @SALES_VOLUME = BO.SALES_VOLUME,
        @VALUATION = BO.VALUATION,
        @PERCENTAGE = BO.PERCENTAGE,
        @OWNERSHIPVALUE = OWNERSHIPVALUE,

        @CNOTES = BO.CNOTES,

        @WPBUSINESSOWNERSHIPBIOS = dbo.UFN_WPBUSINESSOWNERSHIP_BIOS_TOITEMLISTXML(@ID),
        @WPBUSINESSOWNERSHIPOWNERSHIP = dbo.UFN_WPBUSINESSOWNERSHIP_OWNERSHIP_TOITEMLISTXML(@ID)
    from
        dbo.WPBUSINESSOWNERSHIP BO
    left join 
        dbo.WPRELATIONSHIP_BO RBO on BO.WPRELATIONSHIP_BO_ID = RBO.ID
    where
        BO.ID = @ID;

    return 0

end