Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTDATE datetime   The first date in this financial information period.
 ENDDATE datetime   The final date in this financial information period.
 BOOKVALUESTART money   Default = 0 The book value of this purpose at the start of the period specified.
 BOOKVALUEEND money   Default = 0 The book value of this purpose at the end of the period specified.
 MARKETVALUESTART money   Default = 0 The market value of this purpose at the start of the period specified.
 MARKETVALUEEND money   Default = 0 The market value of this purpose at the end of the period specified.
 TOTALGIFTREVENUE money   Default = 0 The total amount of gifts given to this purpose.
 PLEDGEBALANCE money   Default = 0 The total amount of outstanding pledge gifts given to this purpose.
 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.
 TOTALDISBURSEMENTS money   Default = 0 The total amount of disbursements for this purpose.
 ORGANIZATIONBOOKVALUESTART money   Default = 0 The book value of this purpose at the start of the period specified in organization currency.
 ORGANIZATIONBOOKVALUEEND money   Default = 0 The book value of this purpose at the end of the period specified in organization currency.
 ORGANIZATIONMARKETVALUESTART money   Default = 0 The market value of this purpose at the start of the period specified in organization currency.
 ORGANIZATIONMARKETVALUEEND money   Default = 0 The market value of this purpose at the end of the period specified in organization currency.
 ORGANIZATIONTOTALGIFTREVENUE money   Default = 0 The total amount of gifts given to this purpose in organization currency.
 ORGANIZATIONTOTALDISBURSEMENTS money   Default = 0 The total amount of disbursements for this purpose in organization currency.
 ORGANIZATIONPLEDGEBALANCE money   Default = 0 The total amount of outstanding pledge gifts given to this purpose in organization currency.

Foreign Key Field Type Null Notes Description
 DESIGNATIONLEVELID uniqueidentifier   DESIGNATIONLEVEL.ID The fundraising purpose to which this financial data belongs.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 ORGANIZATIONEXCHANGERATEID uniqueidentifier CURRENCYEXCHANGERATE.ID The exchange rate used to convert from amount to organization amount.
 BASECURRENCYID uniqueidentifier CURRENCY.ID The base currency associated with this disbursement.

Index Name Field(s) Unique Primary Clustered
 IX_DESIGNATIONLEVELFINANCIALINFO_BASECURRENCYID BASECURRENCYID      
 IX_DESIGNATIONLEVELFINANCIALINFO_DATEADDED DATEADDED    
 IX_DESIGNATIONLEVELFINANCIALINFO_DATECHANGED DATECHANGED      
 IX_DESIGNATIONLEVELFINANCIALINFO_DESIGNATIONLEVELID DESIGNATIONLEVELID      
 IX_DESIGNATIONLEVELFINANCIALINFO_ORGANIZATIONEXCHANGERATEID ORGANIZATIONEXCHANGERATEID      
 PK_DESIGNATIONLEVELFINANCIALINFO ID  

Trigger Name Description
 TR_DESIGNATIONLEVELFINANCIALINFO_INSERTUPDATE_CURRENCY
 TR_DESIGNATIONLEVELFINANCIALINFO_AUDIT_UPDATE
 TR_DESIGNATIONLEVELFINANCIALINFO_AUDIT_DELETE

Entity-Relationship diagram of this table