Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the parameter set.
 DESCRIPTION nvarchar(255)   Default = '' The description of the parameter set.
 WORDTEMPLATEFILENAME nvarchar(255)   Default = '' Filename of the word template to use for this letter.
 WORDFILE varbinary The actual template file to use for this letter.
 CREATEOUTPUTIDSET bit   Default = 0 Designates whether or not an ID set should be created as a result of the acknowledgement process.
 OUTPUTIDSETNAME nvarchar(100)   Default = '' The name of the output ID set to be created by the acknowledgement process.
 OVERWRITEOUTPUTIDSET bit   Default = 0 Designates whether or not to overwrite the output ID set if one with the same name already exists.
 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.
 CUSTOMPARAMETERDATAFORMITEM xml Custom parameters for this process.

Foreign Key Field Type Null Notes Description
 BUSINESSPROCESSVIEWID uniqueidentifier   BUSINESSPROCESSVIEW.ID A foreign key to the view to use as output for the parameter set.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_STEWARDSHIPPACKAGEPROCESS_DATEADDED DATEADDED    
 IX_STEWARDSHIPPACKAGEPROCESS_DATECHANGED DATECHANGED      
 PK_STEWARDSHIPPACKAGEPROCESS ID  
 UC_STEWARDSHIPPACKAGEPROCESS_NAME NAME    

Trigger Name Description
 TR_STEWARDSHIPPACKAGEPROCESS_AUDIT_UPDATE
 TR_STEWARDSHIPPACKAGEPROCESS_AUDIT_DELETE
 TR_STEWARDSHIPPACKAGEPROCESS_INSERT
 TR_STEWARDSHIPPACKAGEPROCESS_DELETE_BUSINESSPROCESSINSTANCE

Referenced by Field
 DESIGNATIONLEVEL STEWARDSHIPPACKAGEPROCESSID
 STEWARDSHIPPACKAGEPROCESSEXPORTFORMAT PARAMETERSETID
 STEWARDSHIPPACKAGEPROCESSSTATUS PARAMETERSETID

Entity-Relationship diagram of this table