DIM_FUNDRAISERTEAMMEMBER

contains information about fundraising team members.

Primary Key

Primary Key	Field Type
FUNDRAISERTEAMMEMBERDIMID	int

Fields

Field	Field Type	Null	Notes	Description
FUNDRAISERTEAMMEMBERSYSTEMID	uniqueidentifier	yes		dbo.[TEAMFUNDRAISINGTEAMMEMBER].[ID]
FUNDRAISERTEAMDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[TEAMFUNDRAISER].[CONSTITUENTID]
FUNDRAISERDIMID	int	yes		Reference key to the fundraiser dimension, derived from dbo.[TEAMFUNDRAISER].[CONSTITUENTID]
FUNDRAISERSYSTEMID	uniqueidentifier	yes		dbo.[TEAMFUNDRAISER].[CONSTITUENTID]
APPEALDIMID	int	yes		Reference key to the appeal dimension, derived from dbo.[TEAMFUNDRAISER].[APPEALID]
FUNDRAISERGOAL	money	yes		dbo.[TEAMFUNDRAISINGTEAM].[GOAL]
ISINCLUDED	int	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
FUNDRAISERCONSTITUENTDIMID	int	yes		Reference key to the constituent dimension, derived using [dbo].[INTERACTION].[FUNDRAISERID]

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DIM_FUNDRAISERTEAMMEMBER_APPEALDIMID	APPEALDIMID
IX_DIM_FUNDRAISERTEAMMEMBER_FUNDRAISERCONSTITUENTDIMID	FUNDRAISERCONSTITUENTDIMID
IX_DIM_FUNDRAISERTEAMMEMBER_FUNDRAISERDIMID	FUNDRAISERDIMID
IX_DIM_FUNDRAISERTEAMMEMBER_FUNDRAISERTEAMDIMID	FUNDRAISERTEAMDIMID
PK_DIM_FUNDRAISERTEAMMEMBER	FUNDRAISERTEAMMEMBERDIMID	yes	yes	yes