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


SoftwareTitleLicense ProposalID

Type: integer. Key. Generated ID

Primary key for the SoftwareTitleLicenseProposal table.


Type: integer. Key

Foreign key to the SoftwareTitle table.


Type: integer. Key. Nullable

Foreign key to the SoftwareTitleProduct table.


Type: integer. Nullable

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


Type: boolean

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


Type: integer. Key

Foreign key to the SoftwareLicense table.

SoftwareLicense DefinitionID

Type: integer. Key

Foreign key to the SoftwareLicenseDefinition table.


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.


Type: boolean

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


Type: text (max 128 characters). Nullable

The operator who created the record.


Type: datetime

The date the record was created.


Type: text (max 128 characters). Nullable

The operator who updated the record.


Type: datetime. Nullable

The date the record was updated.