UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_UNIQUERELATIONSHIPFORORGANIZATION
Checks that the mapped relationship information on the matching gift condition is uniquely mapped on a per organization basis.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MATCHINGGIFTCONDITIONID | uniqueidentifier | IN | |
| @RELATIONSHIPTYPECODEID | uniqueidentifier | IN | |
| @JOBSCHEDULECODEID | uniqueidentifier | IN | |
| @CAREERLEVELCODEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_UNIQUERELATIONSHIPFORORGANIZATION
(
@MATCHINGGIFTCONDITIONID uniqueidentifier,
@RELATIONSHIPTYPECODEID uniqueidentifier,
@JOBSCHEDULECODEID uniqueidentifier,
@CAREERLEVELCODEID uniqueidentifier
)
returns bit with execute as caller
as
begin
declare @ORGANIZATIONID uniqueidentifier;
declare @REVENUETYPECODE tinyint;
select
@ORGANIZATIONID = ORGANIZATIONID,
@REVENUETYPECODE = REVENUETYPECODE
from
dbo.MATCHINGGIFTCONDITION
where
MATCHINGGIFTCONDITION.ID = @MATCHINGGIFTCONDITIONID;
return dbo.UFN_MATCHINGGIFTCONDITIONRELATIONSHIP_UNIQUERELATIONSHIPFORORGANIZATION_2(@MATCHINGGIFTCONDITIONID, @RELATIONSHIPTYPECODEID, @JOBSCHEDULECODEID, @CAREERLEVELCODEID, @ORGANIZATIONID, @REVENUETYPECODE);
end