UFN_BATCHCONSTITUENTUPDATE_GETADDRESSES_WITHDATES

Returns all 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_GETADDRESSES_WITHDATES(
    @BATCHCONSTITUENTUPDATEID uniqueidentifier
) returns table
as
return
(
    select
        ID,
        UPDATEHOUSEHOLD,
        ADDRESSBLOCK,
        ENDDATE,
        STARTDATE,
        HISTORICALSTARTDATE,
        HISTORICALENDDATE,
        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,
        ADDRESSID,
        coalesce(ROWORIGINCODE, cast(0 as tinyint)) as ROWORIGINCODE
    from
        dbo.BATCHCONSTITUENTUPDATEADDRESSES
    where
        BATCHCONSTITUENTUPDATEID = @BATCHCONSTITUENTUPDATEID
);