fnGetRaisersEdgeRecordIDFromPeopleID
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PeopleID | int | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnGetRaisersEdgeRecordIDFromPeopleID](@PeopleID int)
RETURNS int AS
BEGIN
DECLARE @RaisersEdgeRecordID int
SELECT @RaisersEdgeRecordID = BackOfficeRecordID
FROM dbo.BackOfficeSystemPeople
WHERE
[ID] = @PeopleID
AND BackOfficeSystemID = 0
return @RaisersEdgeRecordID
END