DIM_FUNDRAISERTEAM_STAGE

Intermediate storage table for DIM_FUNDRAISERTEAM

Fields

Field	Field Type	Null	Notes	Description
FUNDRAISERTEAMSYSTEMID	uniqueidentifier	yes		dbo.[TEAMFUNDRAISINGTEAM].[PARENTTEAMID]
FUNDRAISERTEAMNAME	nvarchar(100)	yes		dbo.[TEAMFUNDRAISINGTEAM].[NAME]
FUNDRAISERTEAMGROUPNAME	nvarchar(100)	yes		dbo.[TEAMFUNDRAISINGTEAMGROUP].[NAME]
FUNDRAISERTEAMGOAL	money	yes		dbo.[TEAMFUNDRAISINGTEAM].[ORGANIZATIONGOAL]
PARENTFUNDRAISERTEAMSYSTEMID	uniqueidentifier	yes		dbo.[TEAMFUNDRAISINGTEAM].[PARENTTEAMID]
APPEALDIMID	int	yes		Reference key to the appeal dimension, derived from dbo.[TEAMFUNDRAISINGTEAM].[APPEALID]
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
EVENTREGISTRANTGOALTYPEDIMID	int	yes		Reference key to the event registrant goal type dimension, derived from [dbo].[DIM_EVENTREGISTRANTGOALTYPE].[EVENTGOALTYPEDIMID]
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]
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.
EVENTSYSTEMID	uniqueidentifier	yes		[dbo].[TEAMEXTENSION].[EVENTID]
CONSTITUENTSYSTEMID	uniqueidentifier	yes		[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]
COMPANYCONSTITUENTSYSTEMID	uniqueidentifier	yes		[dbo].[FAFORGANIZATIONINDIVIDUALRELATION].[ORGANIZATIONCONSTITUENTID]