USP_DATAFORMTEMPLATE_EDITLOAD_PURPOSESTEWARDSHIP

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@STEWARDSHIPPACKAGEPROCESSID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN
@TSLONG	bigint	INOUT
@TIMEPERIODCODE	tinyint	INOUT
@ISENDOWED	bit	INOUT
@ISFULLYFUNDED	bit	INOUT
@ISINCOMETOPRINCIPAL	bit	INOUT
@INCOMETOPRINCIPALPERCENT	decimal(5, 2)	INOUT
@STATEMENTWORDING	nvarchar(1024)	INOUT
@ENDOWMENTMINAMOUNT	money	INOUT
@ENDOWMENTTARGETDATE	date	INOUT
@ENDOWMENTMINAMOUNTDATEMET	date	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PURPOSESTEWARDSHIP (
  @ID uniqueidentifier
  ,@DATALOADED bit = 0 output
  ,@NAME nvarchar(100) = null output
  ,@STEWARDSHIPPACKAGEPROCESSID uniqueidentifier = null output
  ,@CURRENTAPPUSERID uniqueidentifier
  ,@TSLONG bigint = 0 output
  ,@TIMEPERIODCODE tinyint = null output
  ,@ISENDOWED bit = null output
  ,@ISFULLYFUNDED bit = null output
  ,@ISINCOMETOPRINCIPAL bit = null output
  ,@INCOMETOPRINCIPALPERCENT decimal(5, 2) = null output
  ,@STATEMENTWORDING nvarchar(1024) = null output
  ,@ENDOWMENTMINAMOUNT money = null output
  ,@ENDOWMENTTARGETDATE date = null output
  ,@ENDOWMENTMINAMOUNTDATEMET date = null output
  ,@BASECURRENCYID uniqueidentifier = null output
  )
as
begin
  set nocount on;
  set @DATALOADED = 0;
  set @TSLONG = 0;

  select @DATALOADED = 1
    ,@STEWARDSHIPPACKAGEPROCESSID = DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID
    ,@TSLONG = DESIGNATIONLEVEL.TSLONG
    ,@NAME = DESIGNATIONLEVEL.[NAME]
    ,@TIMEPERIODCODE = DESIGNATIONLEVEL.TIMEPERIODCODE
    ,@ISENDOWED = DESIGNATIONLEVEL.ISENDOWED
    ,@ISFULLYFUNDED = DESIGNATIONLEVEL.ISFULLYFUNDED
    ,@ISINCOMETOPRINCIPAL = DESIGNATIONLEVEL.ISINCOMETOPRINCIPAL
    ,@INCOMETOPRINCIPALPERCENT = DESIGNATIONLEVEL.INCOMETOPRINCIPALPERCENT
    ,@STATEMENTWORDING = DESIGNATIONLEVEL.STATEMENTWORDING
    ,@ENDOWMENTMINAMOUNT = DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT
    ,@ENDOWMENTTARGETDATE = DESIGNATIONLEVEL.ENDOWMENTTARGETDATE
    ,@ENDOWMENTMINAMOUNTDATEMET = DESIGNATIONLEVEL.ENDOWMENTMINAMOUNTDATEMET
    ,@BASECURRENCYID = DESIGNATIONLEVEL.BASECURRENCYID
  from dbo.DESIGNATIONLEVEL
  inner join dbo.DESIGNATIONLEVELTYPE FPT on DESIGNATIONLEVEL.DESIGNATIONLEVELTYPEID = FPT.ID
  where DESIGNATIONLEVEL.ID = @ID

  return 0
end