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.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the pledge reminder process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the pledge reminder process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 DATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the pledge reminder process.
 DATE datetime   This date is used as the cut-off date for determining the amount that is due for each pledge for which a reminder is generated.
 LETTERFILENAME nvarchar(255)   Default = '' Filename of the letter template to use for this process.
 LETTERFILE varbinary The actual letter template file to use for this process.
 MARKREMINDERSSENT bit   Default = 0 Indicates whether or not reminders for this process should be marked as sent.
 SENTDATETYPECODE tinyint   Default = 0 Designates whether to use today's date or a specific date in the pledge reminder process as the sent date.
 SENTDATE datetime This date is used as the sent date when marking records as sent.
 LABELFILENAME nvarchar(255)   Default = '' The original file name for the label template.
 LABELFILE varbinary The actual file for the label template.
 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.
 EXCLUDEMAIL bit   Default = 0 Exclude constituents who prefer not to be contacted by mail.
 EXCLUDEPHONE bit   Default = 0 Exclude constituents who prefer not to be contacted by phone.
 EXCLUDEEMAIL bit   Default = 0 Exclude constituents who prefer not to be contacted by email.
 CUSTOMPARAMETERDATAFORMITEM xml Custom parameters for this process.
 DATETYPE nvarchar(13) (Computed) CASE [DATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END Provides a translation for the 'DATETYPECODE' field.
 SENTDATETYPE nvarchar(13) (Computed) CASE [SENTDATETYPECODE] WHEN 0 THEN N'Today' WHEN 1 THEN N'Specific date' END Provides a translation for the 'SENTDATETYPECODE' field.
 ISRECURRINGGIFTS bit   Default = 0 Sets whether the reminder process should work for all recurring gifts
 ISPLEDGES bit   Default = 0 Sets whether the reminder process should work for all pledges
 OUTPUTGROUPINGCODE tinyint   Default = 0 Indicates the way the output is going to be produced, as a single file or two files.
 OUTPUTGROUPING nvarchar(11) (Computed) CASE [OUTPUTGROUPINGCODE] WHEN 0 THEN N'Commitment' WHEN 1 THEN N'Constituent' END Provides a translation for the 'OUTPUTGROUPINGCODE' field.

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter the records included in the pledge reminder process.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the pledge reminder process.
 BUSINESSPROCESSVIEWID uniqueidentifier BUSINESSPROCESSVIEW.ID A foreign key to the view to use as output for the parameter set.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 EXPORTDEFINITIONID uniqueidentifier EXPORTDEFINITION.ID FK to EXPORTDEFINITION

Index Name Field(s) Unique Primary Clustered
 IX_PLEDGEREMINDERPROCESS_DATEADDED DATEADDED    
 IX_PLEDGEREMINDERPROCESS_DATECHANGED DATECHANGED      
 PK_PLEDGEREMINDERPROCESS ID  
 UC_PLEDGEREMINDERPROCESS_NAME NAME    

Trigger Name Description
 TR_PLEDGEREMINDERPROCESS_DELETE_BUSINESSPROCESSINSTANCE
 TR_PLEDGEREMINDERPROCESS_AUDIT_UPDATE
 TR_PLEDGEREMINDERPROCESS_AUDIT_DELETE

Referenced by Field
 MAILPREFERENCE PLEDGEREMINDERID
 PLEDGEREMINDERPROCESSEXPORTFORMAT PARAMETERSETID
 PLEDGEREMINDERPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table