SCHEDULINGEXCEPTION

Scheduling Exceptions

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
DIFFERENTGENDER bit Default = 1 Indicates to check if student is assigned different gender than course.
DIFFERENTSCHOOL bit Default = 1 Indicates to check if student is assigned different school than course.
DIFFERENTGRADELEVEL bit Default = 1 Indicates to check if student is assigned different grade level than course.
ALREADYTAKEN bit Default = 1 Indicates to check if student has already taken course.
ALREADYREQUESTED bit Default = 1 Indicates to check if student has already requested course.
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
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_SCHEDULINGEXCEPTION_DATEADDED DATEADDED yes
IX_SCHEDULINGEXCEPTION_DATECHANGED DATECHANGED
PK_SCHEDULINGEXCEPTION ID yes yes

Triggers

Trigger Name Description
TR_SCHEDULINGEXCEPTION_ENSUREONEROW_DELETE
TR_SCHEDULINGEXCEPTION_ENSUREONEROW_INSERT
TR_SCHEDULINGEXCEPTION_AUDIT_UPDATE
TR_SCHEDULINGEXCEPTION_AUDIT_DELETE