CAREERLEVELCODE

Stores translations of career levels

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_CAREERLEVELCODE_DATEADDED DATEADDED yes
PK_CAREERLEVELCODE ID yes yes
UIX_CAREERLEVELCODE_DESCRIPTION DESCRIPTION yes

Triggers

Trigger Name Description
TR_CAREERLEVELCODE_AUDIT_UPDATE
TR_CAREERLEVELCODE_AUDIT_DELETE
TR_CAREERLEVELCODE_INSERT_BBNCCODETABLEIDMAP
TR_CAREERLEVELCODE_DELETE_BBNCCODETABLEIDMAP

Referenced by

Referenced by Field
BATCHAUCTIONITEMCONSTITUENTRELATION CAREERLEVELCODEID
BATCHCONSTITUENT PRIMARYBUSINESS_CAREERLEVELCODEID
BATCHREVENUECONSTITUENTRELATION CAREERLEVELCODEID
BATCHSPONSORSHIPCONSTITUENTRELATION CAREERLEVELCODEID
MATCHINGGIFTCONDITIONRELATIONSHIP CAREERLEVELCODEID
RELATIONSHIPJOBINFO CAREERLEVELCODEID