PROSPECT

Indicates that a constituent is a prospect.

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.
RESEARCHSTATUSCONFIRMED	bit		Default = 0
PROSPECTMANAGERSTARTDATE	datetime	yes		The date the fundraiser became the prospect manager of the prospect.
PROSPECTMANAGERENDDATE	datetime	yes		The date the fundraiser ceased to be the prospect manager of the prospect.
RESEARCHSUMMARY	nvarchar(max)		Default = ''
LASTUPDATED	datetime	yes

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ID	uniqueidentifier		CONSTITUENT.LOCALID	Primary Key.
PROSPECTMANAGERFUNDRAISERID	uniqueidentifier	yes	CONSTITUENT.LOCALID	Foreign key to the CONSTITUENT table.
PROSPECTSTATUSCODEID	uniqueidentifier	yes	PROSPECTSTATUSCODE.LOCALID	FK to PROSPECTSTATUSCODE
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
LASTRESEARCHEDBYID	uniqueidentifier	yes	APPUSER.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_PROSPECT_DATEADDED	DATEADDED			yes
IX_PROSPECT_DATECHANGED	DATECHANGED
IX_PROSPECT_PROSPECTMANAGERFUNDRAISERID	PROSPECTMANAGERFUNDRAISERID
PK_PROSPECT	ID	yes	yes

Triggers

Trigger Name	Description
TR_PROSPECT_AUDIT_ETLDELETEDID
TR_PROSPECT_AUDIT_UPDATE
TR_PROSPECT_AUDIT_DELETE
TR_PROSPECT_T2BDELETE
TR_PROSPECT_T2BINSERTUPDATE

Referenced by

Referenced by	Field
PROSPECTFUNDINGINTEREST	PROSPECTID
PROSPECTMANAGERHISTORY	PROSPECTID