USP_DATAFORMTEMPLATE_VIEW_WPINCOMECOMPENSATION2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@CDATE	datetime	INOUT
@CVALUE	money	INOUT
@CNOTES	nvarchar(1024)	INOUT
@BB_FULLNAME	nvarchar(100)	INOUT
@COMPANY	nvarchar(100)	INOUT
@LONGTITLE	nvarchar(100)	INOUT
@TICKER	nvarchar(8)	INOUT
@AGE	int	INOUT
@BIOGRAPHY	nvarchar(1500)	INOUT
@OFFICER_DIRECTORFLAG	nvarchar(35)	INOUT
@OFFSTARTY	UDT_YEAR	INOUT
@DIRSTARTY	UDT_YEAR	INOUT
@LATESTCOMPENSATIONYEAR	UDT_YEAR	INOUT
@LATESTFISCALYEARSALARY	money	INOUT
@LATESTFISCALYEARBONUS	money	INOUT
@LATESTFISCALYEAROTHERSHORTTERMCOMPENSATION	money	INOUT
@VALUEOFOPTIONSEXERCISED	money	INOUT
@VALUEOFOPTIONSUNEXERCISED_EXERCISABLE	money	INOUT
@VALUEOFOPTIONSUNEXERCISED_UNEXERCISABLE	money	INOUT
@LATESTFISCALYEAROTHERLONGTERMCOMPENSATION	money	INOUT
@SOURCE	nvarchar(100)	INOUT
@MATCHCODE	nvarchar(100)	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_WPINCOMECOMPENSATION2 (
                    @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,
                    @SOURCE nvarchar(100) = null output,
                    @MATCHCODE nvarchar(100) = 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,
                        @SOURCE = SOURCE,
                        @MATCHCODE = MC + ' - ' + dbo.UFN_WPMATCHCODE_DESCRIPTION(MC)
                    from
                        dbo.WPINCOMECOMPENSATION
                    where
                        ID=@ID

            update
              dbo.WPINCOMECOMPENSATION
            set HISTORICCODE = 0
            where
              ID=@ID and
              HISTORICCODE = 2

                    return 0

                end