Primary Key Field Type
 ID uniqueidentifier

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) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_SCHEDULINGEXCEPTION_DATEADDED DATEADDED    
 IX_SCHEDULINGEXCEPTION_DATECHANGED DATECHANGED      
 PK_SCHEDULINGEXCEPTION ID  

Trigger Name Description
 TR_SCHEDULINGEXCEPTION_ENSUREONEROW_DELETE
 TR_SCHEDULINGEXCEPTION_ENSUREONEROW_INSERT
 TR_SCHEDULINGEXCEPTION_AUDIT_UPDATE
 TR_SCHEDULINGEXCEPTION_AUDIT_DELETE