UFN_BATCHCONSTITUENTUPDATE_GETPHONES_WITHDATES

Returns all phones for a given batch constituent update record with start and end dates.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETPHONES_WITHDATES(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
        select
        ID,
        UPDATEHOUSEHOLD,
        PHONETYPECODEID,
        NUMBER,
        ISPRIMARY,
        DONOTCALL,
        SEQUENCE, 
        COUNTRYID,
        SEASONALSTARTDATE,
        SEASONALENDDATE,
        STARTTIME,
        ENDTIME,
        STARTDATE,
        ENDDATE,
        INFOSOURCECODEID,
        PHONEID,
        coalesce(ROWORIGINCODE, cast(0 as tinyint)) as ROWORIGINCODE,
        DONOTTEXT,
        INFOSOURCECOMMENTS
        from
        dbo.BATCHCONSTITUENTUPDATEPHONES
        where
        BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);