MAPENTITYCATALOG (4.0SP17)

ID

uniqueidentifier

FROMRECORDTYPEID

uniqueidentifier

false

The ID of the record type to map from

MAPPEDRECORDTYPEID

uniqueidentifier

false

The ID of the record type that will appear on the map

ADDRESSRECORDTYPEID

uniqueidentifier

true

The record type ID for the address

SEARCHLISTID

uniqueidentifier

false

The searchlist to be used when adding an instance to the map.

ADDDATAFORMINSTANCEID

uniqueidentifier

true

The add form to be used when saving an instance of the map.

ADDEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

CHANGEDBYID

uniqueidentifier

false

FK to CHANGEAGENT.

NAVIGATIONPAGEID

uniqueidentifier

true

NAME

nvarchar(100)

false

Unique name of the map entity.

DESCRIPTION

nvarchar(max)

false

Describes the map entity.

RETURNSMULTIPLE

bit

false

Whether the map entity will return multiple address

IDISSELECTIONID

bit

false

Whether or not the ID is a selection ID

MAPPINGPROCEDURE

nvarchar(255)

false

The SQL stored procedure which takes an ID of the FROMRECORDTYPE and selects a list of the GEOCODE values

IMAGEKEY

nvarchar(512)

false

Image key that represents FROMRECORDTYPE.

MAPENTITYXML

xml

false

SECURITYUIFOLDER

nvarchar(255)

false

The folder path where the merge task catalog item will be displayed when presented in a UI tree view.

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(100)

false

Presentation name of the map entity used to override the map entity name for display in the application.

UINAME

nvarchar(100) (Computed)

false

Name of the map entity for display in the application.

IX_MAPENTITYCATALOG_DATEADDED

False

False

True

IX_MAPENTITYCATALOG_DATECHANGED

False

False

False

PK_MAPENTITYCATALOG

True

True

False

UC_MAPENTITYCATALOG_NAME

True

False

False

TR_MAPENTITYCATALOG_AUDIT_UPDATE

TR_MAPENTITYCATALOG_AUDIT_DELETE

SYSTEMROLEPERM_MAPENTITY

MAPENTITYCATALOGID