ComplianceActionHistoryResource Table

ComplianceActionHistoryResource table stores string resources required by the ComplianceActionHistory table.

Table 1. Database columns for ComplianceActionHistoryResource table

Database Column

Details

ComplianceAction HistoryResourceID

Type: integer. Key. Generated ID

Unique identifier for each record. Possible values and the corresponding default strings that may be written into a history list are:

  • 1 = Payment made
  • 2 = Payment edited
  • 3 = Payment cancelled
  • 4 = Activated application usage tracking for contract
  • 5 = Deactivated application usage tracking for contract
  • 6 = Activated application usage tracking for software license
  • 7 = Deactivated application usage tracking for software license
  • 8 = Modified application usage tracking for software license
  • 9 = Modified application usage tracking for contract
  • 10 = Not defined
  • 11 = Obligated to pay: (amount)
  • 12 = Actual amount was set to: (amount)
  • 13 = Actual amount currency rate was set to: (rate)
  • 14 = Estimated amount was set to: (amount)
  • 15 = Estimated amount currency rate was set to: (rate)
  • 16 = Budgeted amount was set to: (amount)
  • 17 = Budgeted amount currency rate was set to: (amount)
  • 18 = Payment status was set to: (status)
  • 19 = Payment amount: (amount); Payment date: (date)
  • 20 = Payment date was set to: (date)
  • 21 = Software license: (license name)
  • 22 = Software title: (application name)
  • 23 = Contract: (contract name)
  • 24 = Tracked: (yes/no); Track group: (group); Track start date: (date); Track end date: (date)
  • 25 = Applications tracked: (number).
ResourceName

Type: text (max 256 characters). Key

The name of the resource that determines the text to display on the user interface.

DefaultValue

Type: text (max 512 characters)

The default value to display if there is no resource string available to define the history action.