UFN_QUERY_INVITATIONPROCESSOUTPUT

                CREATE function [dbo].[UFN_QUERY_INVITATIONPROCESSOUTPUT]
                (
                    @NAMEFORMATPARAMETERID uniqueidentifier,
                    @ADDRESSPROCESSINGOPTIONID uniqueidentifier,
                    @PARAMETERSETID uniqueidentifier,
                    @SEASONALDATE datetime
                )
                returns table
                as
                return
                    (                
                        select
                            INVITEE.ID as INVITEEID,
                            INVITEE.CONSTITUENTID as CONSTITUENTID,
                            CONSTITUENT.LOOKUPID as LOOKUPID,
                            EVENT.NAME as EVENTNAME,
                            NF.NAME as CONSTITUENTNAME,
                            prefs.ADDRESSEE as ADDRESSEE,
                            prefs.SALUTATION as SALUTATION,
                            prefs.CONTACT CONTACTADDRESSEE,
                            prefs.POSITION POSITION,
                            prefs.ADDRESSBLOCK as ADDRESSBLOCK,
                            prefs.CITY as CITY,
                            prefs.STATE as STATE,
                            prefs.POSTCODE as POSTCODE,
                            prefs.COUNTRY as COUNTRY
                        from
                            dbo.INVITEE
                            left join dbo.EVENT on INVITEE.EVENTID = EVENT.ID
                            left join dbo.CONSTITUENT on INVITEE.CONSTITUENTID = CONSTITUENT.ID
                            inner join dbo.UFN_CONTACTPREFERENCES_GETFORMATS(@NAMEFORMATPARAMETERID,@ADDRESSPROCESSINGOPTIONID,2,@PARAMETERSETID,@SEASONALDATE,0) as prefs on CONSTITUENT.ID = prefs.CONSTITUENTID
                            outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                    )