UFN_PHONEFINDER_GETLASTRUNDATE

Retrieves the last date a step in the PhoneFinder process was run.

Return

Return Type
datetime

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_PHONEFINDER_GETLASTRUNDATE
(
    @ID uniqueidentifier
)
returns datetime
as begin
    declare @DATELASTRUN datetime = null;

    select 
        @DATELASTRUN = max(PROCESSSTEPS.[DATELASTRUN])
    from
        (
            select 
                PHONEFINDERSUBMITPROCESS.[DATELASTRUN],
                PHONEFINDERSUBMITPROCESS.[PHONEFINDERID]
            from
                dbo.PHONEFINDERSUBMITPROCESS

            union all

            select 
                PHONEFINDERGETPROCESS.[DATELASTRUN],
                PHONEFINDERGETPROCESS.[PHONEFINDERID]
            from
                dbo.PHONEFINDERGETPROCESS

            union all

            select
                PHONEFINDERRESUBMITPROCESS.[DATELASTRUN],
                PHONEFINDERRESUBMITPROCESS.[PHONEFINDERID]
            from
                dbo.PHONEFINDERRESUBMITPROCESS

            union all

            select
                BATCH.[DATECOMMITTED],
                PHONEFINDER.[ID]
            from
                dbo.PHONEFINDER
                inner join dbo.BATCH on BATCH.[ID] = PHONEFINDER.[BATCHID]
            where
                BATCH.[STATUSCODE] = 1 -- Committed


        ) as [PROCESSSTEPS]
    where
        PROCESSSTEPS.[PHONEFINDERID] = @ID;
    return @DATELASTRUN;
end