EDUCATIONALINVOLVEMENT

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
CONSTITUENTID	uniqueidentifier		CONSTITUENT.LOCALID	A foreign key to the constituent table.
EDUCATIONALINVOLVEMENTTYPECODEID	uniqueidentifier		EDUCATIONALINVOLVEMENTTYPECODE.ID	Indicates the involvement record's type.
EDUCATIONALINSTITUTIONID	uniqueidentifier	yes	EDUCATIONALINSTITUTION.ID	A foreign key to the educational institution table.
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
EDUCATIONALINVOLVEMENTAWARDCODEID	uniqueidentifier	yes	EDUCATIONINVOLVEMENTAWARDCODE.ID	Indicates the award associated with the involvement.
EDUCATIONALINVOLVEMENTNAMEID	uniqueidentifier	yes	EDUCATIONALINVOLVEMENTNAME.ID	Indicates the involvement record's name.
ACADEMICCATALOGPROGRAMID	uniqueidentifier	yes	ACADEMICCATALOGPROGRAM.ID	A foreign key to the academic catalog program 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.
EDUCATIONALDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALDEPARTMENTCODE.ID	The unaffiliated educational department code.
EDUCATIONALPROGRAMCODEID	uniqueidentifier	yes	EDUCATIONALPROGRAMCODE.ID	FK to EDUCATIONALPROGRAMCODE
EDUCATIONALCOLLEGECODEID	uniqueidentifier	yes	EDUCATIONALCOLLEGECODE.ID	FK to EDUCATIONALCOLLEGECODE
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	FK to EDUCATIONALDIVISIONCODE
EDUCATIONALSUBDEPARTMENTCODEID	uniqueidentifier	yes	EDUCATIONALSUBDEPARTMENTCODE.ID	FK to EDUCATIONALSUBDEPARTMENTCODE

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_EDUCATIONALINVOLVEMENT_CONSTITUENTID	CONSTITUENTID
IX_EDUCATIONALINVOLVEMENT_DATEADDED	DATEADDED			yes
IX_EDUCATIONALINVOLVEMENT_DATECHANGED	DATECHANGED
PK_EDUCATIONALINVOLVEMENT	ID	yes	yes

Triggers

Trigger Name	Description
TR_EDUCATIONALINVOLVEMENT_AUDIT_ETLDELETEDID
TR_EDUCATIONALINVOLVEMENT_AUDIT_UPDATE
TR_EDUCATIONALINVOLVEMENT_AUDIT_DELETE