SoftwareTitleData Table

This table stores each of the software titles known to FNMP. This maps directly to the External Software Title Dimension. This is not a slowly changing dimension, but a snapshot of current and deleted software titles. If title properties change from one snapshot to the next, the information in this table will be updated.

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 SoftwareTitleData table

Database Column

Details

SoftwareTitleID

Type: integer. Key

Unique identifier for this software title from the FNMP database.

SoftwareTitleName

Type: text (max 512 characters)

The name of this software title.

PublisherName

Type: text (max 200 characters)

The publisher of this software title.

ProductName

Type: text (max 1024 characters)

The product represented by this software title.

VersionName

Type: text (max 50 characters)

The version of this software title.

VersionWeight

Type: decimal. Nullable

A numeric value used to sort various versions of a software title.

EditionName

Type: text (max 50 characters)

The edition of this software title.

EditionWeight

Type: decimal. Nullable

A numeric value used to sort various editions of a software title.

Classification

Type: text (max 50 characters)

The classification of this software title.

ClassificationID

Type: integer. Nullable

The ID of the classification of this software title.

Action

Type: text (max 50 characters)

The action of this software title.

ActionID

Type: integer

The ID of the action of this software title.

IsLicensed

Type: boolean

1 if the SoftwareTitle is linked to any license

OperatorManageStateID

Type: integer

The management responsibility for this software title. Part of the unique key for a software title in the FNMP database.