V_QUERY_ADDRESSPROCESSINGOPTIONADDRESSES
Returns the addresses selected by address processing options.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ADDRESSID | uniqueidentifier | yes | ADDRESSID |
| ADDRESSPROCESSINGOPTION | nvarchar(100) | Address Processing Option | |
| MAILTYPE | varchar(29) | Mail type | |
| CONSTITUENTID | uniqueidentifier | CONSTITUENTID | |
| ADDRESSPROCESSINGOPTIONID | uniqueidentifier |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 1:00:10 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_ADDRESSPROCESSINGOPTIONADDRESSES AS
select
ADDRESS.ADDRESSID ADDRESSID,
APO.NAME ADDRESSPROCESSINGOPTION,
MAILTYPE.MAILTYPE,
CONSTITUENT.ID CONSTITUENTID,
[APO].[ID] as [ADDRESSPROCESSINGOPTIONID]
from dbo.CONSTITUENT
cross join dbo.ADDRESSPROCESSINGOPTION as APO
cross join (
select 0 MAILTYPECODE, 'Revenue Acknowledgements' MAILTYPE union all
select 1, 'Appeals' union all
select 2, 'Events' union all
select 3, 'General Correspondence' union all
select 4, 'Reminders' union all
select 5, 'Receipts' union all
select 6, 'Planned Gift Acknowledgements' union all
select 7, 'Tribute Acknowledgements' union all
select 8, 'Stewardship'
) MAILTYPE
cross apply dbo.UFN_ADDRESSPROCESS_ADDRESSES_CONSTITUENT(
CONSTITUENT.ID,
APO.ID,
MAILTYPE.MAILTYPECODE,
null,
getdate(),
0, -- household processing option
APO.INDUSESEASONALADDRESS,
APO.ORGMAILINGPREFERENCE,
APO.INDALTADDRESS1TYPECODEID,
APO.INDALTADDRESS1ISPRIMARY,
APO.INDALTADDRESS2TYPECODEID,
APO.INDALTADDRESS2ISPRIMARY,
APO.ORGALTADDRESS1TYPECODEID,
APO.ORGALTADDRESS1ISPRIMARY,
APO.ORGALTADDRESS2TYPECODEID,
APO.ORGALTADDRESS2ISPRIMARY,
APO.INDINCLUDEWITHNOADDRESS,
APO.ORGINCLUDEWITHNOADDRESS,
APO.ORGINCLUDEWITHNOCONTACT,
APO.ORGSENDTOALLCONTACTS,
APO.INDUSECONSTITUENTPREFS,
APO.ORGUSECONSTITUENTPREFS,
APO.GROUPALTADDRESS1TYPECODEID,
APO.GROUPALTADDRESS1ISPRIMARY,
APO.GROUPALTADDRESS2TYPECODEID,
APO.GROUPALTADDRESS2ISPRIMARY,
APO.GROUPINCLUDEWITHNOADDRESS,
APO.GROUPUSECONSTITUENTPREFS
) as ADDRESS