UFN_CONSTITUENT_GETEMAILADDRESSES_WITHDATES_FORUPDATEBATCH

This function returns a constituent's email addresses for the update batch given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CONSTITUENT_GETEMAILADDRESSES_WITHDATES_FORUPDATEBATCH(@CONSTITUENTID uniqueidentifier)
                returns table
                as return
                    select
                        EA.[EMAILADDRESSTYPECODEID],
                        coalesce(EA.[EMAILADDRESS], '') as EMAILADDRESS,
                        coalesce(EA.[ISPRIMARY], cast(0 as bit)) as ISPRIMARY,
                        coalesce(EA.[DONOTEMAIL], cast(0 as bit)) as DONOTEMAIL,
                        coalesce(EA.[SEQUENCE], cast(0 as bit)) as SEQUENCE,
                        cast(0 as bit) as UPDATEHOUSEHOLD,
                        EA.[STARTDATE],
                        EA.[ENDDATE],
            EA.[INFOSOURCECODEID],
                EA.ID as EMAILADDRESSID,
                EA.[DONOTEMAILREASONCODEID],
                EA.[INFOSOURCECOMMENTS]
                    from
                        dbo.[EMAILADDRESS] EA
                    where
                        EA.[CONSTITUENTID] = @CONSTITUENTID;