v_FACT_PLANNEDGIFTATTRIBUTE
Contains information from planned gift attributes.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| PLANNEDGIFTATTRIBUTEFACTID | int | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[PLANNEDGIFTATTRIBUTEFACTID] | |
| PLANNEDGIFTATTRIBUTESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[PLANNEDGIFTATTRIBUTESYSTEMID] |
| ATTRIBUTEDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEDIMID] |
| ATTRIBUTESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTESYSTEMID] |
| ATTRIBUTEVALUESYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEVALUESYSTEMID] |
| PLANNEDGIFTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[PLANNEDGIFTSYSTEMID] |
| PLANNEDGIFTDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[PLANNEDGIFTDIMID] |
| ATTRIBUTESTARTDATEDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTESTARTDATEDIMID] |
| ATTRIBUTESTARTDATE | datetime | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTESTARTDATE] |
| ATTRIBUTEENDDATEDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEENDDATEDIMID] |
| ATTRIBUTEENDDATE | datetime | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEENDDATE] |
| ATTRIBUTEVALUE | nvarchar(255) | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEVALUE] |
| ATTRIBUTEISCURRENT | bit | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTEISCURRENT] |
| ATTRIBUTECOMMENT | nvarchar(255) | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[ATTRIBUTECOMMENT] |
| VALUEDATE | date | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUEDATE] |
| VALUEDATEDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUEDATEDIMID] |
| VALUEYESNO | bit | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUEYESNO] |
| VALUECURRENCY | money | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUECURRENCY] |
| VALUECONSTITUENTSYSTEMID | uniqueidentifier | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUECONSTITUENTSYSTEMID] |
| VALUECONSTITUENTDIMID | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUECONSTITUENTDIMID] |
| VALUEHOURMINUTE | UDT_HOURMINUTE | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUEHOURMINUTE] |
| VALUEFUZZYDATE | UDT_FUZZYDATE | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUEFUZZYDATE] |
| VALUENUMBER | int | yes | BBDW.[FACT_PLANNEDGIFTATTRIBUTE].[VALUENUMBER] |
Definition
Copy
create view [BBDW].[v_FACT_PLANNEDGIFTATTRIBUTE] as
select
[PLANNEDGIFTATTRIBUTEFACTID],
[PLANNEDGIFTATTRIBUTESYSTEMID],
[ATTRIBUTEDIMID],
[ATTRIBUTESYSTEMID],
[ATTRIBUTEVALUESYSTEMID],
[PLANNEDGIFTSYSTEMID],
[PLANNEDGIFTDIMID],
[ATTRIBUTESTARTDATEDIMID],
[ATTRIBUTESTARTDATE],
[ATTRIBUTEENDDATEDIMID],
[ATTRIBUTEENDDATE],
[ATTRIBUTEVALUE],
[ATTRIBUTEISCURRENT],
[ATTRIBUTECOMMENT],
[VALUEDATE],
[VALUEDATEDIMID],
[VALUEYESNO],
[VALUECURRENCY],
[VALUECONSTITUENTSYSTEMID],
[VALUECONSTITUENTDIMID],
[VALUEHOURMINUTE],
[VALUEFUZZYDATE],
[VALUENUMBER]
from [BBDW].[FACT_PLANNEDGIFTATTRIBUTE];