SIMPLEDATALISTCATALOG (4.0SP20)

ID

uniqueidentifier

TRANSLATIONFUNCTIONCATALOGID

uniqueidentifier

true

FK to TRANSLATIONFUNCTIONCATALOG

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT

NAME

nvarchar(60)

false

The unique name of this simple datalist

DESCRIPTION

nvarchar(1000)

false

Description of this simple datalist

IMPLEMENTATIONTYPE

tinyint

false

0 - SP datalist, 1 - CLR datalist

IMPLEMENTATIONTYPENAME

varchar(3) (Computed)

false

Provides the translation for the IMPLEMENTATIONTYPE column

PROCEDURENAME

nvarchar(128)

false

The name of the stored procedure used to return the datalist

ASSEMBLYNAME

nvarchar(128)

false

The name of the CLR assembly used to implement the simple datalist

CLASSNAME

nvarchar(128)

false

The name of the class in the CLR assemby used to implement the simple datalist

PARAMETERDEFXML

xml

true

Contains the parameter definition xml

STATICPARAMETERDEFINITION

xml

true

Contains the static parameter definition xml

SIMPLEDATALISTSPECXML

xml

false

Contains the spec xml used to create this simple datalist

DATEADDED

datetime

false

Indicates the date this record was added

DATECHANGED

datetime

false

Indicates the date this record was last changed

TS

timestamp

false

Timestamp

TSLONG

bigint (Computed)

true

Numeric representation of the timestamp

SPECUINAME

nvarchar(60)

false

Presentation name of the simple data list used to override the simple data list name for display in the application.

UINAME

nvarchar(60) (Computed)

false

Name of the simple data list for display in the application.

IX_SIMPLEDATALISTCATALOG_DATEADDED

False

False

True

PK_SIMPLEDATALISTCATALOG

True

True

False

UC_SIMPLEDATALISTCATALOG_NAME

True

False

False

UIX_SIMPLEDATALISTCATALOG_UINAME

True

False

False

TR_SIMPLEDATALISTCATALOG_AUDIT_UPDATE

TR_SIMPLEDATALISTCATALOG_AUDIT_DELETE