Stores additional education information for a constituent batch.
Foreign Key Fields
Foreign Key |
Field Type |
Null |
Notes |
Description |
BATCHCONSTITUENTID
|
uniqueidentifier
|
false
|
|
A foreign key to the constituent batch table.
|
ACADEMICCATALOGCOLLEGEID
|
uniqueidentifier
|
true
|
|
A foreign key to the academic catalog college table.
|
ACADEMICCATALOGDEPARTMENTID
|
uniqueidentifier
|
true
|
|
A foreign key to the academic catalog department table.
|
ACADEMICCATALOGDEGREETYPEID
|
uniqueidentifier
|
true
|
|
A foreign key to the academic catalog degree type table.
|
EDUCATIONALCOLLEGECODEID
|
uniqueidentifier
|
true
|
|
The unaffiliated educational college code.
|
EDUCATIONALDEPARTMENTCODEID
|
uniqueidentifier
|
true
|
|
The unaffiliated educational department code.
|
EDUCATIONALDEGREETYPECODEID
|
uniqueidentifier
|
true
|
|
The unaffiliated educational degree type code.
|
ADDEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
CHANGEDBYID
|
uniqueidentifier
|
false
|
|
FK to CHANGEAGENT.
|
ACADEMICCATALOGDIVISIONID
|
uniqueidentifier
|
true
|
|
A foreign key to the academic catalog division table.
|
ACADEMICCATALOGSUBDEPARTMENTID
|
uniqueidentifier
|
true
|
|
A foreign key to the academic catalog sub department table.
|
EDUCATIONALDIVISIONCODEID
|
uniqueidentifier
|
true
|
|
The unaffiliated educational division code.
|
EDUCATIONALSUBDEPARTMENTCODEID
|
uniqueidentifier
|
true
|
|
The unaffiliated educational sub department code.
|