DEVICE_ADDON_FACT

This section describes the various device product facts that the producer can use in reports. The Device Add-on Fact table contains information about device products. A record is written to this table when an event causes a change in the requested count or consumed count of a device’s product.

Note:When a device is mapped to a contact, only contact specific fields are populated and user specific fields are omitted. If a device is mapped to a user, both user and contact fields will be populated.

Device Add-on Facts

Column

Type

Length

Description

ID

numeric

19

A 19-digit (non-nullable) unique identifier of the Device Add-on Fact record as defined in FlexNet Operations.

DEVICE_ID

numeric

19

A 19-digit (non-nullable) unique identifier of the Device Dimension record as defined in FlexNet Operations.

ORDERED_PROD_ID

numeric

19

A 19-digit (non-nullable) unique identifier for the device’s ordered product ID.

ACTIVATABLE_PROD_ID

numeric

19

A 19-digit (non-nullable) unique identifier for the device’s activatable product ID. ACTIVATABLE_PROD_ID is a foreign key to the product record in the PRODUCT_DIMENSION table.

LICENSE_MODEL_ID

numeric

19

A 19-digit unique identifier for the device’s License Model Dimension record. LICENSE_MODEL_ID is a foreign key to the LICENSE_MODEL_DIMENSION table, and it can be null.

SKU_ID

numeric

19

A 19-digit unique identifier for the device’s Part Number Dimension record. SKU_ID is a foreign key to the PART_NUMBER_DIMENSION table. SKU_ID can be null.

ORG_ID

numeric

19

A 19-digit (non-nullable) unique identifier of the device’s Organization Unit Dimension record. 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.

USER_ID

numeric

19

If the device is mapped to a user and the Device user option is set to On with validation, this is a 19-digit unique identifier for the user ID specified in FlexNet Operations for this user (the identifier the user uses to log in). USER_ID is a foreign key to the USER_DIMENSION table.

If the device is mapped to a contact or the Device user option is set to Off (default setting) or On without validation or the user is inactive, this column will be null.

See “Configuring FlexNet Operations” in the Producer Portal Help Guide for more information on configuring the Device user option.

LINE_ITEM_ID

numeric

19

A 19-digit (non-nullable) unique identifier for the product’s line item ID. LINE_ITEM_ID is a foreign key to the line item record in the LINE_ITEM_DIMENSION table.

EVENT_DATE_ID

numeric

19

A 19-digit unique identifier for a device event date. EVENT_DATE_ID is a foreign key to the TIME_DIMENSION table.

EVENT_ID

numeric

19

A 19-digit unique identifier for a device event.

EVENT_TYPE

string

64

A device event type. EVENT_TYPE is the event type name for the event ID number in EVENT_ID. EVENT_TYPE may be one of the following values:

ACTIVATABLE_ITEM_ADDED

ACTIVATABLE_ITEM_REMOVED

ACTIVATABLE_ITEM_INCREASED

ACTIVATABLE_ITEM_DECREASED

ACTIVATABLE_ITEM_MARK_REMOVED

CAPABILITY_RESPONSE_SENT

CAPABILITY_RESPONSE_GENERATED

REQUESTED_COUNT_DELTA

numeric

19

The change to a device product’s requested count as the result of event identified by the EVENT_ID value. The value is the difference between the current requested count and the old requested count.

EXTENDED_REQUESTED_COUNT

numeric

19

A count of a product or suite included in the line item request. For each product and suite, this value is calculated by multiplying the REQUESTED_COUNT_DELTA value by the counts of the product or suite in the line item. Example:

• Line Item L1 contains 2 copies of product PA and 3 copies of suite SA.
• Suite SA contains 2 copies of product PB, 3 copies of product PC, and 1 copy of product PD.
• A request for 2 counts for L1 occurs.

The REQUESTED_COUNT_DELTA is 2. Five rows are written to the Device Add-on Facts table (one for each product or suite). The EXTENDED_REQUESTED_COUNT value for product PA is 4, suite SA is 6, product PB is 12, product PC is 18, and product PD is 6.

CONSUMED_COUNT_DELTA

numeric

19

The change to a device’s consumed count as the result of event identified by the EVENT_ID value, like CAPABILITY_RESPONSE_SENT or CAPABILITY_RESPONSE_GENERATED. The value is the difference between the current consumed count and the old consumed count.

EXTENDED_CONSUMED_COUNT

numeric

19

A count of a product or suite consumed as part of a line item request. The consumed count is recorded for products for which a license has been generated. For each product and suite, this value is calculated by multiplying the CONSUMED_COUNT_DELTA value by the counts of the product or suite in the line item. This count is calculated similar to the EXTENDED_REQUESTED_COUNT,

LASTMODIFIED_DATE_ID

numeric

19

A 19-digit unique identifier for the device product’s Last Modified Date.

CONTACT_ID

numeric

19

If the Device user option is set to On with validation, a 19-digit unique identifier for a contact. CONTACT_ID is a foreign key to the CONTACT_DIMENSION table.

If the Device user option is set to On without validation or Off, this column will be null.