V_QUERY_TRIBUTEACKNOWLEDGEMENT

Provides the ability to query tribute acknowledgements.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
NAME	nvarchar(100)		Name
DESCRIPTION	nvarchar(255)		Description
ACKNOWLEDGEDATE	datetime	yes	Acknowledge date
LABELFILENAME	nvarchar(255)		Label file name
REVENUETRIBUTELETTERID	uniqueidentifier	yes	Revenue tribute letter ID
REVENUETRIBUTEID	uniqueidentifier	yes	Revenue Tribute 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
TSLONG	bigint	yes	Timestamp value

Definition

Copy

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



                select
                    TAP.ID,
                    TAP.NAME,
                    TAP.DESCRIPTION,
                    TAP.ACKNOWLEDGEDATE,
                    TAP.LABELFILENAME,
                    RTL.ID as REVENUETRIBUTELETTERID,
                    RT.ID as REVENUETRIBUTEID,
                    ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
                    CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
                    TAP.DATEADDED,
                    TAP.DATECHANGED,
                    TAP.TSLONG

                    /*#EXTENSION*/
                from
                    dbo.TRIBUTEACKNOWLEDGEMENTPROCESS as [TAP]
                    left join dbo.TRIBUTEACKNOWLEDGEMENTPROCESSSTATUS as [TAPS] on TAPS.PARAMETERSETID = TAP.ID
                    left join dbo.REVENUETRIBUTELETTER as [RTL] on RTL.TRIBUTEACKNOWLEDGEMENTPROCESSSTATUSID = TAPS.ID
                    left join dbo.REVENUETRIBUTE as [RT] on RT.ID = RTL.REVENUETRIBUTEID
                    left join dbo.CHANGEAGENT as [ADDEDBY] on ADDEDBY.ID = TAP.ADDEDBYID
                    left join dbo.CHANGEAGENT as [CHANGEDBY] on CHANGEDBY.ID = TAP.CHANGEDBYID