USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES

The load procedure used by the view dataform template "WealthPoint Securities 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.
@CDATE	datetime	INOUT	BBA confirmed date
@CVALUE	money	INOUT	BBA confirmed value
@CNOTES	nvarchar(1024)	INOUT	Notes
@FULLNAME	nvarchar(60)	INOUT	Name
@CUSIP	nvarchar(9)	INOUT	Cusip
@FILERID	nvarchar(20)	INOUT	Filer ID
@RELATIONSHIP	nvarchar(50)	INOUT	Relationship
@TICKER	nvarchar(8)	INOUT	Symbol
@ISSUERNAME	nvarchar(60)	INOUT	Issuer name
@REPORTDATEDIRECT	datetime	INOUT	Report date direct
@REPORTDATEINDIRECT	datetime	INOUT	Report date indirect
@AMOUNTOWNEDDIRECT	bigint	INOUT	Amount owned direct
@AMOUNTOWNEDINDIRECT	bigint	INOUT	Amount owned indirect
@PRICEDIRECT	money	INOUT	Price direct
@PRICEINDIRECT	money	INOUT	Price indirect
@VALUEDIRECT	money	INOUT	Value direct
@VALUEINDIRECT	money	INOUT	Value indirect
@UPDATEDVALUE	money	INOUT	Updated value
@UPDATEDDATE	datetime	INOUT	Updated date
@UPDATEDPRICE	money	INOUT	Updated price
@WPSECURITIESTRANSACTIONS	xml	INOUT	WPSECURITIESTRANSACTIONS

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CDATE datetime = null output,
                    @CVALUE money = null output,
                    @CNOTES nvarchar(1024) = null output,
                    @FULLNAME nvarchar(60) = null output,
                    @CUSIP nvarchar(9) = null output,
                    @FILERID nvarchar(20) = null output,
                    @RELATIONSHIP nvarchar(50) = null output,
                    @TICKER nvarchar(8) = null output,
                    @ISSUERNAME nvarchar(60) = null output,
                    @REPORTDATEDIRECT datetime = null output,
                    @REPORTDATEINDIRECT datetime = null output,
                    @AMOUNTOWNEDDIRECT bigint = null output,
                    @AMOUNTOWNEDINDIRECT bigint = null output,
                    @PRICEDIRECT money = null output,
                    @PRICEINDIRECT money = null output,
                    @VALUEDIRECT money = null output,
                    @VALUEINDIRECT money = null output,
                    @UPDATEDVALUE money = null output,
                    @UPDATEDDATE datetime = null output,
                    @UPDATEDPRICE money = null output,
                    @WPSECURITIESTRANSACTIONS xml = null output
                ) as begin    

                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @FULLNAME = FULLNAME,
                        @CUSIP = CUSIP,
                        @FILERID = FILERID,
                        @RELATIONSHIP = RELATIONSHIP,
                        @TICKER = TICKER,
                        @ISSUERNAME = ISSUERNAME,
                        @REPORTDATEDIRECT = REPORTDATEDIRECT,
                        @REPORTDATEINDIRECT = REPORTDATEINDIRECT,
                        @AMOUNTOWNEDDIRECT = AMOUNTOWNEDDIRECT,
                        @AMOUNTOWNEDINDIRECT = AMOUNTOWNEDINDIRECT,
                        @PRICEDIRECT = PRICEDIRECT,
                        @PRICEINDIRECT = PRICEINDIRECT,
                        @VALUEDIRECT = VALUEDIRECT,
                        @VALUEINDIRECT = VALUEINDIRECT,
                        @UPDATEDVALUE = case UPDATEDVALUEDIRECT when 0 then UPDATEDVALUEINDIRECT else UPDATEDVALUEDIRECT end,
                        @UPDATEDDATE = UPDATEDDATE,
                        @UPDATEDPRICE = UPDATEDPRICE,
                        @WPSECURITIESTRANSACTIONS = dbo.UFN_WPSECURITIES_TRANSACTIONS_TOITEMLISTXML(@ID)
                    from
                        dbo.WPSECURITIES
                    where
                        ID=@ID

                    return 0

                end