Open topic with navigation

STUDENTRELATIONCONSTITUENCYSETTINGS (4.0SP20)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Contains a list of settings to determine constituency for records with a relationship to a student.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CONSTITUENCYCODEID	uniqueidentifier	false	CONSTITUENCYCODE.ID	Determines what constituency the relation of the student will have.

Fields
Field	Field Type	Null	Notes	Description
ISCONSTITUENTAFTERGRADUATE	bit	false	0	THIS FIELD IS NO LONGER USED
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
RELATEDTOCODE	tinyint	false	0	The constituency type of the student status.
RELATEDTO	nvarchar(7) (Computed)	true		Provides a translation for the 'RELATEDTOCODE' field.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_STUDENTRELATIONCONSTITUENCYSETTINGS_DATEADDED	DATEADDED	False	False	True
IX_STUDENTRELATIONCONSTITUENCYSETTINGS_DATECHANGED	DATECHANGED	False	False	False
PK_STUDENTRELATIONCONSTITUENCYSETTINGS	ID	True	True	False
UIX_STUDENTRELATIONCONSTITUENCYSETTINGS_CONSTITUENCYCODEID_RELATEDTOCODE	CONSTITUENCYCODEID RELATEDTOCODE	True	False	False

Triggers
Trigger Name	Description
TR_STUDENTRELATIONCONSTITUENCYSETTINGS_INSERTUPDATE_MARKCONSTITUENTS
TR_STUDENTRELATIONCONSTITUENCYSETTINGS_AUDIT_UPDATE
TR_STUDENTRELATIONCONSTITUENCYSETTINGS_AUDIT_DELETE

Referenced by
Referenced by	Field
STUDENTRELATIONCONSTITUENCYTYPES	STUDENTRELATIONCONSTITUENCYSETTINGSID