USP_DATAFORMTEMPLATE_VIEW_WPINCOMECOMPENSATION

The load procedure used by the view dataform template "WealthPoint Income/Compensation 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
@BB_FULLNAME	nvarchar(100)	INOUT	Name
@COMPANY	nvarchar(100)	INOUT	Company
@LONGTITLE	nvarchar(100)	INOUT	Job title
@TICKER	nvarchar(8)	INOUT	Symbol
@AGE	int	INOUT	Age
@BIOGRAPHY	nvarchar(1500)	INOUT	Biography
@OFFICER_DIRECTORFLAG	nvarchar(35)	INOUT	Officer/Director
@OFFSTARTY	UDT_YEAR	INOUT	Officer start
@DIRSTARTY	UDT_YEAR	INOUT	Director start
@LATESTCOMPENSATIONYEAR	UDT_YEAR	INOUT	Year
@LATESTFISCALYEARSALARY	money	INOUT	Salary
@LATESTFISCALYEARBONUS	money	INOUT	Bonus
@LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION	money	INOUT	Other short term
@VALUEOFOPTIONSEXERCISED	money	INOUT	Exercised
@VALUEOFOPTIONSUNEXERCISED_EXERCISABLE	money	INOUT	Unexercised
@VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE	money	INOUT	Unexercisable
@LATESTFISCALYEAROTHERLONGTERMCOMPENSATION	money	INOUT	Other long term

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPINCOMECOMPENSATION (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @CDATE datetime = null output,
                    @CVALUE money = null output,
                    @CNOTES nvarchar(1024) = null output,
                    @BB_FULLNAME nvarchar(100) = null output,
                    @COMPANY nvarchar(100) = null output,
                    @LONGTITLE nvarchar(100) = null output,
                    @TICKER nvarchar(8) = null output,
                    @AGE int = null output,
                    @BIOGRAPHY nvarchar(1500) = null output,
                    @OFFICER_DIRECTORFLAG nvarchar(35) = null output,
                    @OFFSTARTY dbo.UDT_YEAR = null output,
                    @DIRSTARTY dbo.UDT_YEAR = null output,
                    @LATESTCOMPENSATIONYEAR dbo.UDT_YEAR = null output,
                    @LATESTFISCALYEARSALARY money = null output,
                    @LATESTFISCALYEARBONUS money = null output,
                    @LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION money = null output,
                    @VALUEOFOPTIONSEXERCISED money = null output,
                    @VALUEOFOPTIONSUNEXERCISED_EXERCISABLE money = null output,
                    @VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE money = null output,
                    @LATESTFISCALYEAROTHERLONGTERMCOMPENSATION money = null output
                ) as begin

                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @CDATE = CDATE,
                        @CVALUE = CVALUE,
                        @CNOTES = CNOTES,
                        @BB_FULLNAME = BB_FULLNAME,
                        @COMPANY = COMPANY,
                        @LONGTITLE = LONGTITLE,
                        @TICKER = TICKER,
                        @AGE = AGE,
                        @BIOGRAPHY = BIOGRAPHY,
                        @OFFICER_DIRECTORFLAG = OFFICER_DIRECTORFLAG,
                        @OFFSTARTY = OFFSTARTY,
                        @DIRSTARTY = DIRSTARTY,
                        @LATESTCOMPENSATIONYEAR = LATESTCOMPENSATIONYEAR,
                        @LATESTFISCALYEARSALARY = LATESTFISCALYEARSALARY,
                        @LATESTFISCALYEARBONUS = LATESTFISCALYEARBONUS,
                        @LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION = LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION,
                        @VALUEOFOPTIONSEXERCISED = VALUEOFOPTIONSEXERCISED,
                        @VALUEOFOPTIONSUNEXERCISED_EXERCISABLE = VALUEOFOPTIONSUNEXERCISED_EXERCISABLE,
                        @VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE = VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE,
                        @LATESTFISCALYEAROTHERLONGTERMCOMPENSATION = LATESTFISCALYEAROTHERLONGTERMCOMPENSATION
                    from
                        dbo.WPINCOMECOMPENSATION
                    where
                        ID=@ID

                    return 0

                end