Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTDATE date   The start date for the period within which the course being requested should be scheduled. When using academic years, this is the session start date.
 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.
 ENDDATE date   The end date for the period within which the course being requested should be scheduled. When using academic years, this is the session end date.
 CLASSSTARTDATE date The start date the student is requesting for the course. When using academic years, this is the class term start date.

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

Index Name Field(s) Unique Primary Clustered
 IX_STUDENTCOURSEREQUEST_DATEADDED DATEADDED    
 IX_STUDENTCOURSEREQUEST_DATECHANGED DATECHANGED      
 PK_STUDENTCOURSEREQUEST ID  

Trigger Name Description
 TR_STUDENTCOURSEREQUEST_AUDIT_UPDATE
 TR_STUDENTCOURSEREQUEST_AUDIT_DELETE
 TR_STUDENTCOURSEREQUEST_DELETE

Entity-Relationship diagram of this table