ImportedStringMapping Table
The ImportedStringMapping
table is used by the importer to keep a history of entities that have been imported from a data source that uses string IDs rather than integer IDs.
Note: To cater for multi-tenant mode, this table may contain data for
multiple tenants. Access requires that the database
TenantID
has been set in the SQL Server
connection context information. That setting filters an underlying table to produce this
view of data for the single, selected tenant.
Database Column |
Details |
---|---|
ComplianceConnectionID
|
Type: integer. Key The identifier of a data source connection in the |
Category
|
Type: text (max 100 characters). Key The importer category applicable for this ID space. |
OriginalID
|
Type: text (max 400 characters). Key The ID of this entity in the source database. |
MappedID
|
Type: big integer. Generated ID A unique integer value we can use as an ‘external ID’ safely in the |