PROSPECTSEGMENTATIONPROSPECT

This table contains prospects of the Prospect Segmentation, defined by the primary and secondary section IDs.

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.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
PRIMARYSECTIONID	uniqueidentifier		PROSPECTSEGMENTATIONSECTION.ID	Foreign key to the primary Prospect Segmentation section.
SECONDARYSECTIONID	uniqueidentifier		PROSPECTSEGMENTATIONSECTION.ID	Foreign key to the secondary Prospect Segmentation section.
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID	Foreign key to the Constituent record.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_PROSPECTSEGMENTATIONPROSPECT_CONSTITUENTID	CONSTITUENTID
IX_PROSPECTSEGMENTATIONPROSPECT_DATEADDED	DATEADDED			yes
IX_PROSPECTSEGMENTATIONPROSPECT_DATECHANGED	DATECHANGED
IX_PROSPECTSEGMENTATIONPROSPECT_PRIMARYSECTIONID_SECONDARYSECTIONID	PRIMARYSECTIONID, SECONDARYSECTIONID
PK_PROSPECTSEGMENTATIONPROSPECT	ID	yes	yes

Triggers

Trigger Name	Description
TR_PROSPECTSEGMENTATIONPROSPECT_AUDIT_UPDATE
TR_PROSPECTSEGMENTATIONPROSPECT_AUDIT_DELETE