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.
 POSTDATE datetime This date is used as the post date for the pledges to be written off.
 POSTSTATUSCODE tinyint   Default = 1 Flag used to indicate whether write-off should be posted or needs to be posted.
 REASON nvarchar(300)   Default = '' Indicates the reason this write-off was made.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the pledge write-off process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the pledge write-off process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 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.
 POSTSTATUS nvarchar(11) (Computed) CASE [POSTSTATUSCODE] WHEN 1 THEN N'Not posted' WHEN 2 THEN N'Do not post' END Provides a translation for the 'POSTSTATUSCODE' 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 write-off process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 REASONCODEID uniqueidentifier WRITEOFFREASONCODE.ID Indicates the reason this write-off was made.

Index Name Field(s) Unique Primary Clustered
 IX_PLEDGEWRITEOFFPROCESS_DATEADDED DATEADDED    
 IX_PLEDGEWRITEOFFPROCESS_DATECHANGED DATECHANGED      
 PK_PLEDGEWRITEOFFPROCESS ID  
 UC_PLEDGEWRITEOFFPROCESS_NAME NAME    

Trigger Name Description
 TR_PLEDGEWRITEOFFPROCESS_AUDIT_UPDATE
 TR_PLEDGEWRITEOFFPROCESS_AUDIT_DELETE

Referenced by Field
 PLEDGEWRITEOFFPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table