Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
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) | CONVERT(bigint, TS) | Numeric representation of the timestamp. | |
POSITION | nvarchar(256) | Default = '' | The position of the constituent in relation to the involvement. |
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 | 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 | EDUCATIONINVOLVEMENTAWARDCODE.ID | Indicates the award associated with the involvement. | |
EDUCATIONALINVOLVEMENTNAMEID | uniqueidentifier | EDUCATIONALINVOLVEMENTNAME.ID | Indicates the involvement record's name. | |
ACADEMICCATALOGPROGRAMID | uniqueidentifier | ACADEMICCATALOGPROGRAM.ID | A foreign key to the academic catalog program table. | |
ACADEMICCATALOGCOLLEGEID | uniqueidentifier | ACADEMICCATALOGCOLLEGE.ID | A foreign key to the academic catalog college table. | |
ACADEMICCATALOGDEPARTMENTID | uniqueidentifier | ACADEMICCATALOGDEPARTMENT.ID | A foreign key to the academic catalog department table. | |
EDUCATIONALDEPARTMENTCODEID | uniqueidentifier | EDUCATIONALDEPARTMENTCODE.ID | The unaffiliated educational department code. | |
EDUCATIONALPROGRAMCODEID | uniqueidentifier | EDUCATIONALPROGRAMCODE.ID | FK to EDUCATIONALPROGRAMCODE | |
EDUCATIONALCOLLEGECODEID | uniqueidentifier | EDUCATIONALCOLLEGECODE.ID | FK to EDUCATIONALCOLLEGECODE | |
ACADEMICCATALOGDIVISIONID | uniqueidentifier | ACADEMICCATALOGDIVISION.ID | A foreign key to the academic catalog division table. | |
ACADEMICCATALOGSUBDEPARTMENTID | uniqueidentifier | ACADEMICCATALOGSUBDEPARTMENT.ID | A foreign key to the academic catalog sub department table. | |
EDUCATIONALDIVISIONCODEID | uniqueidentifier | EDUCATIONALDIVISIONCODE.ID | FK to EDUCATIONALDIVISIONCODE | |
EDUCATIONALSUBDEPARTMENTCODEID | uniqueidentifier | EDUCATIONALSUBDEPARTMENTCODE.ID | FK to EDUCATIONALSUBDEPARTMENTCODE |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_EDUCATIONALINVOLVEMENT_CONSTITUENTID | CONSTITUENTID | |||
IX_EDUCATIONALINVOLVEMENT_DATEADDED | DATEADDED | |||
IX_EDUCATIONALINVOLVEMENT_DATECHANGED | DATECHANGED | |||
PK_EDUCATIONALINVOLVEMENT | ID |
Trigger Name | Description |
---|---|
TR_EDUCATIONALINVOLVEMENT_AUDIT_UPDATE | |
TR_EDUCATIONALINVOLVEMENT_AUDIT_DELETE |