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) | 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) | CONVERT(bigint, TS) | Numeric representation of the timestamp. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
BATCHID | uniqueidentifier | BATCH.ID | FK to BATCH | |
PRIMARYRECORDID | uniqueidentifier | EDUCATIONALHISTORY.ID | FK to EDUCATIONALHISTORY | |
PRIMARYCONTEXTRECORDID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
EDUCATIONALINSTITUTIONID | uniqueidentifier | EDUCATIONALINSTITUTION.ID | FK to EDUCATIONALINSTITUTION | |
EDUCATIONALINSTITUTIONCOUNTRYID | uniqueidentifier | COUNTRY.LOCALID | FK to COUNTRY | |
EDUCATIONALINSTITUTIONSTATEID | uniqueidentifier | STATE.LOCALID | FK to STATE | |
ACADEMICCATALOGPROGRAMID | uniqueidentifier | ACADEMICCATALOGPROGRAM.ID | FK to ACADEMICCATALOGPROGRAM | |
EDUCATIONALPROGRAMCODEID | uniqueidentifier | EDUCATIONALPROGRAMCODE.ID | FK to EDUCATIONALPROGRAMCODE | |
EDUCATIONALHISTORYREASONCODEID | uniqueidentifier | EDUCATIONALHISTORYREASONCODE.ID | FK to EDUCATIONALHISTORYREASONCODE | |
EDUCATIONALHISTORYLEVELCODEID | uniqueidentifier | EDUCATIONALHISTORYLEVELCODE.ID | FK to EDUCATIONALHISTORYLEVELCODE | |
ACADEMICCATALOGDEGREEID | uniqueidentifier | ACADEMICCATALOGDEGREE.ID | FK to ACADEMICCATALOGDEGREE | |
EDUCATIONALDEGREECODEID | uniqueidentifier | EDUCATIONALDEGREECODE.ID | FK to EDUCATIONALDEGREECODE | |
EDUCATIONALAWARDCODEID | uniqueidentifier | EDUCATIONALAWARDCODE.ID | FK to EDUCATIONALAWARDCODE | |
EDUCATIONALSOURCECODEID | uniqueidentifier | EDUCATIONALSOURCECODE.ID | FK to EDUCATIONALSOURCECODE | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
EDUCATIONALHISTORYSTATUSID | uniqueidentifier | EDUCATIONALHISTORYSTATUS.ID | FK to EDUCATIONALHISTORYSTATUS |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_BATCHEDUCATIONALHISTORYUPDATE_BATCHID | BATCHID | |||
IX_BATCHEDUCATIONALHISTORYUPDATE_DATEADDED | DATEADDED | |||
IX_BATCHEDUCATIONALHISTORYUPDATE_DATECHANGED | DATECHANGED | |||
IX_BATCHEDUCATIONALHISTORYUPDATE_PRIMARYCONTEXTRECORDID | PRIMARYCONTEXTRECORDID | |||
PK_BATCHEDUCATIONALHISTORYUPDATE | ID |
Trigger Name | Description |
---|---|
TR_BATCHEDUCATIONALHISTORYUPDATE_AUDIT_UPDATE | |
TR_BATCHEDUCATIONALHISTORYUPDATE_AUDIT_DELETE |
Referenced by | Field |
---|---|
BATCHEDUCATIONALHISTORYUPDATEAFFILIATEDADDITIONALINFORMATION | BATCHEDUCATIONALHISTORYUPDATEID |
BATCHEDUCATIONALHISTORYUPDATEBATCHSYSTEMMESSAGES | BATCHEDUCATIONALHISTORYUPDATEID |
BATCHEDUCATIONALHISTORYUPDATEBATCHUSERMESSAGE | ID |
BATCHEDUCATIONALHISTORYUPDATEEDUCATIONALINVOLVEMENTS | BATCHEDUCATIONALHISTORYUPDATEID |
BATCHEDUCATIONALHISTORYUPDATEUNAFFILIATEDADDITIONALINFORMATION | BATCHEDUCATIONALHISTORYUPDATEID |
Entity-Relationship diagram of this table (EDUCATIONALPROGRAMCODE-STATE)