v_FACT_PLANNEDGIFTDESIGNATION
Contains information about planned gift designation
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTDESIGNATIONFACTID | int | BBDW.[FACT_PLANNEDGIFTDESIGNATION].[PLANNEDGIFTDESIGNATIONFACTID] | |
| PLANNEDGIFTDESIGNATIONSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTDESIGNATION].[PLANNEDGIFTDESIGNATIONSYSTEMID] |
| PLANNEDGIFTDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTDESIGNATION].[PLANNEDGIFTDIMID] |
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTDESIGNATION].[PLANNEDGIFTSYSTEMID] |
Definition
Copy
create view [BBDW].[v_FACT_PLANNEDGIFTDESIGNATION] as
select
[PLANNEDGIFTDESIGNATIONFACTID],
[PLANNEDGIFTDESIGNATIONSYSTEMID],
[PLANNEDGIFTDIMID],
[PLANNEDGIFTSYSTEMID]
from [BBDW].[FACT_PLANNEDGIFTDESIGNATION]