SoftwareLicenseUseRightProposal Table

The SoftwareLicenseUseRightProposal table is used to store a summary of use right changes to a particular software license. The changes have been inferred from changes to the license definition used to create the software license.

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

Database Column

Details

SoftwareLicenseUse RightProposalID

Type: integer. Key. Generated ID

Primary key for the SoftwareLicenseUseRightProposal table.

SoftwareLicenseID

Type: integer. Key

Foreign key to the SoftwareLicense table.

SoftwareLicense DefinitionID

Type: integer. Key

Foreign key to the SoftwareLicenseDefinition table.

LicenseDefinitionVersion

Type: integer

The version of the license definition that has been used for these proposed changes.

SoftwareLicenseUse RightNameID

Type: integer. Key

The proposed use right being changed on the software license.

SoftwareTitleProductID

Type: integer. Key. Nullable

Foreign key to the SoftwareTitleProduct table.

Enabled

Type: boolean. Key. Nullable

Is this use right being enabled?

MD5Value

Type: text (max 32 characters). Key. Nullable

The MD5 of Value in Hex.

Value

Type: text (max 4000 characters). Nullable

The proposed value for this use right.

OldValue

Type: text (max 4000 characters). Nullable

The existing value for this use right.

RelatedID

Type: integer. Nullable

The database ID of the proposed object associated with this use right.

OldRelatedID

Type: integer. Nullable

The database ID of the old object associated with this use right.

SoftwareLicense ProposalStatusID

Type: integer

The state of this software license change proposal.

Conflicted

Type: boolean

Whether this license type change proposal conflicts with another type proposed for the same license.

ContractInherited

Type: boolean

Whether this license type change proposal is for a use right currently inherited from contract by the license.

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 updated the record.

UpdatedDate

Type: datetime. Nullable

The date the record was updated.