DEVICE_PREBUILT_FACT
This section describes the various device pre-installation facts that the producer can use in reports. The Device Prebuilt Fact table contains information about device pre-installed licenses. Records are written to this table when a PREBUILT_LICENSE_GENERATED event occurs.
|
Column |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Device Prebuilt 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. LICENSE_MODEL_ID can be null. |
|
START_DATE_ID |
numeric |
19 |
A 19-digit unique identifier of the pre-installed license’s Start Date. START_DATE_ID is a foreign key to the TIME_DIMENSION table. |
|
EXPIRATION_DATE_ID |
numeric |
19 |
A 19-digit unique identifier of the pre-installed license’s Expiration Date. EXPIRATION_DATE_ID is a foreign key to the TIME_DIMENSION table. |
|
FULFILL_DATE_ID |
numeric |
19 |
A 19-digit unique identifier of the pre-installed license’s Fulfillment Date. The fulfillment date is the date the license was generated. FULFILL_DATE_ID is a foreign key to the TIME_DIMENSION table. |
|
EVENT_ID |
numeric |
19 |
A 19-digit unique identifier for a device event. |
|
LASTMODIFIED_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the pre-installed license’s Last Modified Date. |