USP_DATAFORMTEMPLATE_EDITLOAD_WPBUSINESSOWNERSHIP

The load procedure used by the edit dataform template "WealthPoint Business Ownership Edit 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SOURCE	nvarchar(100)	INOUT	Source
@CNOTES	nvarchar(1024)	INOUT	Notes
@FULLNAME	nvarchar(100)	INOUT	Name
@TITLE	nvarchar(100)	INOUT	Job title
@LINE1	nvarchar(150)	INOUT	Company address
@CITY	nvarchar(30)	INOUT	Company city
@STATE	nvarchar(100)	INOUT	Company state
@ZIP	nvarchar(10)	INOUT	Company ZIP
@BIO	nvarchar(1500)	INOUT	Biography
@HELDCODE	tinyint	INOUT	Held
@COMPANY	nvarchar(100)	INOUT	Company
@PHONE	nvarchar(20)	INOUT	Phone
@LINE_OF_BUSINESS_DESCRIPTION	nvarchar(50)	INOUT	Description
@SALES_VOLUME	money	INOUT	Sales
@YEAR_STARTED	UDT_YEAR	INOUT	Year started
@EMPLOYEES_TOTAL	int	INOUT	# of employees
@SIC_CODE	nvarchar(4)	INOUT	SIC code used
@DUNS	nvarchar(10)	INOUT	DUNS
@PERCENTAGE	decimal(20, 4)	INOUT	% ownership
@VALUATION	money	INOUT	Valuation
@ISBUILTIN	bit	INOUT
@MAILINGLINE1	nvarchar(150)	INOUT	Mailing address
@MAILINGCITY	nvarchar(30)	INOUT	Mailing city
@MAILINGSTATE	nvarchar(100)	INOUT	Mailing state
@MAILINGZIP	nvarchar(10)	INOUT	Mailing ZIP
@HOMELINE1	nvarchar(150)	INOUT	Home address
@HOMECITY	nvarchar(30)	INOUT	Home city
@HOMESTATE	nvarchar(100)	INOUT	Home state
@HOMEZIP	nvarchar(10)	INOUT	Home ZIP
@SICNAME	nvarchar(100)	INOUT	Trade name
@YEAROFBIRTH	UDT_YEAR	INOUT	Year of birth
@GENDERCODE	tinyint	INOUT	Gender
@RATIO	decimal(20, 4)	INOUT	Ratio used
@WPBUSINESSOWNERSHIPBIOS	xml	INOUT
@WPBUSINESSOWNERSHIPOWNERSHIP	xml	INOUT
@SIC_CODE1	nvarchar(4)	INOUT	SIC code 1
@SIC_CODE2	nvarchar(4)	INOUT	SIC code 2
@SIC_CODE3	nvarchar(4)	INOUT	SIC code 3
@SIC_CODE4	nvarchar(4)	INOUT	SIC code 4
@SIC_CODE5	nvarchar(4)	INOUT	SIC code 5
@SIC_CODE6	nvarchar(4)	INOUT	SIC code 6
@RATIO1	decimal(20, 4)	INOUT	Ratio
@RATIO2	decimal(20, 4)	INOUT	Ratio
@RATIO3	decimal(20, 4)	INOUT	Ratio
@RATIO4	decimal(20, 4)	INOUT	Ratio
@RATIO5	decimal(20, 4)	INOUT	Ratio
@RATIO6	decimal(20, 4)	INOUT	Ratio

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_WPBUSINESSOWNERSHIP (
                        @ID uniqueidentifier,
                        @DATALOADED bit = 0 output,
                        @TSLONG bigint = 0 output,
                        @SOURCE nvarchar(100) = null output,
                        @CNOTES nvarchar(1024) = null output,
                        @FULLNAME nvarchar(100) = null output,
                        @TITLE nvarchar(100) = null output,
                        @LINE1 nvarchar(150) = null output,
                        @CITY nvarchar(30) = null output,
                        @STATE nvarchar(100) = null output,
                        @ZIP nvarchar(10) = null output,
                        @BIO nvarchar(1500) = null output,
                        @HELDCODE tinyint = null output,
                        @COMPANY nvarchar(100) = null output,
                        @PHONE nvarchar(20) = null output,
                        @LINE_OF_BUSINESS_DESCRIPTION nvarchar(50) = null output,
                        @SALES_VOLUME money = null output,
                        @YEAR_STARTED dbo.UDT_YEAR = null output,
                        @EMPLOYEES_TOTAL int = null output,
                        @SIC_CODE nvarchar(4) = null output,
                        @DUNS nvarchar(10) = null output,
                        @PERCENTAGE decimal(20,4) = null output,
                        @VALUATION money = null output,
                        @ISBUILTIN bit    = null output,
                        @MAILINGLINE1 nvarchar(150) = null output,
                        @MAILINGCITY nvarchar(30) = null output,
                        @MAILINGSTATE nvarchar(100) = null output,
                        @MAILINGZIP nvarchar(10) = null output,
                        @HOMELINE1 nvarchar(150) = null output,
                        @HOMECITY nvarchar(30) = null output,
                        @HOMESTATE nvarchar(100) = null output,
                        @HOMEZIP nvarchar(10) = null output,
                        @SICNAME nvarchar(100) = null output,
                        @YEAROFBIRTH dbo.UDT_YEAR = null output,
                        @GENDERCODE tinyint = null output,
                        @RATIO decimal(20,4) = null output,
                        @WPBUSINESSOWNERSHIPBIOS xml = null output,
                        @WPBUSINESSOWNERSHIPOWNERSHIP xml = null output,
                        @SIC_CODE1 nvarchar(4) = null output,
                        @SIC_CODE2 nvarchar(4) = null output,
                        @SIC_CODE3 nvarchar(4) = null output,
                        @SIC_CODE4 nvarchar(4) = null output,
                        @SIC_CODE5 nvarchar(4) = null output,
                        @SIC_CODE6 nvarchar(4) = null output,
                        @RATIO1 decimal(20,4) = null output,
                        @RATIO2 decimal(20,4) = null output,
                        @RATIO3 decimal(20,4) = null output,
                        @RATIO4 decimal(20,4) = null output,
                        @RATIO5 decimal(20,4) = null output,
                        @RATIO6 decimal(20,4) = null output
                    ) as begin

                        set nocount on;

                        set @DATALOADED = 0;
                        set @TSLONG = 0;                        

                        select 
                            @DATALOADED = 1,
                            @TSLONG = BO.TSLONG,
                            @SOURCE = BO.SOURCE,
                            @CNOTES = BO.CNOTES,
                            @FULLNAME = BO.FULLNAME,
                            @TITLE = BO.TITLE,
                            @LINE1 = BO.LINE1,
                            @CITY = BO.CITY,
                            @STATE = BO.STATE,
                            @ZIP = BO.ZIP,
                            @BIO = BO.BIO,
                            @HELDCODE = BO.HELDCODE,
                            @COMPANY = BO.COMPANY,
                            @PHONE = BO.PHONE,
                            @LINE_OF_BUSINESS_DESCRIPTION = BO.LINE_OF_BUSINESS_DESCRIPTION,
                            @SALES_VOLUME = BO.SALES_VOLUME,
                            @YEAR_STARTED = BO.YEAR_STARTED,
                            @EMPLOYEES_TOTAL = BO.EMPLOYEES_TOTAL,
                            @SIC_CODE = BO.SIC_CODE,
                            @DUNS = coalesce(RBO.DUNS, ''),
                            @PERCENTAGE = BO.PERCENTAGE,
                            @VALUATION = BO.VALUATION,
                            @MAILINGLINE1 = BO.MAILINGLINE1,
                            @MAILINGCITY = BO.MAILINGCITY,
                            @MAILINGSTATE = BO.MAILINGSTATE,
                            @MAILINGZIP = BO.MAILINGZIP,
                            @HOMELINE1 = BO.HOMELINE1,
                            @HOMECITY = BO.HOMECITY,
                            @HOMESTATE = BO.HOMESTATE,
                            @HOMEZIP = BO.HOMEZIP,
                            @SICNAME = BO.SICNAME,
                            @YEAROFBIRTH = BO.YEAROFBIRTH,
                            @GENDERCODE = BO.GENDERCODE,
                            @RATIO = BO.RATIO,
                            @WPBUSINESSOWNERSHIPBIOS = dbo.UFN_WPBUSINESSOWNERSHIP_BIOS_TOITEMLISTXML(@ID),
                            @WPBUSINESSOWNERSHIPOWNERSHIP = dbo.UFN_WPBUSINESSOWNERSHIP_OWNERSHIP_TOITEMLISTXML(@ID),
                            @SIC_CODE1 = BO.SIC_CODE1,
                            @SIC_CODE2 = BO.SIC_CODE2,
                            @SIC_CODE3 = BO.SIC_CODE3,
                            @SIC_CODE4 = BO.SIC_CODE4,
                            @SIC_CODE5 = BO.SIC_CODE5,
                            @SIC_CODE6 = BO.SIC_CODE6,
                            @RATIO1 = BO.RATIO1,
                            @RATIO2 = BO.RATIO2,
                            @RATIO3 = BO.RATIO3,
                            @RATIO4 = BO.RATIO4,
                            @RATIO5 = BO.RATIO5,
                            @RATIO6 = BO.RATIO6
                        from
                            dbo.WPBUSINESSOWNERSHIP BO
                        left join dbo.WPRELATIONSHIP_BO RBO
                            on BO.WPRELATIONSHIP_BO_ID = RBO.ID
                        where
                            BO.ID=@ID;

                        exec @ISBUILTIN = UFN_ISBUILTIN_WEALTHSOURCE @SOURCE;

                        return 0;

                    end;