UFN_CONSTITUENTDATAREVIEWROLLBACKREASON_TRANSLATE

Return

Return Type
nvarchar(63)

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN

Definition

Copy


            create function dbo.UFN_CONSTITUENTDATAREVIEWROLLBACKREASON_TRANSLATE
            (
                @ID uniqueidentifier
            )
            returns nvarchar(63)
            as
            begin
                declare @TRANSLATION nvarchar(63)

                select @TRANSLATION = CODE + ' - ' + DESCRIPTION
                from dbo.CONSTITUENTDATAREVIEWROLLBACKREASON
                where ID = @ID

                return coalesce(@TRANSLATION, '')
            end