v_DIM_FUNDRAISERTEAMMEMBER
contains information about fundraising team members.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERTEAMMEMBERDIMID | int | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERTEAMMEMBERDIMID] | |
| FUNDRAISERTEAMMEMBERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERTEAMMEMBERSYSTEMID] |
| FUNDRAISERTEAMDIMID | int | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERTEAMDIMID] |
| FUNDRAISERDIMID | int | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERDIMID] |
| FUNDRAISERSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERSYSTEMID] |
| APPEALDIMID | int | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[APPEALDIMID] |
| FUNDRAISERGOAL | money | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERGOAL] |
| FUNDRAISERCONSTITUENTDIMID | int | yes | BBDW.[DIM_FUNDRAISERTEAMMEMBER].[FUNDRAISERCONSTITUENTDIMID] |
Definition
Copy
create view [BBDW].[v_DIM_FUNDRAISERTEAMMEMBER] as
select
[FUNDRAISERTEAMMEMBERDIMID],
[FUNDRAISERTEAMMEMBERSYSTEMID],
[FUNDRAISERTEAMDIMID],
[FUNDRAISERDIMID],
[FUNDRAISERSYSTEMID],
[APPEALDIMID],
[FUNDRAISERGOAL],
[FUNDRAISERCONSTITUENTDIMID]
from [BBDW].[DIM_FUNDRAISERTEAMMEMBER];