Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 PROCEDURENAME nvarchar(128)   Default = '' The name of the procedure used to perform the record operation
 DISPLAYNAME nvarchar(60)   The unique name of this record operation
 RECORDOPERATIONSPECXML xml   The xml of the record operation spec
 EXCEPTIONSXML xml Contains the expected db exceptions xml
 DESCRIPTION nvarchar(1000)   Default = '' Description of this record operation
 IMPLEMENTATIONTYPE tinyint   Default = 0 0 - SP data form, 1 - CLR data form
 IMPLEMENTATIONTYPENAME varchar(3) (Computed)   Provides the translation for the IMPLEMENTATIONTYPE column
 ASSEMBLYNAME nvarchar(128)   Default = '' The name of the CLR assembly used to implement the data form template
 CLASSNAME nvarchar(128)   Default = '' The name of the class in the CLR assemby used to implement the data form template
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml for the clr implementation
 OPERATIONTYPE tinyint   Default = 0 0 - Delete, 1 - Update
 OPERATIONTYPENAME varchar(6) (Computed)   Provides the translation for the OPERATIONTYPE column
 TIMEOUTSECONDS int   Default = 0 The maximum number of seconds for the client to wait for a response to this request
 SECURITYUIFOLDER nvarchar(255)   Default = ''
 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
 SPECUINAME nvarchar(60)   Default = '' Presentation name of the record operation used to override the record operation name for display in the application.
 UINAME nvarchar(60) (Computed)   case when len(SPECUINAME) = 0 then DISPLAYNAME else SPECUINAME end Name of the record operation for display in the application.

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

Index Name Field(s) Unique Primary Clustered
 IX_RECORDOPERATIONCATALOG_DATEADDED DATEADDED    
 PK_RECORDOPERATIONCATALOG ID  
 UC_RECORDOPERATIONCATALOG_DISPLAYNAME DISPLAYNAME    
 UIX_RECORDOPERATIONCATALOG_UINAME UINAME    

Trigger Name Description
 TR_RECORDOPERATIONCATALOG_AUDIT_UPDATE
 TR_RECORDOPERATIONCATALOG_AUDIT_DELETE

Referenced by Field
 BATCHTEMPLATE ROWRECORDOPERATIONID
 BATCHTYPECATALOG ROWRECORDOPERATIONID
 BATCHTYPECATALOG BATCHDELETERECORDOPERATIONID
 RECORDOPERATIONWORKFLOWTRIGGER RECORDOPERATIONID
 SYSTEMROLEPERM_RECORDOPERATION RECORDOPERATIONCATALOGID

Entity-Relationship diagram of this table