UFN_CONTACTPREFERENCES_GETFORMATS_3

Returns results from UFN_CONTACTPREFERENCES_GETFORMATS_3_WORKER and loads parameters.

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
@INDUSESEASONALADDRESS	bit	IN
@ORGMAILINGPREFERENCE	tinyint	IN
@INDALTADDRESS1TYPECODEID	uniqueidentifier	IN
@INDALTADDRESS1ISPRIMARY	bit	IN
@INDALTADDRESS2TYPECODEID	uniqueidentifier	IN
@INDALTADDRESS2ISPRIMARY	bit	IN
@ORGALTADDRESS1TYPECODEID	uniqueidentifier	IN
@ORGALTADDRESS1ISPRIMARY	bit	IN
@ORGALTADDRESS2TYPECODEID	uniqueidentifier	IN
@ORGALTADDRESS2ISPRIMARY	bit	IN
@INDINCLUDEWITHNOADDRESS	bit	IN
@ORGINCLUDEWITHNOADDRESS	bit	IN
@ORGINCLUDEWITHNOCONTACT	bit	IN
@ORGSENDTOALLCONTACTS	bit	IN
@INDUSECONSTITUENTPREFS	bit	IN
@ORGUSECONSTITUENTPREFS	bit	IN
@GROUPALTADDRESS1TYPECODEID	uniqueidentifier	IN
@GROUPALTADDRESS1ISPRIMARY	bit	IN
@GROUPALTADDRESS2TYPECODEID	uniqueidentifier	IN
@GROUPALTADDRESS2ISPRIMARY	bit	IN
@GROUPINCLUDEWITHNOADDRESS	bit	IN
@GROUPUSECONSTITUENTPREFS	bit	IN
@INDIVIDUALADDRESSEES	xml	IN
@ADDRESSEEFUNCTIONID	uniqueidentifier	IN
@INDIVIDUALSALUTATIONS	xml	IN
@SALUTATIONFUNCTIONID	uniqueidentifier	IN
@ORGADDRESSEES	xml	IN
@CONTACTADDRESSEEFUNCTIONID	uniqueidentifier	IN
@ORGSALUTATIONCODE	tinyint	IN
@ORGSALUTATIONS	xml	IN
@CONTACTSALUTATIONFUNCTIONID	uniqueidentifier	IN
@CONTACTSALUTATIONOPTIONCODE	tinyint	IN
@CUSTOMNAME	nvarchar(100)	IN
@GROUPADDRESSEES	xml	IN
@GROUPADDRESSEEFUNCTIONID	uniqueidentifier	IN
@GROUPSALUTATIONCODE	tinyint	IN
@GROUPSALUTATIONS	xml	IN
@GROUPSALUTATIONFUNCTIONID	uniqueidentifier	IN
@GROUPNOCONTACTOPTIONCODE	bit	IN
@GROUPNOCONTACTCUSTOMNAME	nvarchar(100)	IN
@JOINTRULETYPECODE	tinyint	IN
@JOINTSELECTIONID	uniqueidentifier	IN
@JOINTSELECTIONBOTHRULETYPECODE	tinyint	IN
@JOINTSELECTIONNEITHERRULETYPECODE	tinyint	IN

Definition

Copy



