UFN_GENERALPURPOSEEMAIL_GETSTATUS_FORDISPLAY

create function dbo.UFN_GENERALPURPOSEEMAIL_GETSTATUS_FORDISPLAY
(
    @STATUSID uniqueidentifier
)
returns table
as return
    select 
        ID, 
        EMAILQUEUEGENERALPURPOSEID, 
        STATUS, 
        STATUSMESSAGE, 
        DATEADDED, 
        EXTERNALJOBIDENTITY, 
        dbo.UFN_TIMEZONEENTRY_GETSYSTEMDEFAULTDATEFROMUTC(PROCESSAFTERDATE) as PROCESSAFTERDATE
    from dbo.EMAILSTATUSGENERALPURPOSE
    where ID = @STATUSID;