ContractUseRight Table
ContractUseRight
contains licensing rules most of which can be set by PURL.
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.
Database Column |
Details |
---|---|
ContractUseRightID
|
Type: integer. Key. Generated ID A unique identifier |
ContractID
|
Type: integer. Key A unique identifier for a contract. |
ReassignmentTimeLimit AppliesDevice
|
Type: boolean If 1 then the license cannot be reassigned for some period of time (example is Microsoft 90 day rule) |
ReassignmentTimeLimit AppliesUser
|
Type: boolean If 1 then the license cannot be reassigned for some period of time (example is Microsoft 90 day rule) |
ReassignmentTimeLimit Device
|
Type: integer. Nullable The period (in days) within which the license cannot be reassigned |
ReassignmentTimeLimitUser
|
Type: integer. Nullable The period (in days) within which the license cannot be reassigned |
LicenseMobilityApplies
|
Type: boolean 1 if eligible for bringing your own license to cloud environment |
NumberOfOSEPerLicense
|
Type: integer. Nullable Number of OSE per license |
NumberOfProcessorsPerOSE
|
Type: integer. Nullable Number of processors per OSE |
TotalNumberOfCoresPerV MPerLicense
|
Type: integer. Nullable Total number of cores per VM per license |
NumberOfCoresPerSocket
|
Type: integer. Nullable Number of cores per socket |
ThirdPartyAccessAllowed
|
Type: boolean Access to applications is allowed to third party users. This field is defaulted to |
AllowExternalRoamingUse
|
Type: boolean. Nullable Set this field to |
MeasurementDate
|
Type: datetime. Nullable The date of the license measurment. |
ConsumptionUnit
|
Type: text. Nullable Unit description to describe the consumption amount. |
TargetOperatingSystem TypeID
|
Type: integer Type of Operating Systems to target |
VirtualApplication AccessMaximumUsage PeriodDevice
|
Type: integer. Nullable This is a rule for virtual application access. This is used in conjunction with the AllowExternalRoamingUse. For Device licenses, a license will consume 1 entitlement per each user device when used in period specified here. |
VirtualApplication AccessMaximumUsage PeriodUser
|
Type: integer. Nullable This is a rule for virtual application access. This is used in conjunction with the AllowExternalRoamingUse. For user licenses, if 1, this license will consume only when used in period specified here. |
AlwaysInstalled
|
Type: boolean If this field is |
MinimumNumberOf LicensesPerVM
|
Type: integer When licensing a Virtual Hardware System with a |
AllowIBMPVUSubCapacity FromNonILMT
|
Type: boolean If the license does not use host processor information (not full capacity), set this field to |
NumberOfAllowed ProcessorsPerHost
|
Type: integer. Nullable This field specifies how many processors per host are allowed before an additional license entitlement (or point) is consumed. Null provides the default of 1. Zero provides unlimited. |
MinimumNumberOfProcessors
|
Type: integer The minimum number of processors that this license is for. This field is only used where the
|
LogicalProcessorsPer Server
|
Type: integer. Nullable Number of logical processors per server on Cloud Service Provider Instances |