UFN_CONSTITID_MAPFROM_CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID

Maps a CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID to a ConstituentID

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_CONSTITID_MAPFROM_CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID(@CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID uniqueidentifier) 
returns uniqueidentifier
as
begin

    DECLARE @ID uniqueidentifier;

    SELECT @ID=CONSTITUENTID from dbo.CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENT where ID=@CONSTIT_SECURITY_ATTRIBUTE_ASSIGNMENTID;

    RETURN @ID;

end