EDUCATIONALDEPARTMENTCODE

Educational department for an unaffiliated educational history record.

Primary Key

Primary Key Field Type
ID uniqueidentifier

Fields

Field Field Type Null Notes Description
DESCRIPTION nvarchar(100) Stores the description of the table entry
ACTIVE bit Default = 1 Indicates whether or not the table entry is active
SEQUENCE int Default = 0 Stores the user-defined sequence for the table entry
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 Keys

Foreign Key Field Type Null Notes Description
ADDEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.
CHANGEDBYID uniqueidentifier CHANGEAGENT.ID FK to CHANGEAGENT.

Indexes

Index Name Fields Unique Primary Clustered
IX_EDUCATIONALDEPARTMENTCODE_DATEADDED DATEADDED yes
PK_EDUCATIONALDEPARTMENTCODE ID yes yes
UIX_EDUCATIONALDEPARTMENTCODE_DESCRIPTION DESCRIPTION yes

Triggers

Trigger Name Description
TR_EDUCATIONALDEPARTMENTCODE_INSERT_BBNCCODETABLEIDMAP
TR_EDUCATIONALDEPARTMENTCODE_DELETE_BBNCCODETABLEIDMAP
TR_EDUCATIONALDEPARTMENTCODE_AUDIT_UPDATE
TR_EDUCATIONALDEPARTMENTCODE_AUDIT_DELETE

Referenced by

Referenced by Field
BATCHCONSTITUENTEDUCATIONADDITIONALINFORMATION EDUCATIONALDEPARTMENTCODEID
BATCHCONSTITUENTEDUCATIONALINVOLVEMENT EDUCATIONALDEPARTMENTCODEID
BATCHEDUCATIONALHISTORYUPDATEUNAFFILIATEDADDITIONALINFORMATION EDUCATIONALDEPARTMENTCODEID
EDUCATIONADDITIONALINFORMATION EDUCATIONALDEPARTMENTCODEID
EDUCATIONALDEPARTMENTCODEEXTENSION ID
EDUCATIONALINVOLVEMENT EDUCATIONALDEPARTMENTCODEID