SoftwareTitleLicenseProposal Table

The SoftwareTitleLicenseProposal table is used to store a summary of application 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 SoftwareTitleLicenseProposal table

Database Column

Details

SoftwareTitleLicense ProposalID

Type: integer. Key. Generated ID

Primary key for the SoftwareTitleLicenseProposal table.

SoftwareTitleID

Type: integer. Key

Foreign key to the SoftwareTitle table.

SoftwareTitleProductID

Type: integer. Key. Nullable

Foreign key to the SoftwareTitleProduct table.

OldPrimarySoftwareTitleID

Type: integer. Nullable

The existing primary application of the license. This can be null if there is no primary application.

Supplementary

Type: boolean

Whether this product will be added to this license as supplementary (counted for consumption) or not.

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.

SoftwareTitleLicense ProposalActionID

Type: integer. Key

The proposed action for the software title on the software license.

SoftwareLicense ProposalStatusID

Type: integer

The state of this software license change proposal.

Conflicted

Type: boolean

Whether this license title change proposal conflicts with another for the same 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.