V_QUERY_RECURRINGGIFTAMENDMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| ID | uniqueidentifier | ||
| FINANCIALTRANSACTIONID | uniqueidentifier | ||
| PREVIOUSSTATUS | nvarchar(14) | yes | |
| STATUS | nvarchar(14) | yes | |
| RECURRINGGIFTSTATUSREASONCODE | nvarchar(10) | yes | |
| RECURRINGGIFTSTATUSREASONDESCRIPTION | nvarchar(50) | yes | |
| ADDEDBY_APPLICATION | nvarchar(200) | yes | |
| ADDEDBY_USERNAME | nvarchar(128) | yes | |
| CHANGEDBY_APPLICATION | nvarchar(200) | yes | |
| CHANGEDBY_USERNAME | nvarchar(128) | yes |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/28/2016 5:44:50 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=4.0.158.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_RECURRINGGIFTAMENDMENT AS
select
RECURRINGGIFTAMENDMENT.ID,
RECURRINGGIFTAMENDMENT.FINANCIALTRANSACTIONID,
RECURRINGGIFTAMENDMENT.PREVIOUSSTATUS,
RECURRINGGIFTAMENDMENT.STATUS,
RECURRINGGIFTSTATUSREASONCODE.CODE as RECURRINGGIFTSTATUSREASONCODE,
RECURRINGGIFTSTATUSREASONCODE.DESCRIPTION as RECURRINGGIFTSTATUSREASONDESCRIPTION,
[ADDEDBY].APPLICATIONNAME as [ADDEDBY_APPLICATION],
[ADDEDBY].USERNAME as [ADDEDBY_USERNAME],
[CHANGEDBY].APPLICATIONNAME as [CHANGEDBY_APPLICATION],
[CHANGEDBY].USERNAME as [CHANGEDBY_USERNAME]
from dbo.RECURRINGGIFTAMENDMENT
left join dbo.RECURRINGGIFTSTATUSREASONCODE on RECURRINGGIFTAMENDMENT.RECURRINGGIFTSTATUSREASONCODEID = RECURRINGGIFTSTATUSREASONCODE.ID
left join dbo.CHANGEAGENT as [ADDEDBY] on [ADDEDBY].ID = RECURRINGGIFTAMENDMENT.ADDEDBYID
left join dbo.CHANGEAGENT as [CHANGEDBY] on [CHANGEDBY].ID = RECURRINGGIFTAMENDMENT.CHANGEDBYID