ProcessAction Table

ProcessAction is a static table holding a collection of possible actions that can be applied while processing a SKU, with a special focus on processing software license upgrades.

Table 1. Database columns for ProcessAction table

Database Column

Details
ProcessActionID

Type: integer. Key. Generated ID

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

  • 1 = Link to existing license
  • 2 = Create new from SKU
  • 3 = Create new from PO line
  • 4 = Upgrade license: Link to existing license and upgrade from existing license
  • 5 = Upgrade license: Link to existing license and select upgrade from license
  • 6 = Upgrade license: Link to new license created from SKU and select upgrade from license
  • 7 = Remove from list
  • 8 = Upgrade license: Link to new license created from PO line and select upgrade from license
  • 9 = Create new from SKU with fixed maintenance
  • 10 = Create new from PO line with fixed maintenance
  • 11 = Create new from SKU with unlimited maintenance
  • 12 = Create new from PO line with unlimited maintenance
  • 13 = Create new from SKU with maintenance from contract
  • 14 = Create new from PO line with maintenance from contract
  • 15 = Apply contract maintenance to an existing license
  • 16 = Apply fixed maintenance to an existing license
  • 17 = Apply unlimited maintenance to an existing license
  • 18 = Apply contract maintenance to an existing license by SKU
  • 19 = Apply fixed maintenance to an existing license by SKU
  • 20 = Apply unlimited maintenance to an existing license by SKU
  • 21 = Apply contract maintenance to a non-existent license for SKU
  • 22 = Apply fixed maintenance to a non-existent license for SKU
  • 23 = Apply unlimited maintenance to a non-existent license for SKU
  • 24 = Upgrade license: Link to existing license and upgrade from existing license with contract maintenance
  • 25 = Upgrade license: Link to existing license and upgrade from existing license with fixed maintenance
  • 26 = Upgrade license: Link to existing license and upgrade from existing license with unlimited maintenance
  • 27 = Upgrade license: Link to existing license and select upgrade from license with contract maintenance
  • 28 = Upgrade license: Link to existing license and select upgrade from license with fixed maintenance
  • 29 = Upgrade license: Link to existing license and select upgrade from license with unlimited maintenance
  • 30 = Upgrade license: Link to new license created from SKU and select upgrade from license with contract maintenance
  • 31 = Upgrade license: Link to new license created from SKU and select upgrade from license with fixed maintenance
  • 32 = Upgrade license: Link to new license created from SKU and select upgrade from license with unlimited maintenance
  • 33 = Upgrade license: Link to new license created from PO line and select upgrade from license with contract maintenance
  • 34 = Upgrade license: Link to new license created from PO line and select upgrade from license with fixed maintenance
  • 35 = Upgrade license: Link to new license created from PO line and select upgrade from license with unlimited maintenance
  • 36 = Apply maintenance to a contract
  • 37 = No recommendation
  • 38 = Create a new license
  • 39 = Create a new license with a maintenance contract
  • 40 = Create a new license with fixed maintenance
  • 41 = Create a new license with unlimited maintenance
  • 42 = Add entitlements to a license
  • 43 = Add entitlements to a license with a maintenance contract
  • 44 = Add entitlements to a license with fixed maintenance
  • 45 = Add entitlements to a license with unlimited maintenance
  • 46 = Upgrade to a new license
  • 47 = Upgrade to a new license with a maintenance contract
  • 48 = Upgrade to a new license with fixed maintenance
  • 49 = Upgrade to a new license with unlimited maintenance
  • 50 = Upgrade to an existing license
  • 51 = Upgrade to an existing license with a maintenance contract
  • 52 = Upgrade to an existing license with fixed maintenance
  • 53 = Upgrade to an existing license with unlimited maintenance
  • 54 = Apply maintenance from a contract to an existing license
  • 55 = Apply fixed maintenance to an existing license
  • 56 = Apply unlimited maintenance to an existing license
ProcessActionResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an action. Foreign key to the ComplianceResourceString table.
ProcessActionDefaultValue

Type: text (max 256 characters)

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