EntitlementRecommendation Table

EntitlementRecommendation is a table listing all of the recommendations that have been made to link entitlements to licenses.

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

Database Column

Details

Entitlement RecommendationID

Type: integer. Key. Generated ID

A unique identifier for this recommendation.

SoftwareLicenseID

Type: integer. Key. Nullable

The license affected by this recommendation, null if a new license is being created. Foreign key to the SoftwareLicense table.

SoftwareLicense DefinitionID

Type: integer. Key. Nullable

The license defintion of the new license being created. Foreign key to the SoftwareLicenseDefinition table.

SoftwareLicenseDefinition

Type: text. Nullable

Encrypted XML definition of the customised license being created if any.

MaintenanceDefinition

Type: text. Nullable

Encrypted XML definition of the maintenance being applied to the license associated with this recommendation.

ContractID

Type: integer. Key. Nullable

The contract affected by this recommendation, if any. Foreign key to the Contract table.

MaintenanceContractID

Type: integer. Nullable

The contract providing maintenance for this recommendation, if any. Foreign key to the Contract table.

ProcessActionID

Type: integer. Key. Nullable

The action that is recommended by this recommendation. Foreign key to the ProcessAction table.

Entitlement RecommendationStateID

Type: integer. Nullable

The state that the recommendation is in. Foreign key to the EntitlementRecommendationState table.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.

UpdatedUser

Type: text (max 128 characters). Nullable

The operator who last updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was last updated.

DoTransferSoftware LicenseAllocations

Type: boolean. Nullable

Indicates whether to transfer Group Assignments and Allocations when performing an upgrade and all the entitlements are transferred to the new license.