Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PRIMARYMANAGERSTARTDATE datetime The date the fundraiser become the primary manager of the prospect plan.
 SECONDARYMANAGERSTARTDATE datetime The date the fundraiser became the secondary manager of the prospect plan.
 NARRATIVE nvarchar(1000)   Default = ''
 NAME nvarchar(100)   Default = '' The name of the plan.
 STATUSCODE tinyint   Default = 0 The status of request.
 STATUS nvarchar(8) (Computed) CASE [STATUSCODE] WHEN 0 THEN N'Pending' WHEN 1 THEN N'Approved' WHEN 2 THEN N'Denied' WHEN 3 THEN N'Canceled' END Provides a translation for the 'STATUSCODE' field.
 REVIEWDATE datetime Date request was reviewed.
 PROSPECTPLAN_PARTICIPANTS xml XML for prospect plan particpants
 SECONDARYFUNDRAISERS xml XML for secondary fundraisers
 SITES xml XML for sites
 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.

Foreign Key Field Type Null Notes Description
 PROSPECTID uniqueidentifier   CONSTITUENT.LOCALID FK to CONSTITUENT
 PROSPECTPLANTYPECODEID uniqueidentifier   PROSPECTPLANTYPECODE.ID FK to PROSPECTPLANTYPECODE
 PRIMARYMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 SECONDARYMANAGERFUNDRAISERID uniqueidentifier CONSTITUENT.LOCALID FK to CONSTITUENT
 REVIEWEDBYID uniqueidentifier APPUSER.ID App user who reviewed request.
 SUBMITTEDBYID uniqueidentifier   APPUSER.ID App user who requested the change.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PROSPECTPLANREQUEST_DATEADDED DATEADDED    
 IX_PROSPECTPLANREQUEST_DATECHANGED DATECHANGED      
 IX_PROSPECTPLANREQUEST_PRIMARYMANAGERFUNDRAISERID PRIMARYMANAGERFUNDRAISERID      
 IX_PROSPECTPLANREQUEST_SECONDARYMANAGERFUNDRAISERID SECONDARYMANAGERFUNDRAISERID      
 PK_PROSPECTPLANREQUEST ID  
 UIX_PROSPECTPLANREQUEST_PROSPECTID_PROSPECTPLANTYPECODEID_NAME PROSPECTID, PROSPECTPLANTYPECODEID, NAME    

Trigger Name Description
 TR_PROSPECTPLANREQUEST_AUDIT_UPDATE
 TR_PROSPECTPLANREQUEST_AUDIT_DELETE

Entity-Relationship diagram of this table