V_QUERY_PLEDGEREMINDER

Provides the ability to query pledge reminders.

Fields

Field	Field Type	Null	Description
ID	uniqueidentifier		System record ID
REVENUEID	uniqueidentifier		Revenue ID
CREATEDON	datetime		Created on
AMOUNTDUEDATE	datetime		Amount due date
AMOUNTDUE	money		Amount due
SENTDATE	datetime	yes	Sent date
NAME	nvarchar(100)	yes	Name
DESCRIPTION	nvarchar(255)	yes	Description
LETTERFILENAME	nvarchar(255)	yes	Letter file name
LABELFILENAME	nvarchar(255)	yes	Label file name
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
BASECURRENCYID	uniqueidentifier	yes	BASECURRENCYID

Definition

Copy

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



                select
                    PRS.ID,
                    PRS.REVENUEID as [REVENUEID],
                    PRS.CREATEDON,
                    PRS.AMOUNTDUEDATE,
                    PRS.AMOUNTDUE,
                    PRS.SENTDATE,
                    PRP.NAME,
                    PRP.DESCRIPTION,
                    PRP.LETTERFILENAME,
                    PRP.LABELFILENAME,
                    ADDEDBY.APPLICATIONNAME as [ADDEDBY_APPLICATION],
                    ADDEDBY.USERNAME as [ADDEDBY_USERNAME],
                    CHANGEDBY.APPLICATIONNAME as [CHANGEDBY_APPLICATION],
                    CHANGEDBY.USERNAME as [CHANGEDBY_USERNAME],
                    PRS.DATEADDED,
                    PRS.DATECHANGED,
                    PRS.TSLONG,
          PRS.BASECURRENCYID

                    /*#EXTENSION*/
                from
                    dbo.PLEDGEREMINDERSENT as [PRS] with (nolock)
                    left join dbo.PLEDGEREMINDERPROCESSSTATUS as [PRPS] with (nolock) on PRPS.ID = PRS.PLEDGEREMINDERPROCESSSTATUSID
                    left join dbo.BUSINESSPROCESSSTATUS as [BPS] with (nolock) on BPS.ID = PRS.PLEDGEREMINDERPROCESSSTATUSID
                    left join dbo.PLEDGEREMINDERPROCESS as [PRP] with (nolock) on PRP.ID = PRPS.PARAMETERSETID
                    left join dbo.CHANGEAGENT as [ADDEDBY] with (nolock) on ADDEDBY.ID = PRS.ADDEDBYID
                    left join dbo.CHANGEAGENT as [CHANGEDBY] with (nolock) on CHANGEDBY.ID = PRS.CHANGEDBYID