Open topic with navigation

ACADEMICCATALOGDEGREE (4.0SP5)

An academic catalog degree is represented by a row in this table.

Primary Key
Primary Key Field Type

ID

uniqueidentifier
Foreign Key Fields
Foreign Key Field Type Null Notes Description

ACADEMICCATALOGPROGRAMID

uniqueidentifier

false

A foreign key to the academic catalog program table.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.
Fields
Field Field Type Null Notes Description

USERID

nvarchar(50)

false

''

The unique user defined ID.

NAME

nvarchar(150)

false

''

The name of the college.

CURRENTID

uniqueidentifier

true

The most current degree record.

DATEFROM

UDT_FUZZYDATE

false

'00000000'

The date the degree began.

DATETO

UDT_FUZZYDATE

false

'00000000'

The date the degree became historical.

COMMENT

nvarchar(500)

false

''

Comments about the degree being historical.

ISHISTORICAL

bit

false

0

Indicates if this record has been made historical.

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.
Indexes
Index Name Field(s) Unique Primary Clustered

IX_ACADEMICCATALOGDEGREE_DATEADDED

DATEADDED

False

False

True

IX_ACADEMICCATALOGDEGREE_DATECHANGED

DATECHANGED

False

False

False

PK_ACADEMICCATALOGDEGREE

ID

True

True

False

UIX_ACADEMICCATALOGDEGREE_ACADEMICCATALOGPROGRAMID_USERID

ACADEMICCATALOGPROGRAMID

USERID

True

False

False
Triggers
Trigger Name Description

TR_ACADEMICCATALOGDEGREE_AUDIT_UPDATE

TR_ACADEMICCATALOGDEGREE_AUDIT_DELETE

Referenced by
Referenced by Field

ACADEMICCATALOGCOLLEGE

ACADEMICCATALOGDEGREEID

BATCHCONSTITUENT

EDUCATIONALHISTORY_ACADEMICCATALOGDEGREEID

BATCHEDUCATIONALHISTORYUPDATE

ACADEMICCATALOGDEGREEID

EDUCATIONALHISTORY

ACADEMICCATALOGDEGREEID