V_QUERY_SOLICITCODECHANNELOPTOUT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | ||
| SOLICITCODECHANNELCODE | tinyint | ||
| SOLICITCODECHANNEL | nvarchar(14) | yes | |
| CONSENT | nvarchar(16) | yes | |
| CONSENTCODE | tinyint | ||
| SOURCECODEID | uniqueidentifier | yes | |
| SOURCEEVIDENCECODE | nvarchar(100) | yes | |
| STARTDATE | date | ||
| COMMENTS | nvarchar(255) | ||
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 7/27/2018 10:10:20 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.182.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SOLICITCODECHANNELOPTOUT AS
select
SOLICITCODECHANNELOPTOUT.ID,
SOLICITCODECHANNELOPTOUT.CONSTITUENTID,
SOLICITCODECHANNELOPTOUT.SOLICITCODECHANNELCODE,
SOLICITCODECHANNELOPTOUT.SOLICITCODECHANNEL,
case SOLICITCODECHANNELOPTOUT.CONSENTCODE
when 1 then 'EU consent'
else SOLICITCODECHANNELOPTOUT.CONSENT
end as CONSENT,
SOLICITCODECHANNELOPTOUT.CONSENTCODE,
SOLICITCODECHANNELOPTOUT.SOURCECODEID,
DATAPROTECTIONEVIDENCESOURCECODE.DESCRIPTION as SOURCEEVIDENCECODE,
SOLICITCODECHANNELOPTOUT.STARTDATE,
SOLICITCODECHANNELOPTOUT.COMMENTS,
SOLICITCODECHANNELOPTOUT.DATEADDED,
SOLICITCODECHANNELOPTOUT.DATECHANGED,
SOLICITCODECHANNELOPTOUT.TSLONG,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME]
from
dbo.SOLICITCODECHANNELOPTOUT
left join dbo.CONSTITUENTSOLICITCODE on CONSTITUENTSOLICITCODE.SOLICITCODECHANNELOPTOUTID = SOLICITCODECHANNELOPTOUT.ID
left join dbo.DATAPROTECTIONEVIDENCESOURCECODE on CONSTITUENTSOLICITCODE.SOURCECODEID = DATAPROTECTIONEVIDENCESOURCECODE.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = CONSTITUENTSOLICITCODE.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = CONSTITUENTSOLICITCODE.CHANGEDBYID