EDUCATIONALHISTORYSTATUSHISTORY

This table stores the status information for an enrollment.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
STATUSDATE	datetime			Date when status information has changed.
STATUSREASON	nvarchar(100)		Default = ''	Reason why status has changed.
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.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
EDUCATIONALHISTORYSTATUSID	uniqueidentifier		EDUCATIONALHISTORYSTATUS.ID	Foreign key to the status type.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
EDUCATIONALHISTORYID	uniqueidentifier		EDUCATIONALHISTORY.ID	Foreign key to parent education record.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EDUCATIONALHISTORYSTATUSHISTORY_DATEADDED	DATEADDED			yes
IX_EDUCATIONALHISTORYSTATUSHISTORY_DATECHANGED	DATECHANGED
IX_EDUCATIONALHISTORYSTATUSHISTORY_EDUCATIONALHISTORYID	EDUCATIONALHISTORYID
PK_EDUCATIONALHISTORYSTATUSHISTORY	ID	yes	yes

Triggers

Trigger Name	Description
TR_EDUCATIONALHISTORYSTATUSHISTORY_MARKASCONSTITUENT
TR_EDUCATIONALHISTORYSTATUSHISTORY_AUDIT_UPDATE
TR_EDUCATIONALHISTORYSTATUSHISTORY_AUDIT_DELETE