STEWARDSHIPSTEPCATEGORYCODE

Stores the stewardship plan step categories.

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_STEWARDSHIPSTEPCATEGORYCODE_DATEADDED DATEADDED yes
PK_STEWARDSHIPSTEPCATEGORYCODE ID yes yes
UIX_STEWARDSHIPSTEPCATEGORYCODE_DESCRIPTION DESCRIPTION yes

Triggers

Trigger Name Description
TR_STEWARDSHIPSTEPCATEGORYCODE_AUDIT_UPDATE
TR_STEWARDSHIPSTEPCATEGORYCODE_AUDIT_DELETE
TR_STEWARDSHIPSTEPCATEGORYCODE_INSERT_BBNCCODETABLEIDMAP
TR_STEWARDSHIPSTEPCATEGORYCODE_DELETE_BBNCCODETABLEIDMAP

Referenced by

Referenced by Field
BATCHSTEWARDSHIPPLANSTEPUPDATE CATEGORYCODEID
STEWARDSHIPPLANSTEP CATEGORYCODEID
STEWARDSHIPPLANTEMPLATESTEP CATEGORYCODEID