V_QUERY_INVITEEPROCESS_EMAILOUTPUT
View used for constituent email output with the invitation process.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| INVITEEID | uniqueidentifier | Invitee ID | |
| CONSTITUENTID | uniqueidentifier | Constituent system ID | |
| LOOKUPID | nvarchar(100) | yes | Constituent lookup ID |
| EVENTNAME | nvarchar(100) | yes | Event name |
| CONSTITUENTNAME | nvarchar(154) | yes | Constituent name |
| ADDRESSEE | nvarchar(700) | yes | Primary addressee |
| SALUTATION | nvarchar(700) | yes | Salutation |
| CONTACT | nvarchar(154) | yes | Contact |
| POSITION | nvarchar(100) | yes | Position |
| EMAILADDRESS | UDT_EMAILADDRESS | yes | Email address |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:44:02 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_INVITEEPROCESS_EMAILOUTPUT AS
select
INVITEE.ID as INVITEEID,
INVITEE.CONSTITUENTID as CONSTITUENTID,
CONSTITUENT.LOOKUPID as LOOKUPID,
EVENT.NAME as EVENTNAME,
NF.NAME as CONSTITUENTNAME,
(select FORMATTEDNAME from dbo.NAMEFORMAT where NAMEFORMAT.CONSTITUENTID = CONSTITUENT.ID and NAMEFORMAT.PRIMARYADDRESSEE = 1) as ADDRESSEE,
(select FORMATTEDNAME from dbo.NAMEFORMAT where NAMEFORMAT.CONSTITUENTID = CONSTITUENT.ID and NAMEFORMAT.PRIMARYSALUTATION = 1) as SALUTATION,
NF_CONTACT.NAME as CONTACT,
(select top 1 RELATIONSHIP.POSITION
from dbo.RELATIONSHIP
where RELATIONSHIP.RECIPROCALCONSTITUENTID = EMAILADDRESS.CONTACTID
and RELATIONSHIP.RELATIONSHIPCONSTITUENTID = CONSTITUENT.ID) as POSITION,
EMAILADDRESS.EMAILADDRESS as EMAILADDRESS
from dbo.INVITEE
inner join dbo.[UFN_ADDRESSPROCESS_EMAILS](2, null) as EMAILADDRESS on INVITEE.CONSTITUENTID = EMAILADDRESS.CONSTITUENTID
left join dbo.EVENT on INVITEE.EVENTID = EVENT.ID
left join dbo.CONSTITUENT on INVITEE.CONSTITUENTID = CONSTITUENT.ID
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EMAILADDRESS.CONTACTID) NF_CONTACT