CLOSINGREQUIREMENT

This table stores high level fields for closing requirements.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DESCRIPTION	nvarchar(60)		Default = ''	Description of the closing requirement.
NETASSETCLASSIFICATIONCODE	tinyint		Default = 0	Net Asset Classification
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.
NETASSETCLASSIFICATION	nvarchar(33) (Computed)	yes	CASE [NETASSETCLASSIFICATIONCODE] WHEN 1 THEN N'Unrestricted net assets' WHEN 2 THEN N'Temporarily restricted net assets' WHEN 3 THEN N'Permanently restricted net assets' END	Provides a translation for the 'NETASSETCLASSIFICATIONCODE' field.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
LEDGERACCOUNTID	uniqueidentifier	yes	GLACCOUNT.ID	Closing account string
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
DATAELEMENTID	uniqueidentifier	yes	PDACCOUNTSEGMENTVALUE.ID	Specific item ID
DATAELEMENTQUERYID	uniqueidentifier	yes	IDSETREGISTER.ID	Selection ID
PDACCOUNTSYSTEMID	uniqueidentifier		PDACCOUNTSYSTEM.ID	FK to PDACCOUNTSYSTEM

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_CLOSINGREQUIREMENT_DATEADDED	DATEADDED			yes
IX_CLOSINGREQUIREMENT_DATECHANGED	DATECHANGED
PK_CLOSINGREQUIREMENT	ID	yes	yes
UC_CLOSINGREQUIREMENT_DESCRIPTION	DESCRIPTION	yes

Triggers

Trigger Name	Description
TR_CLOSINGREQUIREMENT_AUDIT_UPDATE
TR_CLOSINGREQUIREMENT_AUDIT_DELETE

Referenced by

Referenced by	Field
CLOSINGREQUIREMENTDETAIL	CLOSINGREQUIREMENTID