SoftwareLicenseData Table

This table stores each of the Software Licenses known to FNMP. This maps directly to the External Software License Dimension. This is not a slowly changing dimension, but a snapshot of current and deleted license information. If license 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 `SoftwareLicenseData` table
Database Column	Details
`SoftwareLicenseID`	Type: integer. Key Unique identifier for this license from the FNMP database.
`ProductName`	Type: text (max 1024 characters) Product name of the primary application of this license.
`PublisherName`	Type: text (max 64 characters). Nullable The name of the publisher
`LicenseName`	Type: text (max 256 characters) The name of this license.
`LicenseVersion`	Type: text (max 60 characters). Nullable The version of this license.
`LicenseEdition`	Type: text (max 60 characters). Nullable The edition of this license.
`LicenseTypeID`	Type: integer ID of the type of this license.
`LicenseType`	Type: text (max 256 characters) The type of this license.
`GrantsSecondUse`	Type: boolean Whether this license offers second use rights.
`GrantsDowngrade`	Type: boolean Whether this license offers downgrade rights.
`IsTrueUp`	Type: boolean Whether this license provides True Up functionality.
`UnlimitedConsumption`	Type: boolean Whether this license provides unlimited consumption.
`EstimatedUnitPrice`	Type: currency. Nullable Estimated Unit price for the license
`GrantsVirtualEnvironment`	Type: boolean Whether installs of this license on a virtual machine host covers installations on virtual machines hosted by that host.
`UseInSecondUseRights`	Type: boolean A Boolean field that states whether product use rights apply to this license type.
`NumberPurchased`	Type: integer The quantity of purchased license entitlements.
`LocationID`	Type: integer. Key The location which owns this license.
`CorporateUnitID`	Type: integer. Key The corporate unit which owns this license.
`CostCenterID`	Type: integer. Key The cost center which owns this license.
`CategoryID`	Type: integer. Key The category of this license.
`LicenseStatusID`	Type: integer ID of the status of this license
`LicenseStatus`	Type: text (max 256 characters) License Status of the license
`ComplianceStatusID`	Type: integer ID of the compliance status of this license
`ComplianceStatus`	Type: text (max 256 characters) Compliance Status of the license
`DurationID`	Type: integer ID of duration of this license
`Duration`	Type: text (max 256 characters) The name of the resource string containing the text to display on the user interface.
`ExpiryDate`	Type: datetime. Nullable The date this license expires. A NULL value means the license does not expire.