USP_DATAFORMTEMPLATE_VIEW_PURPOSESTEWARDSHIPVIEW

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@STEWARDSHIPPACKAGEPROCESSID	uniqueidentifier	INOUT
@STEWARDSHIPPACKAGENAME	nvarchar(100)	INOUT
@ENDOWMENTMINAMOUNT	money	INOUT
@ENDOWMENTTARGETDATE	date	INOUT
@ENDOWMENTMINAMOUNTDATEMET	date	INOUT
@ISFULLYFUNDED	bit	INOUT
@ISENDOWED	bit	INOUT
@BASECURRENCYID	uniqueidentifier	INOUT

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PURPOSESTEWARDSHIPVIEW (
  @ID uniqueidentifier
  ,@DATALOADED bit = 0 output
  ,@STEWARDSHIPPACKAGEPROCESSID uniqueidentifier = null output
  ,@STEWARDSHIPPACKAGENAME nvarchar(100) = null output
  ,@ENDOWMENTMINAMOUNT money = null output
  ,@ENDOWMENTTARGETDATE date = null output
  ,@ENDOWMENTMINAMOUNTDATEMET date = null output
  ,@ISFULLYFUNDED bit = null output
  ,@ISENDOWED bit = null output
  ,@BASECURRENCYID uniqueidentifier = null output
  )
as
begin
  set nocount on;
  set @DATALOADED = 1;

  select @DATALOADED = 1
    ,@STEWARDSHIPPACKAGEPROCESSID = DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID
    ,@STEWARDSHIPPACKAGENAME = PKG.[NAME]
    ,@ENDOWMENTMINAMOUNT = DESIGNATIONLEVEL.ENDOWMENTMINAMOUNT
    ,@ENDOWMENTTARGETDATE = DESIGNATIONLEVEL.ENDOWMENTTARGETDATE
    ,@ENDOWMENTMINAMOUNTDATEMET = DESIGNATIONLEVEL.ENDOWMENTMINAMOUNTDATEMET
    ,@ISFULLYFUNDED = DESIGNATIONLEVEL.ISFULLYFUNDED
    ,@ISENDOWED = DESIGNATIONLEVEL.ISENDOWED
    ,@BASECURRENCYID = DESIGNATIONLEVEL.BASECURRENCYID
  from dbo.DESIGNATIONLEVEL
  inner join dbo.STEWARDSHIPPACKAGEPROCESS PKG on DESIGNATIONLEVEL.STEWARDSHIPPACKAGEPROCESSID = PKG.ID
  where DESIGNATIONLEVEL.ID = @ID

  return 0
end