PRODUCT_DIMENSION
The Product dimension represents the product or suite specified in the entitlement line item. Note that all non-draft products in the FlexNet Operations database are copied to the reporting database.
The following attributes are available for each entity in this dimension and can be used in reports.
|
Columns |
Type |
Length |
Description |
||||||
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the device record as defined in FlexNet Operations. The ID is the primary key for the Product dimension. |
||||||
|
NAME |
string |
128 |
Name of the product or suite as defined in FlexNet Operations. |
||||||
|
VERSION |
string |
64 |
Version of the product or suite as defined in FlexNet Operations. |
||||||
|
NAME_VERSION |
string |
192 |
A compound attribute obtained by concatenating the name and version. Name and version form the unique identifier for the product in the FlexNet Operations database. This dimension attribute can be used to obtain counts for a specific product entity. |
||||||
|
DESCRIPTION |
string |
2000 |
The optional description of the product, as defined in FlexNet Operations. |
||||||
|
TYPE |
string |
50 |
The type of the product, such as Product or Suite. TYPE cannot be null. |
||||||
|
START_DATE |
string |
64 |
The optional start date of this product. Date format is YYYY-MM-DD HH:MM:SS. |
||||||
|
END_DATE |
string |
64 |
The optional end date of this product. Date format is YYYY-MM-DD HH:MM:SS. |
||||||
|
LICENSE_TECHNOLOGY_ID |
numeric |
19 |
The numeric ID of the license technology. |
||||||
|
PACKAGE_NAME |
string |
64 |
The optional unique name of the package. If specified, PACKAGE_VERSION is also required to be set. |
||||||
|
PACKAGE_VERSION |
string |
64 |
The optional numeric version format. Required if PACKAGE_NAME is specified. |
||||||
|
USED_ON_DEVICE |
numeric |
2 |
Optional field specifying if the product can be used on the device.
|
||||||
|
USAGE_MODEL_ID |
string |
64 |
Available when the USED_ON_DEVICE is set to Yes. |
||||||
|
PRODUCT_LINE |
string |
64 |
Optional product line to map to the product. |
||||||
|
PRODUCT_STATUS |
string |
64 |
Status of the product |