v_DIM_RECURRINGGIFTFLAG
The recurring gift flag dimension contains boolean information about recurring gifts.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| RECURRINGGIFTFLAGDIMID | int | BBDW.[DIM_RECURRINGGIFTFLAG].[RECURRINGGIFTFLAGDIMID] | |
| ISFIRSTINSTALLMENT | bit | yes | BBDW.[DIM_RECURRINGGIFTFLAG].[ISFIRSTINSTALLMENT] |
| ISLASTINSTALLMENT | bit | yes | BBDW.[DIM_RECURRINGGIFTFLAG].[ISLASTINSTALLMENT] |
| ISMISSEDINSTALLMENT | bit | yes | BBDW.[DIM_RECURRINGGIFTFLAG].[ISMISSEDINSTALLMENT] |
| ISFUTUREINSTALLMENT | bit | yes | BBDW.[DIM_RECURRINGGIFTFLAG].[ISFUTUREINSTALLMENT] |
Definition
Copy
create view [BBDW].[v_DIM_RECURRINGGIFTFLAG] as
select
[RECURRINGGIFTFLAGDIMID],
[ISFIRSTINSTALLMENT],
[ISLASTINSTALLMENT],
[ISMISSEDINSTALLMENT],
[ISFUTUREINSTALLMENT]
from BBDW.[DIM_RECURRINGGIFTFLAG]