UFN_CONSTITUENT_GETMOSTRECENTLYCHANGEDRECOGNITIONPROGRAM

            CREATE function dbo.UFN_CONSTITUENT_GETMOSTRECENTLYCHANGEDRECOGNITIONPROGRAM
            (
                @CONSTITUENTID uniqueidentifier
            )
            returns table
            as
            return
            (
                select top 1
                    RECOGNITIONPROGRAM.NAME as RECOGNITIONPROGRAM,
                    RECOGNITIONLEVEL.NAME as RECOGNITIONLEVEL
                from dbo.CONSTITUENTRECOGNITION
                inner join dbo.RECOGNITIONPROGRAM on CONSTITUENTRECOGNITION.RECOGNITIONPROGRAMID = RECOGNITIONPROGRAM.ID
                inner join dbo.RECOGNITIONLEVEL on CONSTITUENTRECOGNITION.RECOGNITIONLEVELID = RECOGNITIONLEVEL.ID
                where
                    CONSTITUENTRECOGNITION.CONSTITUENTID = @CONSTITUENTID and
                    -- Make sure the constituent is still active in this program

                    CONSTITUENTRECOGNITION.STATUSCODE = 0 and -- Active

                    CONSTITUENTRECOGNITION.EXPIRATIONDATE >= dbo.UFN_DATE_GETEARLIESTTIME(getdate())
                order by CONSTITUENTRECOGNITION.DATECHANGED desc
            )