UFN_RECURRINGGIFT_GETSTATUSCODE

            create function dbo.UFN_RECURRINGGIFT_GETSTATUSCODE
            (
                @REVENUEID uniqueidentifier
            )
            returns tinyint
            with execute as caller
            as begin
                declare @retVal tinyint;

                select @retVal = coalesce(STATUSCODE, 0)
                from REVENUESCHEDULE
                where REVENUESCHEDULE.ID = @REVENUEID

                return @retVal
            end