License_Position_FACT Table
License_Position_FACT
is a fact table storing license positions by operator.
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 |
---|---|
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. |