BATCHCONSTITUENTEDUCATIONALINVOLVEMENT

This table contains information about a constituent's educational involvement.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
DATEFROM	UDT_FUZZYDATE		Default = '00000000'	The date from which the constituent was involved.
DATETO	UDT_FUZZYDATE		Default = '00000000'	The date to which the constituent was involved.
COMMENT	nvarchar(500)		Default = ''	Any comments for the involvement.
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.
POSITION	nvarchar(256)		Default = ''	The position of the constituent in relation to the involvement.

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
BATCHCONSTITUENTID	uniqueidentifier		BATCHCONSTITUENT.ID	A foreign key to the constituent batch table.
EDUCATIONALINVOLVEMENTTYPECODEID	uniqueidentifier		EDUCATIONALINVOLVEMENTTYPECODE.ID	Indicates the involvement record's type.
EDUCATIONALINSTITUTIONID	uniqueidentifier	yes	EDUCATIONALINSTITUTION.ID	A foreign key to the educational institution table.
EDUCATIONALINVOLVEMENTAWARDCODEID	uniqueidentifier	yes	EDUCATIONINVOLVEMENTAWARDCODE.ID	Indicates the award for the involvement.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
EDUCATIONALINVOLVEMENTNAMEID	uniqueidentifier	yes	EDUCATIONALINVOLVEMENTNAME.ID	Indicates the involvement record's name.
EDUCATIONALPROGRAMCODEID	uniqueidentifier	yes	EDUCATIONALPROGRAMCODE.ID	FK to EDUCATIONALPROGRAMCODE
EDUCATIONALCOLLEGECODEID	uniqueidentifier	yes	EDUCATIONALCOLLEGECODE.ID	FK to EDUCATIONALCOLLEGECODE
EDUCATIONALDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALDEPARTMENTCODE.ID	FK to EDUCATIONALDEPARTMENTCODE
ACADEMICCATALOGPROGRAMID	uniqueidentifier	yes	ACADEMICCATALOGPROGRAM.ID	FK to ACADEMICCATALOGPROGRAM
ACADEMICCATALOGCOLLEGEID	uniqueidentifier	yes	ACADEMICCATALOGCOLLEGE.ID	FK to ACADEMICCATALOGCOLLEGE
ACADEMICCATALOGDEPARTMENTID	uniqueidentifier	yes	ACADEMICCATALOGDEPARTMENT.ID	FK to ACADEMICCATALOGDEPARTMENT
EDUCATIONALDIVISIONCODEID	uniqueidentifier	yes	EDUCATIONALDIVISIONCODE.ID	FK to EDUCATIONALDIVISIONCODE
EDUCATIONALSUBDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALSUBDEPARTMENTCODE.ID	FK to EDUCATIONALSUBDEPARTMENTCODE
ACADEMICCATALOGDIVISIONID	uniqueidentifier	yes	ACADEMICCATALOGDIVISION.ID	FK to ACADEMICCATALOGDIVISION
ACADEMICCATALOGSUBDEPARTMENTID	uniqueidentifier	yes	ACADEMICCATALOGSUBDEPARTMENT.ID	FK to ACADEMICCATALOGSUBDEPARTMENT

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHCONSTITUENTEDUCATIONALINVOLVEMENT_DATEADDED	DATEADDED			yes
IX_BATCHCONSTITUENTEDUCATIONALINVOLVEMENT_DATECHANGED	DATECHANGED
PK_BATCHCONSTITUENTEDUCATIONALINVOLVEMENT	ID	yes	yes

Triggers

Trigger Name	Description
TR_BATCHCONSTITUENTEDUCATIONALINVOLVEMENT_AUDIT_UPDATE
TR_BATCHCONSTITUENTEDUCATIONALINVOLVEMENT_AUDIT_DELETE