V_QUERY_EVENTDESIGNATION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| EVENTID | uniqueidentifier | yes | |
| DESIGNATIONNAME | nvarchar(512) | ||
| ISDEFAULT | bit | ||
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes | |
| DATEADDED | datetime | ||
| DATECHANGED | datetime | ||
| TSLONG | bigint | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:44:08 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_EVENTDESIGNATION AS
select
EVENTDESIGNATION.ID,
EVENTDESIGNATION.EVENTID,
DESIGNATION.NAME as DESIGNATIONNAME,
EVENTDESIGNATION.[DEFAULT] as ISDEFAULT,
ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
ADDEDBY.USERNAME as ADDEDBY_USERNAME,
CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
EVENTDESIGNATION.DATEADDED,
EVENTDESIGNATION.DATECHANGED,
EVENTDESIGNATION.TSLONG
/*#EXTENSION*/
from dbo.EVENTDESIGNATION
inner join dbo.DESIGNATION on EVENTDESIGNATION.DESIGNATIONID = DESIGNATION.ID
left join dbo.CHANGEAGENT as ADDEDBY ON ADDEDBY.ID = EVENTDESIGNATION.ADDEDBYID
left join dbo.CHANGEAGENT as CHANGEDBY ON CHANGEDBY.ID = EVENTDESIGNATION.CHANGEDBYID