V_QUERY_ADDRESSEE_SALUTATION
This provides the ability to query for addressee and\or salutation information.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECORDID | int | yes | System record ID |
| ID | uniqueidentifier | Constituent ID | |
| PRIMARYADDRESSEE | nvarchar(700) | yes | Primary addressee |
| PRIMARYSALUTATION | nvarchar(700) | yes | Primary salutation |
| ADDEDBY_APPLICATION | varchar(1) | Added by application | |
| ADDEDBY_USERNAME | varchar(1) | Added by user name | |
| CHANGEDBY_APPLICATION | varchar(1) | Changed by application | |
| CHANGEDBY_USERNAME | varchar(1) | Changed by user name | |
| DATEADDED | int | yes | Date added |
| DATECHANGED | int | yes | Date changed |
| TSLONG | int | yes | Timestamp value |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:41:55 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_ADDRESSEE_SALUTATION AS
select
null as RECORDID,
CONSTITUENT.ID as ID,
(select
case
when len(NFSUB.CUSTOMNAME) > 0 then NFSUB.CUSTOMNAME
when NFSUB.NAMEFORMATFUNCTIONID is not null then dbo.UFN_NAMEFORMAT_FROMID(NFSUB.NAMEFORMATFUNCTIONID, CONSTITUENT.ID)
else NFSUB.CUSTOMNAME
end
from dbo.NAMEFORMAT NFSUB
where
NFSUB.CONSTITUENTID = CONSTITUENT.ID and
NFSUB.PRIMARYADDRESSEE = 1) as PRIMARYADDRESSEE,
(select
case
when len(NFSUB.CUSTOMNAME) > 0 then NFSUB.CUSTOMNAME
when NFSUB.NAMEFORMATFUNCTIONID is not null then dbo.UFN_NAMEFORMAT_FROMID(NFSUB.NAMEFORMATFUNCTIONID, CONSTITUENT.ID)
else NFSUB.CUSTOMNAME
end
from dbo.NAMEFORMAT NFSUB
where
NFSUB.CONSTITUENTID = CONSTITUENT.ID and
NFSUB.PRIMARYSALUTATION = 1) as PRIMARYSALUTATION,
'' as [ADDEDBY_APPLICATION],
'' as [ADDEDBY_USERNAME],
'' as [CHANGEDBY_APPLICATION],
'' as [CHANGEDBY_USERNAME],
null as DATEADDED,
null as DATECHANGED,
null as TSLONG
from
dbo.CONSTITUENT