V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSSUMMARY
View used for standard output for the pledge reminder seasonal address summary when grouping by revenue is chosen.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| CONSTITUENTLOOKUPID | nvarchar(100) | yes | Constituent lookup ID |
| CONSTITUENTNAME | nvarchar(154) | yes | Constituent name |
| PRIMARYADDRESSEE | nvarchar(700) | yes | Primary addressee |
| PRIMARYSALUTATION | nvarchar(700) | yes | Primary salutation |
| PRIMARYCONTACT | nvarchar(154) | yes | Primary contact |
| ADDRESSBLOCK | nvarchar(150) | yes | Address block |
| CITY | nvarchar(50) | yes | City |
| STATE | nvarchar(50) | yes | State |
| POSTCODE | nvarchar(12) | yes | Post code |
| COUNTRY | nvarchar(100) | yes | Country |
| EMAILADDRESS | UDT_EMAILADDRESS | yes | Email address |
| POSITION | nvarchar(100) | yes | Position |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:35:58 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_PLEDGEREMINDERPROCESSSEASONALADDRESSSUMMARY AS
select DISTINCT top(100) PERCENT
CONSTITUENTLOOKUPID,
CONSTITUENTNAME,
PRIMARYADDRESSEE,
PRIMARYSALUTATION,
PRIMARYCONTACT,
ADDRESSBLOCK,
CITY,
STATE,
POSTCODE,
COUNTRY,
EMAILADDRESS,
POSITION
from V_QUERY_PLEDGEREMINDERPROCESS_SEASONALADDRESSOUTPUT
order by CONSTITUENTLOOKUPID