UFN_SITEID_MAPFROM_CONSTITUENTAPPEALID

        create function dbo.UFN_SITEID_MAPFROM_CONSTITUENTAPPEALID(@CONSTITUENTAPPEALID uniqueidentifier) 
        returns uniqueidentifier
        as
        begin

            DECLARE @ID uniqueidentifier;

            SELECT @ID=APPEAL.SITEID from dbo.CONSTITUENTAPPEAL
            inner join dbo.APPEAL on CONSTITUENTAPPEAL.APPEALID = APPEAL.ID
            where CONSTITUENTAPPEAL.ID=@CONSTITUENTAPPEALID;

            RETURN @ID;

        end