v_DIM_FUNDRAISERSECONDARY
Relates additional fundraisers to a prospect plan.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERSECONDARYDIMID | int | BBDW.[DIM_FUNDRAISERSECONDARY].[FUNDRAISERSECONDARYDIMID] | |
| FUNDRAISERSECONDARYSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FUNDRAISERSECONDARYSYSTEMID] |
| PROSPECTPLANDIMID | int | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[PROSPECTPLANDIMID] |
| FUNDRAISERDIMID | int | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FUNDRAISERDIMID] |
| FUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FUNDRAISERSYSTEMID] |
| FUNDRAISERROLE | nvarchar(100) | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FUNDRAISERROLE] |
| FROMDATEDIMID | int | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FROMDATEDIMID] |
| FROMDATE | datetime | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[FROMDATE] |
| TODATEDIMID | int | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[TODATEDIMID] |
| TODATE | datetime | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[TODATE] |
| STATUS | nvarchar(10) | yes | BBDW.[DIM_FUNDRAISERSECONDARY].[STATUS] |
Definition
Copy
create view [BBDW].[v_DIM_FUNDRAISERSECONDARY] as
select
[FUNDRAISERSECONDARYDIMID],
[FUNDRAISERSECONDARYSYSTEMID],
[PROSPECTPLANDIMID],
[FUNDRAISERDIMID],
[FUNDRAISERSYSTEMID],
[FUNDRAISERROLE],
[FROMDATEDIMID],
[FROMDATE],
[TODATEDIMID],
[TODATE],
[STATUS]
from [BBDW].[DIM_FUNDRAISERSECONDARY];