Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 TEMPLATENAME nvarchar(60)   The unique name of this template
 DESCRIPTION nvarchar(1000)   Default = '' Description of this template
 MODE smallint   Default = ((0)) 0-View, 1-Edit, 2-Add
 MODENAME varchar(4) (Computed)   Provides the translation for the MODE column
 IMPLEMENTATIONTYPE tinyint   Default = 0 0 - SP data form, 1 - CLR data form
 IMPLEMENTATIONTYPENAME varchar(3) (Computed)   Provides the translation for the IMPLEMENTATIONTYPE column
 LOADPROCEDURE nvarchar(128)   Default = '' The name of the stored procedure used to load the data into the form definition
 SAVEPROCEDURE nvarchar(128)   Default = '' The name of the stored procedure used when saving the data
 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
 FORMDEFINITIONXML xml   Contains the form definition xml
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml
 EXCEPTIONSXML xml Contains the expected db exceptions xml
 TEMPLATESPECXML xml   Contains the spec that was used to create the data form template
 CONTEXTPARAMETERNAME nvarchar(128)   Default = '' Name of the parameter if the form requires a parent context id
 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
 HASTSLONG bit   Default = 0
 HASAPPUSERFORLOAD bit   Default = 0
 HASAPPUSERFORSAVE bit   Default = 0
 HASIDFORLOAD bit   Default = 0
 HASCHANGEAGENT bit   Default = 0
 NOSECURITYREQUIRED bit   Default = 0
 SPECUINAME nvarchar(60)   Default = '' Presentation name of the data form template used to override the data form template name for display in the application.
 UINAME nvarchar(60) (Computed)   case when len(SPECUINAME) = 0 then TEMPLATENAME else SPECUINAME end Name of the data form template for display in the application.
 MARTKEY nvarchar(255)

Foreign Key Field Type Null Notes Description
 RECORDTYPEID uniqueidentifier RECORDTYPE.ID FK to RECORDTYPE
 CONTEXTRECORDTYPEID uniqueidentifier RECORDTYPE.ID FK to RECORDTYPE if the form requires a parent context id, null if the form requires no context
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_DATAFORMTEMPLATECATALOG_DATEADDED DATEADDED    
 IX_DATAFORMTEMPLATECATALOG_ID_METADATA ID      
 IX_DATAFORMTEMPLATECATALOG_ID_NOSECURITYREQUIRED ID      
 IX_DATAFORMTEMPLATECATALOG_ID_TEMPLATESPECXML ID      
 PK_DATAFORMTEMPLATECATALOG ID  
 UC_DATAFORMTEMPLATECATALOG_TEMPLATENAME TEMPLATENAME    
 UIX_DATAFORMTEMPLATECATALOG_UINAME UINAME    

Trigger Name Description
 TR_DATAFORMTEMPLATECATALOG_AUDIT_UPDATE
 TR_DATAFORMTEMPLATECATALOG_AUDIT_DELETE

Referenced by Field
 BATCHTYPECATALOG ADDROWDATAFORMTEMPLATEID
 BATCHTYPECATALOG EDITROWDATAFORMTEMPLATEID
 BATCHTYPECATALOG COMMITROWADDDATAFORMTEMPLATEID
 BATCHTYPECATALOG COMMITROWEDITDATAFORMTEMPLATEID
 BATCHTYPECATALOG ROWCONTEXTVIEWDATAFORMTEMPLATEID
 BATCHTYPECATALOG ROWCONTEXTEDITDATAFORMTEMPLATEID
 BATCHTYPECATALOG ADDROWDATAFORMTEMPLATEIDNOEXTENSION
 BATCHTYPECATALOG EDITROWDATAFORMTEMPLATEIDNOEXTENSION
 BATCHTYPECATALOG COMMITROWADDDATAFORMTEMPLATEIDNOEXTENSION
 BATCHTYPECATALOG COMMITROWEDITDATAFORMTEMPLATEIDNOEXTENSION
 BATCHTYPEEXTENSIONCATALOG ADDDATAFORMTEMPLATEID
 BATCHTYPEEXTENSIONCATALOG EDITDATAFORMTEMPLATEID
 BATCHTYPEEXTENSIONCATALOG COMMITADDDATAFORMTEMPLATEID
 BATCHTYPEEXTENSIONCATALOG COMMITEDITDATAFORMTEMPLATEID
 DATAFORMINSTANCECATALOG DATAFORMTEMPLATECATALOGID
 EXPORTDEFINITION VIEWDATAFORMTEMPLATEID

Entity-Relationship diagram of this table