DESIGNATIONLEVELDECAPITALIZATION

Contains information pertaining to purpose decapitalization.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
APPROVALDATE	UDT_FUZZYDATE		Default = '00000000'	Approval Date
AMOUNT	money		Default = 0.0	Amount
RATIONALE	nvarchar(max)		Default = ''	Rationale
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.
ORGANIZATIONAMOUNT	money		Default = 0	Amount in organization currency.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
DESIGNATIONLEVELID	uniqueidentifier		DESIGNATIONLEVEL.ID	Designation Level ID
APPROVEDBYID	uniqueidentifier		CONSTITUENT.LOCALID	Approved By
ACCOUNTID	uniqueidentifier		DESIGNATION.ID	Account transferred to
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 decapitalization.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_DESIGNATIONLEVELDECAPITALIZATION_APPROVEDBYID	APPROVEDBYID
IX_DESIGNATIONLEVELDECAPITALIZATION_BASECURRENCYID	BASECURRENCYID
IX_DESIGNATIONLEVELDECAPITALIZATION_DATEADDED	DATEADDED			yes
IX_DESIGNATIONLEVELDECAPITALIZATION_DATECHANGED	DATECHANGED
IX_DESIGNATIONLEVELDECAPITALIZATION_ORGANIZATIONEXCHANGERATEID	ORGANIZATIONEXCHANGERATEID
PK_DESIGNATIONLEVELDECAPITALIZATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_DESIGNATIONLEVELDECAPITALIZATION_AUDIT_UPDATE
TR_DESIGNATIONLEVELDECAPITALIZATION_AUDIT_DELETE
TR_DESIGNATIONLEVELDECAPITALIZATION_INSERTUPDATE_CURRENCY