DEVICE_FACT
This section describes the various device facts that the producer can use in reports. The Device Fact table contains information about changes to a device over time. Records are written to this table when devices are created, activated, or made obsolete.
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.
|
Column |
Type |
Length |
Description |
|
ID |
numeric |
19 |
A 19-digit (non-nullable) unique identifier of the Device 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. |
|
STATUS |
string |
64 |
The status of the device: Active or Obsolete. |
|
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. |
|
CREATE_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the device’s creation date. CREATE_DATE_ID is a foreign key to the TIME_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 for the event identified by the number in EVENT_ID. EVENT_TYPE can be one of the following values: DEVICE_CREATED DEVICE_STATE_ACTIVE DEVICE_STATE_OBSOLETE |
|
EVENT_DETAILS |
string |
2000 |
An optional description for the event. |
|
LASTMODIFIED_DATE_ID |
numeric |
19 |
A 19-digit unique identifier for the device’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. |