Contains parameter information for the Add Prospect Plans business process.
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=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
|
|
|
|
CREATEOPPORTUNITIES
|
bit
|
false
|
|
Controls whether or not to create opportunities along with the prospect plans.
|
|
EXPECTEDASKAMOUNT
|
money
|
false
|
|
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
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=Unqualified, 1=Qualified
|
|
OPPORTUNITYSTATUS
|
nvarchar(11) (Computed)
|
true
|
|
Provides a translation for the 'OPPORTUNITYSTATUSCODE' field.
|
|
PLANSTEPS
|
xml
|
true
|
|
Contains the steps to be associated with the plan.
|
Indexes
| Index Name |
Field(s) |
Unique |
Primary |
Clustered |
|
IX_ADDPROSPECTPLANSPROCESS_DATEADDED
|
|
False
|
False
|
True
|
|
IX_ADDPROSPECTPLANSPROCESS_DATECHANGED
|
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_IDSETREGISTERID
|
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_OPPORTUNITYTYPECODEID
|
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_PLANOUTLINEID
|
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_PRIMARYMANAGERFUNDRAISERID
|
PRIMARYMANAGERFUNDRAISERID
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_PROSPECTMANAGERFUNDRAISERID
|
PROSPECTMANAGERFUNDRAISERID
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_PROSPECTPLANTYPECODEID
|
|
False
|
False
|
False
|
|
IX_ADDPROSPECTPLANSPROCESS_SECONDARYMANAGERFUNDRAISERID
|
SECONDARYMANAGERFUNDRAISERID
|
False
|
False
|
False
|
|
PK_ADDPROSPECTPLANSPROCESS
|
|
True
|
True
|
False
|
|
UC_ADDPROSPECTPLANSPROCESS_NAME
|
|
True
|
False
|
False
|
