UFN_BATCHCONSTITUENTUPDATE_GETEMAILADDRESSES_WITHDATES_2

Returns all email addresses 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_GETEMAILADDRESSES_WITHDATES_2(
        @BATCHCONSTITUENTUPDATEID uniqueidentifier
    ) returns table
    as
    return
    (
        select
            ID,
            UPDATEHOUSEHOLD,
            EMAILADDRESSTYPECODEID,
            EMAILADDRESS,
            ISPRIMARY,
            DONOTEMAIL,
            SEQUENCE,
            STARTDATE,
            ENDDATE,
            INFOSOURCECODEID,
            EMAILADDRESSID,
            coalesce(ROWORIGINCODE, cast(0 as tinyint)) as ROWORIGINCODE,
            DONOTEMAILREASONCODEID,
            INFOSOURCECOMMENTS
        from
            dbo.BATCHCONSTITUENTUPDATEEMAILADDRESSES
        where
            BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
    );