v_DIM_FUNDRAISER
The fundraiser dimension contains information about fundraisers.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERDIMID | int | BBDW.[DIM_FUNDRAISER].[FUNDRAISERDIMID] | |
| FUNDRAISERLOOKUPID | nvarchar(100) | yes | BBDW.[DIM_FUNDRAISER].[CONSTITUENTLOOKUPID] |
| FUNDRAISERNAME | nvarchar(154) | yes | BBDW.[DIM_FUNDRAISER].[FULLNAME] |
| STAFFFUNDRAISERNAME | nvarchar(154) | yes | BBDW.[DIM_FUNDRAISER].[STAFFFUNDRAISERNAME] |
| PREFERREDFUNDRAISERNAME | nvarchar(154) | yes | BBDW.[DIM_FUNDRAISER].[PREFERREDFUNDRAISERNAME] |
| ISACTIVE | bit | yes | BBDW.[DIM_FUNDRAISER].[ISACTIVE] |
| ISACTIVESTAFF | bit | yes | BBDW.[DIM_FUNDRAISER].[ISACTIVESTAFF] |
| ISACTIVEFUNDRAISER | bit | yes | BBDW.[DIM_FUNDRAISER].[ISACTIVEFUNDRAISER] |
| ISPREFERREDFUNDRAISER | bit | yes | BBDW.[DIM_FUNDRAISER].[ISPREFERREDFUNDRAISER] |
Definition
Copy
create view [BBDW].[v_DIM_FUNDRAISER] as
select
[FUNDRAISERDIMID],
[CONSTITUENTLOOKUPID] as [FUNDRAISERLOOKUPID],
[FULLNAME] as [FUNDRAISERNAME],
[STAFFFUNDRAISERNAME],
[PREFERREDFUNDRAISERNAME],
[ISACTIVE],
[ISACTIVESTAFF],
[ISACTIVEFUNDRAISER],
[ISPREFERREDFUNDRAISER]
from BBDW.[DIM_FUNDRAISER]