Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BUSINESSPROCESSOUTPUTTABLEKEY nvarchar(50)   Default = '' The table key used to identify the business process output table.
 WORDTEMPLATEID uniqueidentifier The ID of the letter/label template in its source table.
 LETTERTEMPLATE varbinary The Word document associated with the letter that will be used by mail-related business processes to generate the mail merge output file.
 LETTERTEMPLATENAME nvarchar(255)   Default = '' The name of the Word document associated with the letter that will be used by mail-related business processes to generate the mail merge output file.
 LABELTEMPLATE varbinary The Word document associated with the label that will be used by mail-related business processes to generate the mail merge output file.
 LABELTEMPLATENAME nvarchar(255)   Default = '' The name of the Word document associated with the label that will be used by mail-related business processes to generate the mail merge output file.
 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.

Foreign Key Field Type Null Notes Description
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 BUSINESSPROCESSSTATUSID uniqueidentifier   BUSINESSPROCESSSTATUS.ID The business process status record that generated this output.

Index Name Field(s) Unique Primary Clustered
 IX_BUSINESSPROCESSOUTPUTTEMPLATE_DATEADDED DATEADDED    
 IX_BUSINESSPROCESSOUTPUTTEMPLATE_DATECHANGED DATECHANGED      
 PK_BUSINESSPROCESSOUTPUTTEMPLATE ID  
 UIX_BUSINESSPROCESSOUTPUTTEMPLATE_BUSINESSPROCESSSTATUSID_BUSINESSPROCESSOUTPUTTABLEKEY_WORDTEMPLATEID BUSINESSPROCESSSTATUSID, BUSINESSPROCESSOUTPUTTABLEKEY, WORDTEMPLATEID    

Trigger Name Description
 TR_BUSINESSPROCESSOUTPUTTEMPLATE_AUDIT_UPDATE
 TR_BUSINESSPROCESSOUTPUTTEMPLATE_AUDIT_DELETE

Entity-Relationship diagram of this table