Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(60)   The unique name of this simple datalist
 DESCRIPTION nvarchar(1000)   Default = '' Description of this simple 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 simple datalist
 CLASSNAME nvarchar(128)   Default = '' The name of the class in the CLR assemby used to implement the simple datalist
 PARAMETERDEFXML xml Contains the parameter definition xml
 STATICPARAMETERDEFINITION xml Contains the static parameter definition xml
 SIMPLEDATALISTSPECXML xml   Contains the spec xml used to create this simple datalist
 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 simple data list used to override the simple 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 simple data list for display in the application.

Foreign Key Field Type Null Notes Description
 TRANSLATIONFUNCTIONCATALOGID uniqueidentifier TRANSLATIONFUNCTIONCATALOG.ID FK to TRANSLATIONFUNCTIONCATALOG
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_SIMPLEDATALISTCATALOG_DATEADDED DATEADDED    
 PK_SIMPLEDATALISTCATALOG ID  
 UC_SIMPLEDATALISTCATALOG_NAME NAME    
 UIX_SIMPLEDATALISTCATALOG_UINAME UINAME    

Trigger Name Description
 TR_SIMPLEDATALISTCATALOG_AUDIT_UPDATE
 TR_SIMPLEDATALISTCATALOG_AUDIT_DELETE

Entity-Relationship diagram of this table