Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   The unique name of this datalist
 DESCRIPTION nvarchar(1000)   Default = '' Description of this datalist
 IMPLEMENTATIONTYPE tinyint   Default = 0 0 - SP datalist, 1 - CLR datalist
 IMPLEMENTATIONTYPENAME varchar(3) (Computed)   Provides the translation for the IMPLEMENTATIONTYPE column
 PROCEDURENAME nvarchar(128)   Default = '' The name of the stored procedure used to return the datalist
 ASSEMBLYNAME nvarchar(128)   Default = '' The name of the CLR assembly used to implement the datalist
 CLASSNAME nvarchar(128)   Default = '' The name of the class in the CLR assemby used to implement the datalist
 CONTEXTPARAMETERNAME nvarchar(128)   Default = '' The name of the procedure parameter that contains the ID for the context record type
 PARAMETERDEFINITION xml Contains the parameter form definition xml
 RSSFEEDDEFINITION xml
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml
 OUTPUTDEFINITION xml   Contains the output definition xml
 DATALISTSPEC xml   Contains the spec xml used to create this datalist
 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
 TASKREMINDERDEFINITION xml
 SPECUINAME nvarchar(60)   Default = '' Presentation name of the data list used to override the data list name for display in the application.
 UINAME nvarchar(60) (Computed)   case when len(SPECUINAME) = 0 then NAME else SPECUINAME end Name of the data list for display in the application.
 MARTKEY nvarchar(255)

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_DATALISTCATALOG_DATEADDED DATEADDED    
 PK_DATALISTCATALOG ID  
 UC_DATALISTCATALOG_NAME NAME    
 UIX_DATALISTCATALOG_UINAME UINAME    

Trigger Name Description
 TR_DATALISTCATALOG_AUDIT_UPDATE
 TR_DATALISTCATALOG_AUDIT_DELETE

Referenced by Field
 ALERTTYPE DATALISTID
 CALENDARDATALISTCOLOR DATALISTID
 MKTEXPORTDEFINITION PREVIEWDATALISTCATALOGID
 SYSTEMROLEPERM_DATALIST DATALISTCATALOGID

Entity-Relationship diagram of this table