V_QUERY_SOCIALMEDIAACCOUNTWP
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| CONSTITUENTID | uniqueidentifier | ||
| SOCIALMEDIASERVICENAME | nvarchar(100) | ||
| USERID | nvarchar(100) | ||
| URL | UDT_WEBADDRESS | ||
| SOCIALMEDIAACCOUNTTYPECODEDESCRIPTION | nvarchar(100) | yes | |
| INFOSOURCECODEDESCRIPTION | nvarchar(100) | yes | |
| DONOTCONTACT | bit | ||
| CONFIRMED | bit | ||
| DATECONFIRMED | datetime | yes | |
| CONFIRMEDBYAPPUSERID | uniqueidentifier | yes | |
| REJECTED | bit | ||
| DATEREJECTED | datetime | yes | |
| REJECTEDBYAPPUSERID | uniqueidentifier | yes | |
| 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 | |
| MC | nvarchar(3) | ||
| MCDESCRIPTION | nvarchar(100) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 9/30/2015 12:58:23 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.153.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_SOCIALMEDIAACCOUNTWP AS
select
SMA.ID,
SMA.CONSTITUENTID,
SOCIALMEDIASERVICE.NAME SOCIALMEDIASERVICENAME,
SMA.USERID,
SMA.URL,
SOCIALMEDIAACCOUNTTYPECODE.DESCRIPTION SOCIALMEDIAACCOUNTTYPECODEDESCRIPTION,
INFOSOURCECODE.DESCRIPTION INFOSOURCECODEDESCRIPTION,
SMA.DONOTCONTACT,
SMA.CONFIRMED,
SMA.DATECONFIRMED,
SMA.CONFIRMEDBYAPPUSERID,
SMA.REJECTED,
SMA.DATEREJECTED,
SMA.REJECTEDBYAPPUSERID,
SMA.DATEADDED,
SMA.DATECHANGED,
SMA.TSLONG,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
SMA.WPMATCHCODE as MC,
dbo.UFN_WPMATCHCODE_DESCRIPTION(SMA.WPMATCHCODE) MCDESCRIPTION
/*#EXTENSION*/
from
dbo.SOCIALMEDIAACCOUNT SMA
inner join dbo.SOCIALMEDIASERVICE on SOCIALMEDIASERVICE.ID = SMA.SOCIALMEDIASERVICEID
inner join dbo.CONSTITUENT on SMA.CONSTITUENTID = CONSTITUENT.ID and CONSTITUENT.ISGROUP = 0 and CONSTITUENT.ISORGANIZATION = 0
left join dbo.SOCIALMEDIAACCOUNTTYPECODE on SOCIALMEDIAACCOUNTTYPECODE.ID = SMA.SOCIALMEDIAACCOUNTTYPECODEID
left join dbo.INFOSOURCECODE on INFOSOURCECODE.ID = SMA.INFOSOURCECODEID
left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = SMA.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = SMA.CHANGEDBYID