SAPRule Table

FlexNet Manager Suite (Cloud)

This table stores SAP rules used for recommending optimizations for SAP.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SAPRule table

Database Column

Details

SAPRuleID

Type: integer. Key. Generated ID

A unique identifier for the SAP rule.

RuleName

Type: text (max 128 characters)

Name of the rule.

SAPRuleTypeID

Type: integer. Key

Foreign key to the rule type of the SAP rule.

SAPRuleSetID

Type: integer. Key

Foreign key to the rule set that the SAP rule belongs to.

RuleDefinition

Type: text

The rule definition XML used to build the rule statement used by the SAP rules engine.

SequenceNumber

Type: integer

The sequence number used to designate the order of the rules within the rule set.

SAPRuleCategoryID

Type: integer. Key

Foreign key to the rule category of the SAP rule.

IsActive

Type: boolean

Whether or not this rule is active for execution.

UseRuleSetMapping

Type: boolean

Whether or not to use mapping from the SAP rule set

CreationUser

Type: text (max 256 characters)

The user who created the system landscape.

CreationDate

Type: datetime

The data and time the system landscape was created.

UpdatedUser

Type: text (max 256 characters)

The last user who update the system landscape.

UpdatedDate

Type: datetime

The date and time the system landscape was last updated.

FlexNet Manager Suite (Cloud)

Current