Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 AMOUNT money   Default = 0 The amount to be matched.
 METHODTYPECODE tinyint   Default = 0 Indicates how fund was encumbered.
 METHODTYPE nvarchar(16) (Computed) CASE [METHODTYPECODE] WHEN 0 THEN N'Encumber Process' WHEN 1 THEN N'Manual' WHEN 2 THEN N'Reserved' END Provides a translation for the 'METHODTYPECODE' field.
 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.
 STATUSTYPECODE tinyint   Default = 0 Indicates the status.
 STATUSTYPE nvarchar(10) (Computed) CASE [STATUSTYPECODE] WHEN 0 THEN N'Encumbered' WHEN 1 THEN N'Matched' WHEN 2 THEN N'Removed' END Provides a translation for the 'STATUSTYPECODE' field.
 ORGANIZATIONAMOUNT money   Default = 0 AMOUNT in the organization currency.

Foreign Key Field Type Null Notes Description
 DONORCHALLENGEID uniqueidentifier   DONORCHALLENGE.ID The donor challenge record to which this designation belongs.
 REVENUESPLITID uniqueidentifier FINANCIALTRANSACTIONLINEITEM.ID Revenue split record for the given encumbered fund.
 DESIGNATIONID uniqueidentifier DESIGNATION.ID Designation record for the given encumbered fund.
 CONSTITUENTID uniqueidentifier CONSTITUENT.LOCALID Constituent record for the reserved fund.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 REVENUERECOGNITIONTYPECODEID uniqueidentifier REVENUERECOGNITIONTYPECODE.ID Stores the recognition credit type associated with this record
 MATCHEDREVENUEID uniqueidentifier FINANCIALTRANSACTION.ID Revenue record for the matched fund.
 MATCHEDREVENUERECOGNITIONID uniqueidentifier REVENUERECOGNITION.ID Revenue recognition credit id for the matched fund.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with the encumbered split (matches the donor challenge).
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID FK to CURRENCYEXCHANGERATE

Index Name Field(s) Unique Primary Clustered
 IX_DONORCHALLENGEENCUMBERED_CONSTITUENTID CONSTITUENTID      
 IX_DONORCHALLENGEENCUMBERED_DATEADDED DATEADDED    
 IX_DONORCHALLENGEENCUMBERED_DATECHANGED DATECHANGED      
 IX_DONORCHALLENGEENCUMBERED_DONORCHALLENGEID_REVENUESPLITID DONORCHALLENGEID, REVENUESPLITID      
 IX_DONORCHALLENGEENCUMBERED_MATCHEDREVENUEID MATCHEDREVENUEID      
 IX_DONORCHALLENGEENCUMBERED_REVENUESPLITID REVENUESPLITID      
 PK_DONORCHALLENGEENCUMBERED ID  

Trigger Name Description
 TR_DONORCHALLENGEENCUMBERED_INSERTUPDATE_CURRENCY
 TR_DONORCHALLENGEENCUMBERED_AUDIT_UPDATE
 TR_DONORCHALLENGEENCUMBERED_AUDIT_DELETE

Referenced by Field
 RECOGNITIONCREDIT DONORCHALLENGEENCUMBEREDID

Entity-Relationship diagram of this table