USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVEL_2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @DATALOADED | bit | INOUT | |
| @NAME | nvarchar(100) | INOUT | |
| @DESCRIPTION | nvarchar(255) | INOUT | |
| @DESIGNATIONLEVELTYPEID | uniqueidentifier | INOUT | |
| @DESIGNATIONLEVELTYPE | nvarchar(100) | INOUT | |
| @DESIGNATIONLEVELCATEGORYCODEID | uniqueidentifier | INOUT | |
| @DESIGNATIONLEVELCATEGORYCODE | nvarchar(100) | INOUT | |
| @HASADMINISTRATOR | bit | INOUT | |
| @HASRECIPIENTS | bit | INOUT | |
| @LOOKUPID | nvarchar(100) | INOUT | |
| @SITEID | uniqueidentifier | INOUT | |
| @SITE | nvarchar(1024) | INOUT | |
| @DESIGNATIONREPORT1CODEID | uniqueidentifier | INOUT | |
| @DESIGNATIONREPORT1CODE | nvarchar(100) | INOUT | |
| @DESIGNATIONREPORT2CODEID | uniqueidentifier | INOUT | |
| @DESIGNATIONREPORT2CODE | nvarchar(100) | INOUT | |
| @STEWARDSHIPPACKAGEPROCESSID | uniqueidentifier | INOUT | |
| @STEWARDSHIPPACKAGENAME | nvarchar(100) | INOUT | |
| @VANITYNAME | nvarchar(512) | INOUT | |
| @ENDOWMENTMINAMOUNT | money | INOUT | |
| @ENDOWMENTTARGETDATE | date | INOUT | |
| @ENDOWMENTMINAMOUNTDATEMET | date | INOUT | |
| @ISFULLYFUNDED | bit | INOUT | |
| @ISENDOWED | bit | INOUT | |
| @ADMINISTRATORID | uniqueidentifier | INOUT | |
| @ADMINISTRATOR | nvarchar(700) | INOUT | |
| @ISACCEPTINGFUNDS | bit | INOUT | |
| @ISDISBURSINGMONEY | bit | INOUT | |
| @BASECURRENCYID | uniqueidentifier | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONLEVEL_2 (
@ID uniqueidentifier
,@DATALOADED bit = 0 output
,@NAME nvarchar(100) = null output
,@DESCRIPTION nvarchar(255) = null output
,@DESIGNATIONLEVELTYPEID uniqueidentifier = null output
,@DESIGNATIONLEVELTYPE nvarchar(100) = null output
,@DESIGNATIONLEVELCATEGORYCODEID uniqueidentifier = null output
,@DESIGNATIONLEVELCATEGORYCODE nvarchar(100) = null output
,@HASADMINISTRATOR bit = null output
,@HASRECIPIENTS bit = null output
,@LOOKUPID nvarchar(100) = null output
,@SITEID uniqueidentifier = null output
,@SITE nvarchar(1024) = null output
,@DESIGNATIONREPORT1CODEID uniqueidentifier = null output
,@DESIGNATIONREPORT1CODE nvarchar(100) = null output
,@DESIGNATIONREPORT2CODEID uniqueidentifier = null output
,@DESIGNATIONREPORT2CODE nvarchar(100) = null output
,@STEWARDSHIPPACKAGEPROCESSID uniqueidentifier = null output
,@STEWARDSHIPPACKAGENAME nvarchar(100) = null output
,@VANITYNAME nvarchar(512) = null output
,@ENDOWMENTMINAMOUNT money = null output
,@ENDOWMENTTARGETDATE date = null output
,@ENDOWMENTMINAMOUNTDATEMET date = null output
,@ISFULLYFUNDED bit = null output
,@ISENDOWED bit = null output
,@ADMINISTRATORID uniqueidentifier = null output
,@ADMINISTRATOR nvarchar(700) = null output
,@ISACCEPTINGFUNDS bit = null output
,@ISDISBURSINGMONEY bit = null output
,@BASECURRENCYID uniqueidentifier = null output
)
as
begin
set nocount on;
set @DATALOADED = 0;
select @DATALOADED = 1
,@NAME = DL.name
,@VANITYNAME = DL.VANITYNAME
,@DESCRIPTION = DL.DESCRIPTION
,@LOOKUPID = DL.USERID
,@DESIGNATIONLEVELTYPEID = DL.DESIGNATIONLEVELTYPEID
,@DESIGNATIONLEVELTYPE = DLT.DESCRIPTION
,@DESIGNATIONLEVELCATEGORYCODEID = DL.DESIGNATIONLEVELCATEGORYCODEID
,@DESIGNATIONLEVELCATEGORYCODE = DLC.DESCRIPTION
,@HASADMINISTRATOR = DLT.HASADMINISTRATOR
,@ADMINISTRATOR = dbo.UFN_CONSTITUENTSEARCH_DISPLAYNAME(DL.ADMINISTRATORID)
,@SITEID = DL.SITEID
,@SITE = dbo.UFN_TRANSLATIONFUNCTION_SITE_GETNAME(DL.SITEID)
,@DESIGNATIONREPORT1CODEID = DL.DESIGNATIONREPORT1CODEID
,@DESIGNATIONREPORT1CODE = DLRC1.DESCRIPTION
,@DESIGNATIONREPORT2CODEID = DL.DESIGNATIONREPORT2CODEID
,@DESIGNATIONREPORT2CODE = DLRC2.DESCRIPTION
,@STEWARDSHIPPACKAGEPROCESSID = DL.STEWARDSHIPPACKAGEPROCESSID
,@STEWARDSHIPPACKAGENAME = dbo.UFN_STEWARDSHIPPACKAGE_GETNAME(DL.STEWARDSHIPPACKAGEPROCESSID)
,@ENDOWMENTMINAMOUNT = DL.ENDOWMENTMINAMOUNT
,@ENDOWMENTTARGETDATE = DL.ENDOWMENTTARGETDATE
,@ENDOWMENTMINAMOUNTDATEMET = DL.ENDOWMENTMINAMOUNTDATEMET
,@ISFULLYFUNDED = DL.ISFULLYFUNDED
,@ISENDOWED = DL.ISENDOWED
,@ADMINISTRATORID = DL.ADMINISTRATORID
,@ISACCEPTINGFUNDS = DL.ISACCEPTINGFUNDS
,@ISDISBURSINGMONEY = DL.ISDISBURSINGMONEY
,@BASECURRENCYID = DL.BASECURRENCYID
,@HASRECIPIENTS = DLT.HASRECIPIENTS
from dbo.DESIGNATIONLEVEL DL
inner join dbo.DESIGNATIONLEVELTYPE DLT on DL.DESIGNATIONLEVELTYPEID = DLT.ID
left join dbo.DESIGNATIONLEVELCATEGORYCODE as DLC on DL.DESIGNATIONLEVELCATEGORYCODEID = DLC.ID
left join dbo.DESIGNATIONREPORT1CODE DLRC1 on DL.DESIGNATIONREPORT1CODEID = DLRC1.ID
left join dbo.DESIGNATIONREPORT2CODE DLRC2 on DL.DESIGNATIONREPORT2CODEID = DLRC2.ID
where DL.ID = @ID
return 0
end