v_DIM_FUNDRAISERTEAM
The fundraiser team dimension contains information about teams.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| FUNDRAISERTEAMDIMID | int | BBDW.[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMDIMID] | |
| FUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMSYSTEMID] |
| FUNDRAISERTEAMNAME | nvarchar(100) | yes | BBDW.[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMNAME] |
| FUNDRAISERTEAMGROUPNAME | nvarchar(100) | yes | BBDW.[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMGROUPNAME] |
| FUNDRAISERTEAMGOAL | money | yes | BBDW.[DIM_FUNDRAISERTEAM].[FUNDRAISERTEAMGOAL] |
| PARENTFUNDRAISERTEAMDIMID | int | yes | BBDW.[DIM_FUNDRAISERTEAM].[PARENTFUNDRAISERTEAMDIMID] |
| PARENTFUNDRAISERTEAMSYSTEMID | uniqueidentifier | yes | BBDW.[DIM_FUNDRAISERTEAM].[PARENTFUNDRAISERTEAMSYSTEMID] |
| APPEALDIMID | int | yes | BBDW.[DIM_APPEAL].[APPEALDIMID] |
| COMMUNICATIONSTOSEND | int | yes | BBDW.[DIM_FUNDRAISERTEAM].[COMMUNICATIONSTOSEND] |
| GROUPMEMBERGOAL | int | yes | BBDW.[DIM_FUNDRAISERTEAM].[GROUPMEMBERGOAL] |
| PARTICIPANTGOAL | int | yes | BBDW.[DIM_FUNDRAISERTEAM].[PARTICIPANTGOAL] |
| GROUPMEMBERSRETAINGOALPCT | decimal(18, 0) | yes | BBDW.[DIM_FUNDRAISERTEAM].[GROUPMEMBERSRETAINGOALPCT] |
| EVENTGOALTYPEDIMID | int | yes | [BBDW].[DIM_FUNDRAISERTEAM].[EVENTGOALTYPEDIMID] |
| GROUPLEADERS | nvarchar(500) | yes | BBDW.[DIM_CONSTITUENT].[NAME] |
| NATIONALGROUPNAME | nvarchar(200) | yes | BBDW.[DIM_FUNDRAISERTEAM].[NATIONALGROUPNAME] |
| NATIONALLEVEL | nvarchar(200) | yes | BBDW.[DIM_FUNDRAISERTEAM].[NATIONALLEVEL] |
| EVENTCAMPAIGN | nvarchar(200) | yes | BBDW.[DIM_FUNDRAISERTEAM].[EVENTCAMPAIGN] |
| PARENTFUNDRAISERGROUP | nvarchar(200) | yes | BBDW.[DIM_FUNDRAISERTEAM].[PARENTFUNDRAISERGROUP] |
| EVENTSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_FUNDRAISERTEAM].[EVENTSYSTEMID] |
| EVENTDIMID | int | yes | [BBDW].[DIM_FUNDRAISERTEAM].[EVENTDIMID] |
| CONSTITUENTSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_FUNDRAISERTEAM].[CONSTITUENTSYSTEMID] |
| CONSTITUENTDIMID | int | yes | [BBDW].[DIM_FUNDRAISERTEAM].[CONSTITUENTDIMID] |
| COMPANYCONSTITUENTSYSTEMID | uniqueidentifier | yes | [BBDW].[DIM_FUNDRAISERTEAM].[COMPANYCONSTITUENTSYSTEMID] |
| COMPANYCONSTITUENTDIMID | int | yes | [BBDW].[DIM_FUNDRAISERTEAM].[COMPANYCONSTITUENTDIMID] |
| TEAMSGOAL | int | yes | [BBDW].[DIM_FUNDRAISERTEAM].[TEAMSGOAL] |
| TEAMSTORETAINGOALPCT | decimal(9, 2) | yes | [BBDW].[DIM_FUNDRAISERTEAM].[TEAMSTORETAINGOALPCT] |
| STATUS | nvarchar(8) | yes | [BBDW].[DIM_FUNDRAISERTEAM].[STATUS] |
| HASIMAGEORVIDEO | bit | yes | [BBDW].[DIM_FUNDRAISERTEAM].[HASIMAGEORVIDEO] |
| HASSTORY | bit | yes | [BBDW].[DIM_FUNDRAISERTEAM].[HASSTORY] |
| TEAMPAGEURL | nvarchar(2100) | yes | [BBDW].[DIM_FUNDRAISERTEAM].[TEAMPAGEURL] |
| ISPREVIOUSEVENTTEAM | bit | yes | [BBDW].[DIM_FUNDRAISERTEAM].[ISPREVIOUSEVENTTEAM] |
Definition
Copy
CREATE view [BBDW].[v_DIM_FUNDRAISERTEAM] as
select
[FUNDRAISERTEAMDIMID]
,[FUNDRAISERTEAMSYSTEMID]
,[FUNDRAISERTEAMNAME]
,[FUNDRAISERTEAMGROUPNAME]
,[FUNDRAISERTEAMGOAL]
,[PARENTFUNDRAISERTEAMDIMID]
,[PARENTFUNDRAISERTEAMSYSTEMID]
,[APPEALDIMID]
,[COMMUNICATIONSTOSEND]
,[GROUPMEMBERGOAL]
,[PARTICIPANTGOAL]
,[GROUPMEMBERSRETAINGOALPCT]
,[EVENTGOALTYPEDIMID]
,[GROUPLEADERS]
,[NATIONALGROUPNAME]
,[NATIONALLEVEL]
,[EVENTCAMPAIGN]
,[PARENTFUNDRAISERGROUP]
,[EVENTSYSTEMID]
,[EVENTDIMID]
,[CONSTITUENTSYSTEMID]
,[CONSTITUENTDIMID]
,[COMPANYCONSTITUENTSYSTEMID]
,[COMPANYCONSTITUENTDIMID]
,[TEAMSGOAL]
,[TEAMSTORETAINGOALPCT]
,[STATUS]
,[HASIMAGEORVIDEO]
,[HASSTORY]
,[TEAMPAGEURL]
,[ISPREVIOUSEVENTTEAM]
from
BBDW.[DIM_FUNDRAISERTEAM]