v_DIM_RECURRINGGIFTSTATUSREASON
Stores information about recurring gift STATUSREASONs.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTSTATUSREASONDIMID | int | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[RECURRINGGIFTSTATUSREASONDIMID] | |
| RECURRINGGIFTSTATUSREASONSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[RECURRINGGIFTSTATUSREASONSYSTEMID] |
| REASONTYPECODE | smallint | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[REASONTYPECODE] |
| REASONTYPE | nvarchar(25) | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[REASONTYPE] |
| RECURRINGGIFTSTATUSREASONCODE | nvarchar(10) | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[RECURRINGGIFTSTATUSREASONCODE] |
| RECURRINGGIFTSTATUSREASONDESCRIPTION | nvarchar(50) | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[RECURRINGGIFTSTATUSREASONDESCRIPTION] |
| RECURRINGGIFTSTATUSREASONISACTIVE | bit | yes | BBDW.[DIM_RECURRINGGIFTSTATUSREASON].[RECURRINGGIFTSTATUSREASONISACTIVE] |
Definition
Copy
create view [BBDW].[v_DIM_RECURRINGGIFTSTATUSREASON] as
select
[RECURRINGGIFTSTATUSREASONDIMID],
[RECURRINGGIFTSTATUSREASONSYSTEMID],
[REASONTYPECODE],
[REASONTYPE],
[RECURRINGGIFTSTATUSREASONCODE],
[RECURRINGGIFTSTATUSREASONDESCRIPTION],
[RECURRINGGIFTSTATUSREASONISACTIVE]
from [BBDW].[DIM_RECURRINGGIFTSTATUSREASON];