UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDEDSUMMARY

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode
@NAMEFORMATPARAMETERID	uniqueidentifier	IN
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	IN
@PARAMETERSETID	uniqueidentifier	IN
@SEASONALDATE	datetime	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_QUERY_PLEDGEREMINDEROUTPUTEXTENDEDSUMMARY]
            (
                @NAMEFORMATPARAMETERID uniqueidentifier,
                @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
                @PARAMETERSETID uniqueidentifier = null,
                @SEASONALDATE datetime = null,
                @INDUSESEASONALADDRESS bit,    
                @ORGMAILINGPREFERENCE tinyint,
                @INDALTADDRESS1TYPECODEID uniqueidentifier,
                @INDALTADDRESS1ISPRIMARY bit,
                @INDALTADDRESS2TYPECODEID uniqueidentifier,
                @INDALTADDRESS2ISPRIMARY bit,
                @ORGALTADDRESS1TYPECODEID uniqueidentifier,
                @ORGALTADDRESS1ISPRIMARY bit,
                @ORGALTADDRESS2TYPECODEID uniqueidentifier,
                @ORGALTADDRESS2ISPRIMARY bit,
                @INDINCLUDEWITHNOADDRESS bit,
                @ORGINCLUDEWITHNOADDRESS bit,
                @ORGINCLUDEWITHNOCONTACT bit,
                @ORGSENDTOALLCONTACTS bit,
                @INDUSECONSTITUENTPREFS bit,
                @ORGUSECONSTITUENTPREFS bit,
                @GROUPALTADDRESS1TYPECODEID uniqueidentifier,
                @GROUPALTADDRESS1ISPRIMARY bit,
                @GROUPALTADDRESS2TYPECODEID uniqueidentifier,
                @GROUPALTADDRESS2ISPRIMARY bit,
                @GROUPINCLUDEWITHNOADDRESS bit,
                @GROUPUSECONSTITUENTPREFS bit,
                @INDIVIDUALADDRESSEES xml,
                @ADDRESSEEFUNCTIONID uniqueidentifier,
                @INDIVIDUALSALUTATIONS xml,
                @SALUTATIONFUNCTIONID uniqueidentifier,
                @ORGADDRESSEES xml,
                @CONTACTADDRESSEEFUNCTIONID uniqueidentifier,
                @ORGSALUTATIONCODE tinyint,
                @ORGSALUTATIONS xml,
                @CONTACTSALUTATIONFUNCTIONID uniqueidentifier,
                @CONTACTSALUTATIONOPTIONCODE tinyint,
                @CUSTOMNAME nvarchar(100),
                @GROUPADDRESSEES xml,
                @GROUPADDRESSEEFUNCTIONID uniqueidentifier,
                @GROUPSALUTATIONCODE tinyint,
                @GROUPSALUTATIONS xml,
                @GROUPSALUTATIONFUNCTIONID uniqueidentifier,
                @GROUPNOCONTACTOPTIONCODE bit,
                @GROUPNOCONTACTCUSTOMNAME nvarchar(100),
                @JOINTRULETYPECODE As tinyint,
                @JOINTSELECTIONID As uniqueidentifier,
                @JOINTSELECTIONBOTHRULETYPECODE As tinyint,
                @JOINTSELECTIONNEITHERRULETYPECODE As tinyint                            
            )
            returns table
            as
            return
            (
              select  DISTINCT top(100) PERCENT  
                  CONSTITUENTLOOKUPID,
                  CONSTITUENTNAME,
                  ADDRESSEE,
          SALUTATION,
          CONTACTADDRESSEE,
          POSITION,
                  ADDRESSBLOCK,
          CITY,
          STATE,
          POSTCODE,
          COUNTRY
              from dbo.UFN_QUERY_PLEDGEREMINDEROUTPUTEXTENDED(
                    @NAMEFORMATPARAMETERID, 
                    @ADDRESSPROCESSINGOPTIONID, 
                    @PARAMETERSETID, 
                    @SEASONALDATE,
                    @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
                )
            order by CONSTITUENTLOOKUPID
            )