UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES

Returns all addresses 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_GETADDRESSES(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        UPDATEHOUSEHOLD,
        ADDRESSBLOCK,
        ENDDATE,
        STARTDATE,
        HISTORICALSTARTDATE,
        ADDRESSTYPECODEID,
        CART,
        coalesce(CERTIFICATIONDATA, '0') as CERTIFICATIONDATA,
        CITY,
        CONGRESSIONALDISTRICTCODEID,
        COUNTRYID,
        COUNTYCODEID,
        DONOTMAIL,
        DONOTMAILREASONCODEID,
        DPC,
        INFOSOURCECODEID,
        ISPRIMARY,
        LASTVALIDATIONATTEMPTDATE,
        LOCALPRECINCTCODEID,
        LOT,
        OMITFROMVALIDATION,
        REGIONCODEID,
        STATEID,
        STATEHOUSEDISTRICTCODEID,
        STATESENATEDISTRICTCODEID,
        VALIDATIONMESSAGE,
        POSTCODE,
        SEQUENCE,
        INFOSOURCECOMMENTS
    from
        dbo.BATCHCONSTITUENTUPDATEADDRESSES
    where
        BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);