| FUNDRAISERTEAMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[ID] |
| FUNDRAISERTEAMNAME |
nvarchar(100) |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[NAME] |
| FUNDRAISERTEAMGROUPNAME |
nvarchar(100) |
yes |
|
dbo.[TEAMFUNDRAISINGTEAMGROUP].[NAME] |
| FUNDRAISERTEAMGOAL |
money |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[GOAL] |
| PARENTFUNDRAISERTEAMDIMID |
int |
yes |
|
Reference key to the fundraising team dimension, derived from dbo.[TEAMFUNDRAISINGTEAM].[PARENTTEAMID] |
| PARENTFUNDRAISERTEAMSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[PARENTTEAMID] |
| APPEALDIMID |
int |
yes |
|
Reference key to the appeal dimension, derived from dbo.[TEAMFUNDRAISINGTEAM].[APPEALID] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process |
| SOURCEDIMID |
int |
yes |
|
Source system used |
| COMMUNICATIONSTOSEND |
int |
yes |
|
dbo.[TEAMEXTENSION].[COMMUNICATIONGOAL] |
| GROUPMEMBERGOAL |
int |
yes |
|
dbo.[TEAMEXTENSION].[TEAMMEMBERGOAL] |
| PARTICIPANTGOAL |
int |
yes |
|
dbo.[TEAMEXTENSION].[PARTICIPANTGOAL] |
| GROUPMEMBERSRETAINGOALPCT |
decimal(18, 0) |
yes |
|
dbo.[TEAMEXTENSION].[PCTTEAMMEMBERRETENSION] * 100 |
| EVENTGOALTYPEDIMID |
int |
yes |
|
Reference key to the event registrant goal type dimension, derived from [dbo].[DIM_EVENTREGISTRANTGOALTYPE].[EVENTGOALTYPEDIMID] |
| GROUPLEADERS |
nvarchar(500) |
yes |
|
Collection of group leader names from dbo.[CONSTITUENT].[NAME] derived from dbo.[TEAMFUNDRAISINGTEAMCAPTAIN].[CONSTITUENTID] |
| NATIONALGROUPNAME |
nvarchar(200) |
yes |
|
dbo.[FAFNFGCAMPAIGN].[NAME] |
| NATIONALLEVEL |
nvarchar(200) |
yes |
|
dbo.[FAFNFGCAMPAIGNLEVEL].[NAME] |
| EVENTCAMPAIGN |
nvarchar(200) |
yes |
|
dbo.[FAFPROGRAM].[NAME] |
| PARENTFUNDRAISERGROUP |
nvarchar(200) |
yes |
|
dbo.[TEAMFUNDRAISINGTEAM].[NAME] |
| EVENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[TEAMEXTENSION].[EVENTID] |
| EVENTDIMID |
int |
yes |
|
Reference key to the event dimension, derived from [dbo].[TEAMEXTENSION].[EVENTID] |
| CONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[TEAMEXTENSION].[TEAMCONSTITUENTID] |
| CONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[TEAMEXTENSION].[TEAMCONSTITUENTID] |
| TEAMSGOAL |
int |
yes |
|
[dbo].[TEAMEXTENSION].[TEAMRECRUITMENTGOAL] |
| TEAMSTORETAINGOALPCT |
decimal(9, 2) |
yes |
|
dbo.[TEAMEXTENSION].[PCTTEAMSRETENSION] * 100 |
| STATUS |
nvarchar(8) |
yes |
|
[dbo].[TEAMEXTENSION].[STATUS] |
| HASIMAGEORVIDEO |
bit |
yes |
|
If exists TEAMCONSTITUENTID in [dbo].[SITEIMAGESEXTENSION] |
| HASSTORY |
bit |
yes |
|
If exists TEAMCFUNDRAISINGTEAMID in [dbo].[STORY] |
| TEAMPAGEURL |
nvarchar(2100) |
yes |
|
[dbo].[CMSSITESETTING].[VALUE] where [ENUMID] = 11 + [dbo].[VANITYURL].[VANITYURL] |
| ISPREVIOUSEVENTTEAM |
bit |
yes |
|
If exists [BBDW].[DIM_FUNDRAISERTEAM][CONSTITUENTDIMID] for previous year's EVENTID |
| COMPANYCONSTITUENTSYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[FAFORGANIZATIONINDIVIDUALRELATION].[ORGANIZATIONCONSTITUENTID] |
| COMPANYCONSTITUENTDIMID |
int |
yes |
|
Reference key to the constituent dimension, derived from [dbo].[FAFORGANIZATIONINDIVIDUALRELATION].[ORGANIZATIONCONSTITUENTID] |