UFN_CONTACTPREFERENCES_GETFORMATS

Returns address and name formats according to contact preference settings.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@NAMEFORMATPARAMETERID	uniqueidentifier	IN
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN
@MAILTYPE	tinyint	IN
@PARAMETERSETID	uniqueidentifier	IN
@SEASONALDATE	datetime	IN
@INCLUDEHOUSEHOLDPROCESSING	bit	IN

Definition

Copy



        CREATE function dbo.UFN_CONTACTPREFERENCES_GETFORMATS
            (@NAMEFORMATPARAMETERID uniqueidentifier,
            @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
            @MAILTYPE tinyint,
            @PARAMETERSETID uniqueidentifier,
            @SEASONALDATE datetime,
            @INCLUDEHOUSEHOLDPROCESSING bit)
        returns table
        as
        return
            (
            select 
                NF.CONSTITUENTID,
                NF.ADDRESSEE,    
                NF.SALUTATION,
                NF.CONTACT,
                NF.POSITION,
                A.ADDRESSBLOCK,
                A.CITY,
                dbo.UFN_STATE_GETABBREVIATION(A.[STATEID]) STATE,
                A.POSTCODE,
                dbo.UFN_COUNTRY_GETDESCRIPTION(A.[COUNTRYID]) COUNTRY,
                NF.CONTACTID,
                NF.HOUSEHOLDID,
                NF.RETURNEDASHOUSEHOLDMEMBER,
                NF.GROUPCONTACTID,
                coalesce(NF.CONTACTID, NF.GROUPCONTACTID, NF.CONSTITUENTID) as CONTACTORCONSTITUENTID,
                NF.ADDRESSID,
                NF.MAILTOCONSTITUENTID,
                NF.SPOUSEID
            from dbo.UFN_CONTACTPREFERENCES_GETFORMATS_3(
            @NAMEFORMATPARAMETERID,
            @ADDRESSPROCESSINGOPTIONID,
            @MAILTYPE,
            @PARAMETERSETID,
            @SEASONALDATE,
            @INCLUDEHOUSEHOLDPROCESSING,
            default, default, default, default, default, default, default, default, default, default, default, default, default, default, default,
            default, default, default, default, default, default, default, default, default, default, default, default, default, default, default,
            default, default, default, default, default, default, default, default, default, default, default, default, default, default
            ) NF
            left outer join dbo.ADDRESS A
                on A.ID = NF.ADDRESSID

            )