BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION (4.0SP17)

Stores additional education information for a constituent batch.

Primary Key
Primary Key Field Type

ID

uniqueidentifier

Foreign Key Fields
Foreign Key Field Type Null Notes Description

BATCHCONSTITUENTID

uniqueidentifier

false

A foreign key to the constituent batch table.

ACADEMICCATALOGCOLLEGEID

uniqueidentifier

true

A foreign key to the academic catalog college table.

ACADEMICCATALOGDEPARTMENTID

uniqueidentifier

true

A foreign key to the academic catalog department table.

ACADEMICCATALOGDEGREETYPEID

uniqueidentifier

true

A foreign key to the academic catalog degree type table.

EDUCATIONALCOLLEGECODEID

uniqueidentifier

true

The unaffiliated educational college code.

EDUCATIONALDEPARTMENTCODEID

uniqueidentifier

true

The unaffiliated educational department code.

EDUCATIONALDEGREETYPECODEID

uniqueidentifier

true

The unaffiliated educational degree type code.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

ACADEMICCATALOGDIVISIONID

uniqueidentifier

true

A foreign key to the academic catalog division table.

ACADEMICCATALOGSUBDEPARTMENTID

uniqueidentifier

true

A foreign key to the academic catalog sub department table.

EDUCATIONALDIVISIONCODEID

uniqueidentifier

true

The unaffiliated educational division code.

EDUCATIONALSUBDEPARTMENTCODEID

uniqueidentifier

true

The unaffiliated educational sub department code.

Fields
Field Field Type Null Notes Description

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_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_DATEADDED

DATEADDED

False

False

True

IX_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_DATECHANGED

DATECHANGED

False

False

False

PK_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION

ID

True

True

False

Triggers
Trigger Name Description

TR_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_AUDIT_UPDATE

TR_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_AUDIT_DELETE