ENTITLEMENT_FACT
The following entitlement related facts are available in the reporting model.
|
Columns |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Entitlement Fact record as defined in FlexNet Operations. |
|
ORDERED_PROD_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier for the entitlement’s ordered product ID. |
|
ACTIVATABLE_PROD_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier for the entitlement’s activatable product ID. ACTIVATABLE_PROD_ID is a foreign key to the PRODUCT_DIMENSION table. |
|
LICENSE_MODEL_ID |
numeric |
19 |
A 19-digit unique identifier for the entitlement’s License Model Dimension record. LICENSE_MODEL_ID is a foreign key to the LICENSE_MODEL_DIMENSION table. LICENSE_MODEL_ID can be null. |
|
SKU_ID |
numeric |
19 |
A 19-digit unique identifier for the entitlement’s Part Number Dimension record. SKU_ID can be null. SKU_ID is a foreign key to the PART_NUMBER_DIMENSION table. |
|
LINE_ITEM_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier for the entitlement’s line item ID. LINE_ITEM_ID is a foreign key to the LINE_ITEM_DIMENSION table. |
|
STATE_ID |
numeric |
19 |
A 19-digit unique identifier of the entitlement’s current state. |
|
ACTION_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the entitlement’s Support Action Dimension record. ACTION_ID is a foreign key to the SUPPORT_ACTION_DIMENSION table. |
|
ORG_ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the entitlement’s Organization Unit Dimension record. ORG_ID identifies the sold-to account for the entitlement. ORG_ID is a foreign key to the ORG_UNIT_DIMENSION table. Note:ORG_ID refers to the organization’s account ID in FlexNet Operations. |
|
RESELLER_ID |
numeric |
19 |
A unique ID for the reseller. This column is populated when an entitlement line item is created from a web register key and values identify the organization unit (account) of the parent bulk entitlement of the web register key. Reseller ID can be null. |
|
PARENT_PRODUCT_ID |
numeric |
19 |
A 19-digit unique identifier of the entitlement’s parent product. |
|
CREATE_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the entitlement’s creation date. CREATE_DATE_ID is a foreign key to the TIME_DIMENSION table. |
|
LASTMODIFIED_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the entitlement’s Last Modified Date. |
|
ORDERED_SEAT_COUNT |
numeric |
19 |
Net copies available for the line item. This includes all new, upgrade, upsell and renew orders, and excludes all upgraded, upsold, renewed, obsolete, and inactive orders for a line item. |
|
EXTENDED_SEAT_COUNT |
numeric |
19 |
Count of the activated products. This count includes the number of copies of a given product purchased on its own as well as those copies included in a suite. |
|
MAINTENANCELINEITEM_ID |
numeric |
19 |
A 19-digit unique identifier for the maintenance ID record. MAINTENANCELINEITEM_ID is a foreign key element to the MAINTENANCE_LI_DIMENSION table. |