USP_DATAFORMTEMPLATE_PLANNEDGIFTASSET_ADDLOAD
The load procedure used by the edit dataform template "Planned Gift Asset Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PLANNEDGIFTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
| @CONSTITUENTLOOKUPID | nvarchar(36) | INOUT | |
| @CONSTITUENTFIRSTNAME | nvarchar(50) | INOUT | |
| @CONSTITUENTKEYNAME | nvarchar(100) | INOUT | |
| @CONSTITUENTID | uniqueidentifier | INOUT | |
| @TRANSACTIONCURRENCYID | uniqueidentifier | INOUT | Transaction currency ID |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PLANNEDGIFTASSET_ADDLOAD (
@PLANNEDGIFTID uniqueidentifier,
@CONSTITUENTLOOKUPID nvarchar(36) = null output,
@CONSTITUENTFIRSTNAME nvarchar(50) = null output,
@CONSTITUENTKEYNAME nvarchar(100) = null output,
@CONSTITUENTID uniqueidentifier = null output,
@TRANSACTIONCURRENCYID uniqueidentifier = null output
) as
set nocount on;
select
@CONSTITUENTLOOKUPID = CONSTITUENT.LOOKUPID,
@CONSTITUENTFIRSTNAME = CONSTITUENT.FIRSTNAME,
@CONSTITUENTKEYNAME = CONSTITUENT.KEYNAME,
@CONSTITUENTID = CONSTITUENT.ID,
@TRANSACTIONCURRENCYID = PLANNEDGIFT.TRANSACTIONCURRENCYID
from dbo.PLANNEDGIFT
inner join dbo.CONSTITUENT on CONSTITUENT.ID = PLANNEDGIFT.CONSTITUENTID
where PLANNEDGIFT.ID = @PLANNEDGIFTID;
return 0;