CAMPAIGNFUNDRAISER

This table stores information pertaining to fundraisers working on a campaign.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEADDED	datetime		Default = getdate()	Indicates the date this record was added.
DATECHANGED	datetime		Default = getdate()	Indicates the date this record was last changed.
TS	timestamp			Timestamp.
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)	Numeric representation of the timestamp.
DATEFROM	datetime	yes		The date that the fundraiser became associated with the campaign.
DATETO	datetime	yes		The date that the fundraiser ceased to be associated with the campaign.
STATUS	varchar(7) (Computed)		case dbo.UFN_DATE_COMPARETODATERANGE(getdate(), DATEFROM, DATETO) when -1 then 'Future' when 0 then 'Current' when 1 then 'Prior' else '' end	Current, prior, or future.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
CAMPAIGNID	uniqueidentifier		CAMPAIGN.LOCALID	The campaign a fundraiser is working on.
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID	The fundraiser that is working on a campaign.
CAMPAIGNFUNDRAISERPOSITIONCODEID	uniqueidentifier	yes	CAMPAIGNFUNDRAISERPOSITIONCODE.ID	The position a fundraiser occupies in the campaign.
CAMPAIGNFUNDRAISERTASKCODEID	uniqueidentifier	yes	CAMPAIGNFUNDRAISERTASKCODE.ID	The task a fundraiser performs on the campaign.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CAMPAIGNFUNDRAISER_CAMPAIGNID	CAMPAIGNID
IX_CAMPAIGNFUNDRAISER_CONSTITUENTID	CONSTITUENTID
IX_CAMPAIGNFUNDRAISER_DATEADDED	DATEADDED			yes
IX_CAMPAIGNFUNDRAISER_DATECHANGED	DATECHANGED
PK_CAMPAIGNFUNDRAISER	ID	yes	yes

Triggers

Trigger Name	Description
TR_CAMPAIGNFUNDRAISER_AUDIT_ETLDELETEDID
TR_CAMPAIGNFUNDRAISER_T2BDELETE
TR_CAMPAIGNFUNDRAISER_AUDIT_UPDATE
TR_CAMPAIGNFUNDRAISER_AUDIT_DELETE