CREATE function dbo.UFN_CONTACTPREFERENCES_GETFORMATS_3(
  @NAMEFORMATPARAMETERID uniqueidentifier = null,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null,
  @MAILTYPE tinyint = null,
  @PARAMETERSETID uniqueidentifier = null,
  @SEASONALDATE datetime = null,
  @INCLUDEHOUSEHOLDPROCESSING bit = null,
  @INDUSESEASONALADDRESS bit = null,
  @ORGMAILINGPREFERENCE tinyint = null,
  @INDALTADDRESS1TYPECODEID uniqueidentifier = null,
  @INDALTADDRESS1ISPRIMARY bit = null,
  @INDALTADDRESS2TYPECODEID uniqueidentifier = null,
  @INDALTADDRESS2ISPRIMARY bit = null,
  @ORGALTADDRESS1TYPECODEID uniqueidentifier = null,
  @ORGALTADDRESS1ISPRIMARY bit = null,
  @ORGALTADDRESS2TYPECODEID uniqueidentifier = null,
  @ORGALTADDRESS2ISPRIMARY bit = null,
  @INDINCLUDEWITHNOADDRESS bit = null,
  @ORGINCLUDEWITHNOADDRESS bit = null,
  @ORGINCLUDEWITHNOCONTACT bit = null,
  @ORGSENDTOALLCONTACTS bit = null,
  @INDUSECONSTITUENTPREFS bit = null,
  @ORGUSECONSTITUENTPREFS bit = null,
  @GROUPALTADDRESS1TYPECODEID uniqueidentifier = null,
  @GROUPALTADDRESS1ISPRIMARY bit = null,
  @GROUPALTADDRESS2TYPECODEID uniqueidentifier = null,
  @GROUPALTADDRESS2ISPRIMARY bit = null,
  @GROUPINCLUDEWITHNOADDRESS bit = null,
  @GROUPUSECONSTITUENTPREFS bit = null,
  @INDIVIDUALADDRESSEES xml = null,
  @ADDRESSEEFUNCTIONID uniqueidentifier = null,
  @INDIVIDUALSALUTATIONS xml = null,
  @SALUTATIONFUNCTIONID uniqueidentifier = null,
  @ORGADDRESSEES xml = null,
  @CONTACTADDRESSEEFUNCTIONID uniqueidentifier = null,
  @ORGSALUTATIONCODE tinyint = null,
  @ORGSALUTATIONS xml = null,
  @CONTACTSALUTATIONFUNCTIONID uniqueidentifier = null,
  @CONTACTSALUTATIONOPTIONCODE tinyint = null,
  @CUSTOMNAME nvarchar(100) = null,
  @GROUPADDRESSEES xml = null,
  @GROUPADDRESSEEFUNCTIONID uniqueidentifier = null,
  @GROUPSALUTATIONCODE tinyint = null,
  @GROUPSALUTATIONS xml = null,
  @GROUPSALUTATIONFUNCTIONID uniqueidentifier = null,
  @GROUPNOCONTACTOPTIONCODE bit = null,
  @GROUPNOCONTACTCUSTOMNAME nvarchar(100) = null,
  @JOINTRULETYPECODE As tinyint = null,
  @JOINTSELECTIONID As uniqueidentifier = null,
  @JOINTSELECTIONBOTHRULETYPECODE As tinyint = null,
  @JOINTSELECTIONNEITHERRULETYPECODE As tinyint = null)  
returns table 
as
return
(
select
    CONSTITUENTID,
    ADDRESSEE,
    SALUTATION,
    CONTACT,
    ADDRESSID,
    HOUSEHOLDID,
    RETURNEDASHOUSEHOLDMEMBER,
    GROUPCONTACTID,
    POSITION,
    MAILTOCONSTITUENTID,
    CONTACTID,
    SPOUSEID
from dbo.UFN_CONTACTPREFERENCES_GETFORMATS_4(
    @NAMEFORMATPARAMETERID,
    @ADDRESSPROCESSINGOPTIONID,
    @MAILTYPE,
    @PARAMETERSETID,
    @SEASONALDATE,
    @INCLUDEHOUSEHOLDPROCESSING,
    @INDUSESEASONALADDRESS,
    @ORGMAILINGPREFERENCE,
    @INDALTADDRESS1TYPECODEID,
    @INDALTADDRESS1ISPRIMARY,
    @INDALTADDRESS2TYPECODEID,
    @INDALTADDRESS2ISPRIMARY,
    @ORGALTADDRESS1TYPECODEID,
    @ORGALTADDRESS1ISPRIMARY,
    @ORGALTADDRESS2TYPECODEID,
    @ORGALTADDRESS2ISPRIMARY,
    @INDINCLUDEWITHNOADDRESS,
    @ORGINCLUDEWITHNOADDRESS,
    @ORGINCLUDEWITHNOCONTACT,
    @ORGSENDTOALLCONTACTS,
    @INDUSECONSTITUENTPREFS,
    @ORGUSECONSTITUENTPREFS,
    @GROUPALTADDRESS1TYPECODEID,
    @GROUPALTADDRESS1ISPRIMARY,
    @GROUPALTADDRESS2TYPECODEID,
    @GROUPALTADDRESS2ISPRIMARY,
    @GROUPINCLUDEWITHNOADDRESS,
    @GROUPUSECONSTITUENTPREFS,
    @INDIVIDUALADDRESSEES,
    @ADDRESSEEFUNCTIONID,
    @INDIVIDUALSALUTATIONS,
    @SALUTATIONFUNCTIONID,
    @ORGADDRESSEES,
    @CONTACTADDRESSEEFUNCTIONID,
    @ORGSALUTATIONCODE,
    @ORGSALUTATIONS,
    @CONTACTSALUTATIONFUNCTIONID,
    @CONTACTSALUTATIONOPTIONCODE,
    @CUSTOMNAME,
    @GROUPADDRESSEES,
    @GROUPADDRESSEEFUNCTIONID,
    @GROUPSALUTATIONCODE,
    @GROUPSALUTATIONS,
    @GROUPSALUTATIONFUNCTIONID,
    @GROUPNOCONTACTOPTIONCODE,
    @GROUPNOCONTACTCUSTOMNAME,
    @JOINTRULETYPECODE,
    @JOINTSELECTIONID,
    @JOINTSELECTIONBOTHRULETYPECODE,
    @JOINTSELECTIONNEITHERRULETYPECODE,
    0)  
)