USP_DATAFORMTEMPLATE_VIEW_WPSECURITIES_ORG

The load procedure used by the view dataform template "Organization 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.
@SOURCE	nvarchar(100)	INOUT	Source
@TICKER	nvarchar(8)	INOUT	Symbol
@ISSUERNAME	nvarchar(60)	INOUT	Issuer name
@PRICEDIRECT	money	INOUT	Last retrieved price
@REPORTDATEDIRECT	datetime	INOUT	Last retrieved price date
@ISHISTORICAL	bit	INOUT	Is historical record
@SHARESHELDDATE	datetime	INOUT	Shares held date
@AMOUNTOWNEDDIRECT	bigint	INOUT	Quantity held
@VALUEDIRECT	money	INOUT	Total value
@CNOTES	nvarchar(1024)	INOUT	Notes

Definition

Copy


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

    @SOURCE nvarchar(100) = null output,
    @TICKER nvarchar(8) = null output,
    @ISSUERNAME nvarchar(60) = null output,

    @PRICEDIRECT money = null output,
    @REPORTDATEDIRECT datetime = null output,
    @ISHISTORICAL bit = null output,
    @SHARESHELDDATE datetime = null output,
    @AMOUNTOWNEDDIRECT bigint = null output,
    @VALUEDIRECT money = null output,

    @CNOTES nvarchar(1024) = null output
) as begin    

    set nocount on;

    set @DATALOADED = 0;

    select 
        @DATALOADED = 1,

        @SOURCE = SOURCE,
        @TICKER = TICKER,
        @ISSUERNAME = ISSUERNAME,

        @PRICEDIRECT = PRICEDIRECT,
        @REPORTDATEDIRECT = REPORTDATEDIRECT,
        @ISHISTORICAL = ISHISTORICAL,
        @SHARESHELDDATE = SHARESHELDDATE,
        @AMOUNTOWNEDDIRECT = AMOUNTOWNEDDIRECT,
        @VALUEDIRECT = VALUEDIRECT,

        @CNOTES = CNOTES
    from
        dbo.WPSECURITIES
    where
        ID=@ID;

    return 0;

end