V_QUERY_CORRESPONDENCEPROCESSRUNHISTORY

Provides the ability to query correspondence process run history.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(100)		Name
STARTEDON	datetime		Started on
CORRESPONDENCEPROCESSSTATUSID	uniqueidentifier	yes	Correspondence process status ID
ADDEDBY_APPLICATION	nvarchar(200)	yes	Added by application
ADDEDBY_USERNAME	nvarchar(128)	yes	Added by user name
CHANGEDBY_APPLICATION	nvarchar(200)	yes	Changed by application
CHANGEDBY_USERNAME	nvarchar(128)	yes	Changed by user name
DATEADDED	datetime		Date added
DATECHANGED	datetime		Date changed

Definition

Copy

/*
Generated by Blackbaud AppFx Platform
Date:  8/17/2011 2:35:43 PM
Assembly Version:  Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_CORRESPONDENCEPROCESSRUNHISTORY AS



                select
                    CORRESPONDENCEPROCESSRUNHISTORY.ID,
                    CORRESPONDENCEPROCESSRUNHISTORY.NAME,
                    CORRESPONDENCEPROCESSRUNHISTORY.STARTEDON,
                    CORRESPONDENCEPROCESSRUNHISTORY.CORRESPONDENCEPROCESSSTATUSID,
                    ADDEDBY.APPLICATIONNAME as ADDEDBY_APPLICATION,
                    ADDEDBY.USERNAME as ADDEDBY_USERNAME,
                    CHANGEDBY.APPLICATIONNAME as CHANGEDBY_APPLICATION,
                    CHANGEDBY.USERNAME as CHANGEDBY_USERNAME,
                    CORRESPONDENCEPROCESSRUNHISTORY.DATEADDED,
                    CORRESPONDENCEPROCESSRUNHISTORY.DATECHANGED
                from
                    dbo.CORRESPONDENCEPROCESSRUNHISTORY
                left outer join 
                    dbo.CHANGEAGENT as ADDEDBY on ADDEDBY.ID = CORRESPONDENCEPROCESSRUNHISTORY.ADDEDBYID
                left outer join 
                    dbo.CHANGEAGENT as CHANGEDBY on CHANGEDBY.ID = CORRESPONDENCEPROCESSRUNHISTORY.CHANGEDBYID;