BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION

Stores additional education information for a constituent batch.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
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
BATCHCONSTITUENTID	uniqueidentifier		BATCHCONSTITUENT.ID	A foreign key to the constituent batch table.
ACADEMICCATALOGCOLLEGEID	uniqueidentifier	yes	ACADEMICCATALOGCOLLEGE.ID	A foreign key to the academic catalog college table.
ACADEMICCATALOGDEPARTMENTID	uniqueidentifier	yes	ACADEMICCATALOGDEPARTMENT.ID	A foreign key to the academic catalog department table.
ACADEMICCATALOGDEGREETYPEID	uniqueidentifier	yes	ACADEMICCATALOGDEGREETYPE.ID	A foreign key to the academic catalog degree type table.
EDUCATIONALCOLLEGECODEID	uniqueidentifier	yes	EDUCATIONALCOLLEGECODE.ID	The unaffiliated educational college code.
EDUCATIONALDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALDEPARTMENTCODE.ID	The unaffiliated educational department code.
EDUCATIONALDEGREETYPECODEID	uniqueidentifier	yes	EDUCATIONALDEGREETYPECODE.ID	The unaffiliated educational degree type code.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
ACADEMICCATALOGDIVISIONID	uniqueidentifier	yes	ACADEMICCATALOGDIVISION.ID	A foreign key to the academic catalog division table.
ACADEMICCATALOGSUBDEPARTMENTID	uniqueidentifier	yes	ACADEMICCATALOGSUBDEPARTMENT.ID	A foreign key to the academic catalog sub department table.
EDUCATIONALDIVISIONCODEID	uniqueidentifier	yes	EDUCATIONALDIVISIONCODE.ID	The unaffiliated educational division code.
EDUCATIONALSUBDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALSUBDEPARTMENTCODE.ID	The unaffiliated educational sub department code.

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_DATEADDED	DATEADDED			yes
IX_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_DATECHANGED	DATECHANGED
PK_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_AUDIT_UPDATE
TR_BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION_AUDIT_DELETE