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.
 INCLUDEGRANTAWARDS bit   Default = 0 Indicates that grant award records should be processed when processing records by transaction type.
 INCLUDEPLANNEDGIFTS bit   Default = 0 Indicates that planned gift records should be processed when processing records by transaction type.
 INCLUDEPLEDGES bit   Default = 0 Indicates that pledge records should be processed when processing records by transaction type.
 INCLUDERECURRINGGIFTS bit   Default = 0 Indicates that recurring gift records should be processed when processing records by transaction type.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the acknowledgement process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the acknowledgement 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.
 REVALUEBYTYPECODE tinyint   Default = 0 The source of records included in the process.
 REVALUEBYTYPE nvarchar(16) (Computed) CASE [REVALUEBYTYPECODE] WHEN 0 THEN N'Transaction type' WHEN 1 THEN N'Selection' END Provides a translation for the 'REVALUEBYTYPECODE' field.
 ADJUSTMENTDATE date The date of the adjustment to the revenue record.
 ADJUSTMENTPOSTDATE date The date to use when posting the adjustment to the revenue record.
 ADJUSTMENTPOSTSTATUSCODE tinyint   Default = 1 Flag used to indicate if the adjustment has been posted.
 ADJUSTMENTPOSTSTATUS nvarchar(11) (Computed) CASE [ADJUSTMENTPOSTSTATUSCODE] WHEN 1 THEN N'Not Posted' WHEN 2 THEN N'Do Not Post' END Provides a translation for the 'ADJUSTMENTPOSTSTATUSCODE' field.
 ADJUSTMENTREASON nvarchar(300)   Default = '' Gives further details for why this adjustment was made.
 CURRENCYEXCHANGERATEASOFTYPECODE tinyint   Default = 0 Designates how the date use to lookup revaluation exchange rates is specified.
 CURRENCYEXCHANGERATEASOFTYPE nvarchar(24) (Computed) CASE [CURRENCYEXCHANGERATEASOFTYPECODE] WHEN 0 THEN N'Date/time process is run' WHEN 1 THEN N'Specific date/time' END Provides a translation for the 'CURRENCYEXCHANGERATEASOFTYPECODE' field.
 CURRENCYEXCHANGERATEASOFDATETIMEOFFSET datetimeoffset The date and time used to lookup revaluation exchange rates.
 CREATEEXCEPTIONIDSET bit   Default = 0 Designates whether or not an exception ID set should be created
 EXCEPTIONIDSETNAME nvarchar(100)   Default = '' The name of the output exception ID set
 OVERWRITEEXCEPTIONIDSET bit   Default = 0 Designates whether or not to overwrite the output exception ID set if one with the same name already exists.
 USEEXCHANGERATEDATEFORADJUSTMENTDATES bit   Default = 1 Designates whether or not to use the date the exchange rates will be selected against as the adjustment date and adjustment post date.
 INCLUDEINSTALLMENTPLANS bit   Default = 0

Foreign Key Field Type Null Notes Description
 IDSETREGISTERID uniqueidentifier IDSETREGISTER.ID A foreign key to the ID set used to filter records included in the process.
 CURRENCYEXCHANGERATESOURCECODEID uniqueidentifier CURRENCYEXCHANGERATESOURCECODE.ID The source used to lookup revaluation exchange rates.
 OUTPUTIDSETRECORDTYPEID uniqueidentifier RECORDTYPE.ID A foreign key to the record type of the output ID set to be created by the acknowledgement process.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 TIMEZONEENTRYID uniqueidentifier TIMEZONEENTRY.ID The time zone of the date used to lookup revaluation exchange rates.
 ADJUSTMENTREASONCODEID uniqueidentifier ADJUSTMENTREASONCODE.ID Indicates the reason this adjustment was made.

Index Name Field(s) Unique Primary Clustered
 IX_REVALUECOMMITMENTSPROCESS_DATEADDED DATEADDED    
 IX_REVALUECOMMITMENTSPROCESS_DATECHANGED DATECHANGED      
 PK_REVALUECOMMITMENTSPROCESS ID  
 UC_REVALUECOMMITMENTSPROCESS_NAME NAME    

Trigger Name Description
 TR_REVALUECOMMITMENTSPROCESS_AUDIT_UPDATE
 TR_REVALUECOMMITMENTSPROCESS_AUDIT_DELETE

Referenced by Field
 REVALUECOMMITMENTSPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table