DESIGNATIONLEVELFINANCIALINFO

Stores information pertaining to Fundraising Purpose Financial Information.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	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 Keys

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	yes	CURRENCYEXCHANGERATE.ID	The exchange rate used to convert from amount to organization amount.
BASECURRENCYID	uniqueidentifier	yes	CURRENCY.ID	The base currency associated with this disbursement.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DESIGNATIONLEVELFINANCIALINFO_BASECURRENCYID	BASECURRENCYID
IX_DESIGNATIONLEVELFINANCIALINFO_DATEADDED	DATEADDED			yes
IX_DESIGNATIONLEVELFINANCIALINFO_DATECHANGED	DATECHANGED
IX_DESIGNATIONLEVELFINANCIALINFO_DESIGNATIONLEVELID	DESIGNATIONLEVELID
IX_DESIGNATIONLEVELFINANCIALINFO_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID
PK_DESIGNATIONLEVELFINANCIALINFO	ID	yes	yes

Triggers

Trigger Name	Description
TR_DESIGNATIONLEVELFINANCIALINFO_AUDIT_UPDATE
TR_DESIGNATIONLEVELFINANCIALINFO_AUDIT_DELETE
TR_DESIGNATIONLEVELFINANCIALINFO_INSERTUPDATE_CURRENCY