License_Position_FACT Table

License_Position_FACT is a fact table storing license positions by operator.

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

Database Column

Details

ComplianceOperatorID

Type: integer. Key

Foreign key to the operator.

SoftwareLicenseID

Type: integer. Key

Foreign key to the license.

Entitlements

Type: big integer

Total number of entitlements.

Consumption

Type: big integer

Number of entitlements consumed.

Installs

Type: big integer

Number of installations.

ComplianceStatusID

Type: integer

Compliance status ID of the license.

RiskCount

Type: big integer

Number of entitlements at risk (aka in breach).

OriginalCurrencyID

Type: integer

Currency ID of the OriginalCurrencyRiskAmount.

OriginalCurrencyUnitPrice

Type: decimal

Unit price in original currency.

OriginalCurrencyRisk Amount

Type: decimal

Value at risk in original currency.

SystemCurrencyID

Type: integer

Currency ID of the SystemCurrencyRiskAmount.

SystemCurrencyUnitPrice

Type: decimal

Unit price in system currency.

SystemCurrencyRiskAmount

Type: decimal

Value at risk in system currency.

RiskPercent

Type: decimal

Percentage at risk.

UtilizationPercent

Type: decimal. Nullable

Percentage utilization.

LicenseStatusID

Type: integer. Nullable

License status ID of the license.