UFN_COAUPDATE_STEPCODE_GETID

/*
Generated by Blackbaud AppFx Platform
Date:  7/26/2016 4:01:59 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=4.0.162.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE FUNCTION dbo.UFN_COAUPDATE_STEPCODE_GETID(@Description nvarchar(15))
RETURNS tinyint WITH EXECUTE AS CALLER
AS
begin

    return case @Description
        when 'Last run on:' then 0
        when 'Created on:' then 1
        when 'Submitted on:' then 2
        when 'Received on:' then 3
        when 'Committed on:' then 4
        when 'Resubmitted on:' then 5
        else -1
        end 

end