ImportedTechnopediaARLMappedProduct Table

The ImportedTechnopediaARLMappedProduct table contains the Technopedia software information retrieved from the source connection.

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.
Table 1. Database columns for ImportedTechnopediaARLMappedProduct table

Database Column

Details

ComplianceConnectionID

Type: integer. Key

The identifier for a data source connection in the ComplianceConnection table.

ExternalID

Type: big integer. Key

The identifier used in the source connection for a Release ID.

FlexeraID

Type: text (max 256 characters). Key

The identifier used in the source connection for a Flexera ID.

ProductID

Type: big integer. Key

The identifier used in the source connection for a Product ID.

Manufacturer

Type: text (max 2000 characters). Nullable

Manufacturer name.

ProductFamily

Type: text (max 2000 characters). Nullable

Brand/family in which the software product belongs to.

ProductName

Type: text (max 2000 characters). Nullable

The name of the software product.

Component

Type: text (max 2000 characters). Nullable

The component of the software product (if applicable).

Edition

Type: text (max 2000 characters). Nullable

Software product’s edition name.

VersionGroup

Type: text (max 2000 characters). Nullable

The name of version group (or market version) of the software product.

Version

Type: text (max 2000 characters). Nullable

Software patch’s name/number.

PatchLevel

Type: text (max 2000 characters). Nullable

Technopedia software patch’s level (Critical or Optional).

SubVersion

Type: text (max 2000 characters). Nullable

The notion that indicates the stage within the lifecycle of a product version from its initial inception to the final/end form and beyond.

IsMajorRelease

Type: boolean. Nullable

The field is set to True if the the Technopedia release is a major release.

ImportedDate

Type: datetime

Technopedia Release imported date.