V_QUERY_ANALYTICSPROJECTDISTRIBUTION
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| 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 | |
| MODELINGANDPROPENSITYDELIVERYID | uniqueidentifier | yes | |
| ANALYTICSMODELID | uniqueidentifier | yes | |
| ANALYTICSMODELNAME | nvarchar(100) | yes | |
| SCORECATEGORY | int | ||
| FREQUENCY | int | ||
| ANALYTICSPROJECTID | uniqueidentifier |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:38:48 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_ANALYTICSPROJECTDISTRIBUTION AS
select
ANALYTICSPROJECTDISTRIBUTION.ID,
ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
ANALYTICSPROJECTDISTRIBUTION.DATEADDED,
ANALYTICSPROJECTDISTRIBUTION.DATECHANGED,
ANALYTICSPROJECTDISTRIBUTION.TSLONG,
MODELINGANDPROPENSITYDELIVERY.ID as MODELINGANDPROPENSITYDELIVERYID,
ANALYTICSMODEL.ID as ANALYTICSMODELID,
ANALYTICSMODEL.NAME as ANALYTICSMODELNAME,
ANALYTICSPROJECTDISTRIBUTION.SCORECATEGORY,
ANALYTICSPROJECTDISTRIBUTION.FREQUENCY,
ANALYTICSPROJECTDISTRIBUTION.ANALYTICSPROJECTID
/*#EXTENSION*/
from
dbo.ANALYTICSPROJECTDISTRIBUTION
left join dbo.MODELINGANDPROPENSITYDELIVERY on MODELINGANDPROPENSITYDELIVERY.ANALYTICSMODELID = ANALYTICSPROJECTDISTRIBUTION.ANALYTICSMODELID
and MODELINGANDPROPENSITYDELIVERY.ANALYTICSPROJECTID = ANALYTICSPROJECTDISTRIBUTION.ANALYTICSPROJECTID
left join dbo.ANALYTICSMODEL on ANALYTICSMODEL.ID = ANALYTICSPROJECTDISTRIBUTION.ANALYTICSMODELID
left join dbo.CHANGEAGENT ADDEDBY on ADDEDBY.ID = ANALYTICSPROJECTDISTRIBUTION.ADDEDBYID
left join dbo.CHANGEAGENT CHANGEDBY on CHANGEDBY.ID = ANALYTICSPROJECTDISTRIBUTION.CHANGEDBYID