SAPRuleAlgorithm Table

This table stores the availble SAP rule algorithms used by SAP rules.

Table 1. Database columns for SAPRuleAlgorithm table

Database Column

Details

SAPRuleAlgorithmID

Type: integer. Key. Generated ID

A unique identifier for the SAP rule algorithm.

AlgorithmName

Type: text (max 100 characters). Key

A unique name for the SAP category.

SAPRuleCategoryID

Type: integer. Key

Foreign key to the rule category of the SAP rule algorithm.

TitleResourceName

Type: text (max 256 characters). Nullable

A localizable resource string representing an SAP rule algorithm. Foreign key to the ComplianceResourceString table.

TitleDefaultValue

Type: text (max 100 characters)

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

AlgorithmType

Type: text

Type associated with this algorithm

AlgorithmData

Type: text. Nullable

Data associated with this algorithm, such as a custom SQL query to run.