v_FACT_PLANNEDGIFTADDITION
Stores information about planned gift additions.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTADDITIONFACTID | int | BBDW.[FACT_PLANNEDGIFTADDITION].[PLANNEDGIFTADDITIONFACTID] | |
| PLANNEDGIFTADDITIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[PLANNEDGIFTADDITIONSYSTEMID] |
| PLANNEDGIFTDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[PLANNEDGIFTDIMID] |
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[PLANNEDGIFTSYSTEMID] |
| FINANCIALTRANSACTIONFACTID | int | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[FINANCIALTRANSACTIONFACTID] |
| FINANCIALTRANSACTIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[FINANCIALTRANSACTIONSYSTEMID] |
| GIFTAMOUNT | money | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[GIFTAMOUNT] |
| RECOGNITIONAMOUNT | money | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[RECOGNITIONAMOUNT] |
| GIFTDATE | datetime | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[GIFTDATE] |
| GIFTDATEDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTADDITION].[GIFTDATEDIMID] |
Definition
Copy
create view [BBDW].[v_FACT_PLANNEDGIFTADDITION] as
select
[PLANNEDGIFTADDITIONFACTID],
[PLANNEDGIFTADDITIONSYSTEMID],
[PLANNEDGIFTDIMID],
[PLANNEDGIFTSYSTEMID],
[FINANCIALTRANSACTIONFACTID],
[FINANCIALTRANSACTIONSYSTEMID],
[GIFTAMOUNT],
[RECOGNITIONAMOUNT],
[GIFTDATE],
[GIFTDATEDIMID]
from [BBDW].[FACT_PLANNEDGIFTADDITION];