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.