BATCHEDUCATIONALHISTORYUPDATE

Stores educational history update batch information.

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Field	Field Type	Null	Notes	Description
SEQUENCE	int		Default = 0
CONSTITUENTLOOKUPID	nvarchar(100)		Default = ''
CONSTITUENTKEYNAME	nvarchar(100)		Default = ''
CONSTITUENTFIRSTNAME	nvarchar(50)		Default = ''
EDUCATIONALINSTITUTIONNAME	nvarchar(100)		Default = ''
EDUCATIONALINSTITUTIONFICECODE	nvarchar(50)		Default = ''
EDUCATIONALINSTITUTIONCITY	nvarchar(150)		Default = ''
ISPRIMARYRECORD	bit		Default = 0
CONSTITUENCYSTATUSCODE	tinyint		Default = 0	0=Unknown, 1=Currently attending, 2=Incomplete, 3=Graduated
CONSTITUENCYSTATUS	nvarchar(19) (Computed)	yes	CASE [CONSTITUENCYSTATUSCODE] WHEN 0 THEN N'Unknown' WHEN 1 THEN N'Currently attending' WHEN 2 THEN N'Incomplete' WHEN 3 THEN N'Graduated' END	Provides a translation for the 'CONSTITUENCYSTATUSCODE' field.
DATELEFT	UDT_FUZZYDATE		Default = '00000000'
DATEGRADUATED	UDT_FUZZYDATE		Default = '00000000'
STARTDATE	UDT_FUZZYDATE		Default = '00000000'
CLASSYEAR	UDT_YEAR		Default = ((0))
PREFERREDCLASSYEAR	UDT_YEAR		Default = ((0))
EDUCATIONALSOURCEDATE	UDT_FUZZYDATE		Default = '00000000'
COMMENT	nvarchar(500)		Default = ''
USEACADEMICCATALOG	bit		Default = 0
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 Key	Field Type	Null	Notes	Description
BATCHID	uniqueidentifier		BATCH.ID	FK to BATCH
PRIMARYRECORDID	uniqueidentifier	yes	EDUCATIONALHISTORY.ID	FK to EDUCATIONALHISTORY
PRIMARYCONTEXTRECORDID	uniqueidentifier	yes	CONSTITUENT.LOCALID	FK to CONSTITUENT
EDUCATIONALINSTITUTIONID	uniqueidentifier	yes	EDUCATIONALINSTITUTION.ID	FK to EDUCATIONALINSTITUTION
EDUCATIONALINSTITUTIONCOUNTRYID	uniqueidentifier	yes	COUNTRY.LOCALID	FK to COUNTRY
EDUCATIONALINSTITUTIONSTATEID	uniqueidentifier	yes	STATE.LOCALID	FK to STATE
ACADEMICCATALOGPROGRAMID	uniqueidentifier	yes	ACADEMICCATALOGPROGRAM.ID	FK to ACADEMICCATALOGPROGRAM
EDUCATIONALPROGRAMCODEID	uniqueidentifier	yes	EDUCATIONALPROGRAMCODE.ID	FK to EDUCATIONALPROGRAMCODE
EDUCATIONALHISTORYREASONCODEID	uniqueidentifier	yes	EDUCATIONALHISTORYREASONCODE.ID	FK to EDUCATIONALHISTORYREASONCODE
EDUCATIONALHISTORYLEVELCODEID	uniqueidentifier	yes	EDUCATIONALHISTORYLEVELCODE.ID	FK to EDUCATIONALHISTORYLEVELCODE
ACADEMICCATALOGDEGREEID	uniqueidentifier	yes	ACADEMICCATALOGDEGREE.ID	FK to ACADEMICCATALOGDEGREE
EDUCATIONALDEGREECODEID	uniqueidentifier	yes	EDUCATIONALDEGREECODE.ID	FK to EDUCATIONALDEGREECODE
EDUCATIONALAWARDCODEID	uniqueidentifier	yes	EDUCATIONALAWARDCODE.ID	FK to EDUCATIONALAWARDCODE
EDUCATIONALSOURCECODEID	uniqueidentifier	yes	EDUCATIONALSOURCECODE.ID	FK to EDUCATIONALSOURCECODE
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID	FK to CHANGEAGENT.
EDUCATIONALHISTORYSTATUSID	uniqueidentifier	yes	EDUCATIONALHISTORYSTATUS.ID	FK to EDUCATIONALHISTORYSTATUS

Index Name	Fields	Unique	Primary	Clustered
IX_BATCHEDUCATIONALHISTORYUPDATE_BATCHID	BATCHID
IX_BATCHEDUCATIONALHISTORYUPDATE_DATEADDED	DATEADDED			yes
IX_BATCHEDUCATIONALHISTORYUPDATE_DATECHANGED	DATECHANGED
IX_BATCHEDUCATIONALHISTORYUPDATE_PRIMARYCONTEXTRECORDID	PRIMARYCONTEXTRECORDID
PK_BATCHEDUCATIONALHISTORYUPDATE	ID	yes	yes

Trigger Name	Description
TR_BATCHEDUCATIONALHISTORYUPDATE_AUDIT_UPDATE
TR_BATCHEDUCATIONALHISTORYUPDATE_AUDIT_DELETE

Referenced by	Field
BATCHEDUCATIONALHISTORYUPDATEAFFILIATEDADDITIONALINFORMATION	BATCHEDUCATIONALHISTORYUPDATEID
BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES	BATCHEDUCATIONALHISTORYUPDATEID
BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE	ID
BATCHEDUCATIONALHISTORYUPDATEEDUCATIONALINVOLVEMENTS	BATCHEDUCATIONALHISTORYUPDATEID
BATCHEDUCATIONALHISTORYUPDATEUNAFFILIATEDADDITIONALINFORMATION	BATCHEDUCATIONALHISTORYUPDATEID