Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 PROSPECTPLANNAME nvarchar(100)   Default = ''
 NARRATIVE nvarchar(1000)   Default = ''
 STARTDATETYPECODE tinyint   Default = 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) CASE [STARTDATETYPECODE] WHEN 0 THEN N'Date this process runs' WHEN 1 THEN N'Specific date' WHEN 2 THEN N'X days after this process runs' WHEN 3 THEN N'X days before this process runs' END Provides a translation for the 'STARTDATETYPECODE' field.
 STARTDATE date
 DAYSBEFOREORAFTER int   Default = 0
 CREATEOPPORTUNITIES bit   Default = 0 Controls whether or not to create opportunities along with the prospect plans.
 EXPECTEDASKAMOUNT money   Default = 0
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 OPPORTUNITYSTATUSCODE tinyint   Default = 0 0=Unqualified, 1=Qualified
 OPPORTUNITYSTATUS nvarchar(11) (Computed) CASE [OPPORTUNITYSTATUSCODE] WHEN 0 THEN N'Unqualified' WHEN 1 THEN N'Qualified' END Provides a translation for the 'OPPORTUNITYSTATUSCODE' field.
 PLANSTEPS xml

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier   IDSETREGISTER.ID Indicates the set of constituents to which to add prospect plans.
 PROSPECTPLANTYPECODEID uniqueidentifier   PROSPECTPLANTYPECODE.ID FK to PROSPECTPLANTYPECODE
 PLANOUTLINEID uniqueidentifier PLANOUTLINE.ID The plan outline to use to create steps for the plans.
 PRIMARYMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SECONDARYMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 PROSPECTMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 OPPORTUNITYTYPECODEID uniqueidentifier OPPORTUNITYTYPECODE.ID FK to OPPORTUNITYTYPECODE
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 PROSPECTPLANCURRENCYSETID uniqueidentifier CURRENCYSET.ID The currency set associated with the base currency for the newly created plan.
 OPPORTUNITYTRANSACTIONCURRENCYID uniqueidentifier CURRENCY.ID The transaction currency associated with this new opportunity.

Index Name Field(s) Unique Primary Clustered
 IX_ADDPROSPECTPLANSPROCESS_DATEADDED DATEADDED    
 IX_ADDPROSPECTPLANSPROCESS_DATECHANGED DATECHANGED      
 IX_ADDPROSPECTPLANSPROCESS_IDSETREGISTERID IDSETREGISTERID      
 IX_ADDPROSPECTPLANSPROCESS_OPPORTUNITYTYPECODEID OPPORTUNITYTYPECODEID      
 IX_ADDPROSPECTPLANSPROCESS_PLANOUTLINEID PLANOUTLINEID      
 IX_ADDPROSPECTPLANSPROCESS_PRIMARYMANAGERFUNDRAISERID PRIMARYMANAGERFUNDRAISERID      
 IX_ADDPROSPECTPLANSPROCESS_PROSPECTMANAGERFUNDRAISERID PROSPECTMANAGERFUNDRAISERID      
 IX_ADDPROSPECTPLANSPROCESS_PROSPECTPLANTYPECODEID PROSPECTPLANTYPECODEID      
 IX_ADDPROSPECTPLANSPROCESS_SECONDARYMANAGERFUNDRAISERID SECONDARYMANAGERFUNDRAISERID      
 PK_ADDPROSPECTPLANSPROCESS ID  
 UC_ADDPROSPECTPLANSPROCESS_NAME NAME    

Trigger Name Description
 TR_ADDPROSPECTPLANSPROCESS_AUDIT_UPDATE
 TR_ADDPROSPECTPLANSPROCESS_AUDIT_DELETE

Referenced by Field
 ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION ADDPROSPECTPLANSPROCESSID
 ADDPROSPECTPLANSPROCESSSECONDARYFUNDRAISER ADDPROSPECTPLANSPROCESSID
 ADDPROSPECTPLANSPROCESSSITE ADDPROSPECTPLANSPROCESSID
 ADDPROSPECTPLANSPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table