EntitlementRecommendationState Table

EntitlementRecommendationState is a static table listing all of the states a entitlement recommendation or transaction can be in.

Table 1. Database columns for EntitlementRecommendationState table

Database Column


Entitlement RecommendationStateID

Type: integer. Key. Generated ID

A unique identifier for each EntitlementRecommendationState. Possible values and the corresponding default strings are:

  • 1 = Automatically recommended
  • 2 = Manually created
  • 3 = Edited by an operator
  • 4 = Accepted by an operator or automatically
  • 5 = Rolled back by an operator
  • 6 = Deferred by an operator
  • 7 = Failed to be accepted.

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing the entitlement recommendation’s state. Foreign key to the ComplianceResourceString table.


Type: text (max 256 characters)

The text to display if the state resource string has no translation.