FULFILLMENT_DIMENSION

This dimension contains all fulfillment records and their details. All fulfillment records including obsolete fulfillment records are copied to the reporting database.

In addition to the columns documented here, the FULFILLMENT_DIMENSION table includes a column for each fulfillment-time custom attribute you load in to the reporting database. Columns for custom attributes can be added to this dimension in the administrative console. Click Configure Reporting Server > Add Custom Attributes.

The following attributes are available for each entity in this dimension and can be used in reports.

Fulfillment Dimension Columns

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 Fulfillment dimension.
FULFILLMENT_ID	string	255	A 255-character, non-nullable unique identifier of the fulfillment record as defined in FlexNet Operations.
STATUS	string	255	State of the fulfillment record: Active or Obsolete.
ACTIVATION_TYPE	string	64	Method of activation for trusted storage activations. The following choices are available: • SHORTCODE: Trusted storage fulfillment records generated using keyboard (short code) activation. • MANUAL: Trusted storage fulfillment records generated using manual (or offline activation) by using manually processing request and response XML files. • PROGRAMMATIC: Trusted storage fulfillment records generated using regular online activation from the client. • CERTIFICATE: Certificate licenses. • TRUSTED: Legacy trusted storage fulfillment records which do not have specific information about how they were activated. • EMBEDDED: Licenses generated using FlexNet Embedded for hardware devices. • CUSTOM: Fulfillment records that belong to any non-FlexNet licensing technology.
LIFECYCLE_STATUS	string	64	Indicates any support action on the fulfillment record. The following choices are available: • Master: A new fulfillment record • Returned: A fulfillment record that has been returned. • Rehosted: A fulfillment record that has been rehosted. • Repaired: A fulfillment record that has been repaired. • Reinstalled: A fulfillment record that has been reinstalled. • Emergency: A fulfillment record that was created as an emergency license. • Stop Gap: A fulfillment record that was created as a stop gap license. • Upgraded: A fulfillment record that was upgraded to another fulfillment record. • Upsold: A fulfillment record that was created was upsold to another fulfillment record. • Renewed: A fulfillment record that was created was renewed to another fulfillment record.
PLATFORM_TYPE	string	64	Indicates the platform on which a trusted storage license is activated. In FlexNet Operations 11.5.0.1 and FlexNet Publisher 11.5, the platform type is included in the trusted storage activation requests. This platform type is copied to the reporting database. The choices are: • i86_n3 (Windows) • i86_re3 (Linux) • Mac • Other types supported by FlexNet Publisher Licensing Toolkit
FULFILLMENT_SOURCE	string	255	Indicates the activation process used for fulfillment. Choices are • ONLINE: For fulfillment records generated using web services. • APPLICATION: For fulfillment records generated using FlexNet Operations user interface. • LEGACY: Used for legacy fulfillment records that do not have information about how the fulfillment records were generated.
HOST_ID	string	255	Host on which the license is activated. • For certificate licenses, HOST_ID is the usual host identifier (like INTERNET=64.0.0.1). • For trusted licenses, HOST_ID is UMN or Machine Identifier. • For non-FlexNet technologies, HOST_ID is the custom host identifier.