ADDPROSPECTPLANSPROCESS (4.0)

Contains parameter information for the Add Prospect Plans business process.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

IDSETREGISTERID

uniqueidentifier

false

Indicates the set of constituents to which to add prospect plans.

PROSPECTPLANTYPECODEID

uniqueidentifier

false

FK to PROSPECTPLANTYPECODE

PLANOUTLINEID

uniqueidentifier

true

The plan outline to use to create steps for the plans.

PRIMARYMANAGERFUNDRAISERID

uniqueidentifier

true

FK to CONSTITUENT

SECONDARYMANAGERFUNDRAISERID

uniqueidentifier

true

FK to CONSTITUENT

PROSPECTMANAGERFUNDRAISERID

uniqueidentifier

true

FK to CONSTITUENT

OPPORTUNITYTYPECODEID

uniqueidentifier

true

FK to OPPORTUNITYTYPECODE

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

PROSPECTPLANCURRENCYSETID

uniqueidentifier

true

The currency set associated with the base currency for the newly created plan.

OPPORTUNITYTRANSACTIONCURRENCYID

uniqueidentifier

true

The transaction currency associated with this new opportunity.
Fields
Field Field Type Null Notes Description

NAME

nvarchar(100)

false

''

The name of the parameter set.

DESCRIPTION

nvarchar(255)

false

''

The description of the parameter set.

PROSPECTPLANNAME

nvarchar(100)

false

''

NARRATIVE

nvarchar(1000)

false

''

STARTDATETYPECODE

tinyint

false

0

0=Date this process runs, 1=Specific date, 2=X days after this process runs, 3=X days before this process runs

STARTDATETYPE

nvarchar(31) (Computed)

true

Provides a translation for the 'STARTDATETYPECODE' field.

STARTDATE

date

true

DAYSBEFOREORAFTER

int

false

0

CREATEOPPORTUNITIES

bit

false

0

Controls whether or not to create opportunities along with the prospect plans.

EXPECTEDASKAMOUNT

money

false

0

DATEADDED

datetime

false

getdate()

Indicates the date this record was added.

DATECHANGED

datetime

false

getdate()

Indicates the date this record was last changed.

TS

timestamp

false

Timestamp.

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp.

OPPORTUNITYSTATUSCODE

tinyint

false

0

0=Unqualified, 1=Qualified

OPPORTUNITYSTATUS

nvarchar(11) (Computed)

true

Provides a translation for the 'OPPORTUNITYSTATUSCODE' field.

PLANSTEPS

xml

true

Indexes
Index Name Field(s) Unique Primary Clustered

IX_ADDPROSPECTPLANSPROCESS_DATEADDED

DATEADDED

False

False

True

IX_ADDPROSPECTPLANSPROCESS_DATECHANGED

DATECHANGED

False

False

False

IX_ADDPROSPECTPLANSPROCESS_IDSETREGISTERID

IDSETREGISTERID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_OPPORTUNITYTYPECODEID

OPPORTUNITYTYPECODEID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_PLANOUTLINEID

PLANOUTLINEID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_PRIMARYMANAGERFUNDRAISERID

PRIMARYMANAGERFUNDRAISERID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_PROSPECTMANAGERFUNDRAISERID

PROSPECTMANAGERFUNDRAISERID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_PROSPECTPLANTYPECODEID

PROSPECTPLANTYPECODEID

False

False

False

IX_ADDPROSPECTPLANSPROCESS_SECONDARYMANAGERFUNDRAISERID

SECONDARYMANAGERFUNDRAISERID

False

False

False

PK_ADDPROSPECTPLANSPROCESS

ID

True

True

False

UC_ADDPROSPECTPLANSPROCESS_NAME

NAME

True

False

False
Triggers
Trigger Name Description

TR_ADDPROSPECTPLANSPROCESS_AUDIT_UPDATE

TR_ADDPROSPECTPLANSPROCESS_AUDIT_DELETE

Referenced by
Referenced by Field

ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION

ADDPROSPECTPLANSPROCESSID

ADDPROSPECTPLANSPROCESSSECONDARYFUNDRAISER

ADDPROSPECTPLANSPROCESSID

ADDPROSPECTPLANSPROCESSSITE

ADDPROSPECTPLANSPROCESSID

ADDPROSPECTPLANSPROCESSSTATUS

PARAMETERSETID