V_QUERY_BBDW_RECURRINGGIFTAMENDMENT
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTAMENDMENTFACTID | int | ||
| RECURRINGGIFTAMENDMENTSYSTEMID | uniqueidentifier | yes | |
| FINANCIALTRANSACTIONFACTID | int | yes | |
| PREVIOUSRECURRINGGIFTSTATUS | nvarchar(50) | yes | |
| RECURRINGGIFTSTATUS | nvarchar(50) | yes | |
| RECURRINGGIFTSTATUSREASONCODE | nvarchar(10) | yes | |
| RECURRINGGIFTSTATUSREASONDESCRIPTION | nvarchar(50) | yes |
Definition
Copy
create view BBDW.[V_QUERY_BBDW_RECURRINGGIFTAMENDMENT] as
select
rga.[RECURRINGGIFTAMENDMENTFACTID],
rga.[RECURRINGGIFTAMENDMENTSYSTEMID],
rga.[FINANCIALTRANSACTIONFACTID],
rga.[PREVIOUSRECURRINGGIFTSTATUS],
rga.[RECURRINGGIFTSTATUS],
sr.[RECURRINGGIFTSTATUSREASONCODE],
sr.[RECURRINGGIFTSTATUSREASONDESCRIPTION]
from BBDW.[FACT_RECURRINGGIFTAMENDMENT] rga
left join [BBDW].[DIM_RECURRINGGIFTSTATUSREASON] sr on sr.[RECURRINGGIFTSTATUSREASONDIMID] = rga.[RECURRINGGIFTSTATUSREASONDIMID]