UFN_BATCHCONSTITUENTUPDATE_GETPHONES

Returns all phones for a given batch constituentupdate record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHCONSTITUENTUPDATEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_BATCHCONSTITUENTUPDATE_GETPHONES(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        UPDATEHOUSEHOLD,
        PHONETYPECODEID,
        NUMBER,
        ISPRIMARY,
        DONOTCALL,
        SEQUENCE, 
        COUNTRYID,
        SEASONALSTARTDATE,
        SEASONALENDDATE,
        STARTTIME,
        ENDTIME,
        INFOSOURCECODEID
    from
        dbo.BATCHCONSTITUENTUPDATEPHONES
    where
        BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);