Rule types

The Data Rules tab displays the Rule Type field and dynamic fields are displayed based on the value selected in the Rule Type field.

These are the available rule types based on which corresponding fields are displayed:

  • Table Column: If this value is selected, these fields are displayed:
    • Table: The target table for the rule type.
      Note: 
      • The list displays the target table defined on the Details tab and all source tables defined on the Table links tab.
      • The corresponding extension view (SC_V_EXT_<table>) is included for each Core table listed.
    • Column: The columns of the selected table or view.
      Note: The list displays the calculated res_xxx columns when an extension view is selected in the Table field.
  • Constant: If this value is selected, this field is displayed:
    • Value: A constant value used in the rule.
  • Expression: If this value is selected, these fields are displayed:
    • Expression: A valid query expression. The specified expression is validated for the target table and all linked tables. The validation is also performed for the corresponding extension view (SC_V_EXT_<table>).
    • Verify: The option to validate the rule and the expression. If you click the Verify option, a message is displayed, confirming whether the rule is valid.
  • Keyword: If this value is selected, this field displayed:
    • Keywords: The keyword used for the rule. Possible values:
      • Current Time
      • Current Date
      • Current Time UTC
      • Current Date UTC
  • Configuration Parameter: If this value is selected, this field displayed:
    • Parameter: List of all SCV configuration parameters defined in the SC_CONFIGURATION_PARAMETER table.
  • Application Default: If this value is selected, these fields are displayed:
    • Profile: List of all available SCV profiles.
    • Type: The SCV application default types for the rule. Possible values:
      • Class Property
      • Planning Engine Variable
      • SCV Table Column
      • Other
      Note: 
      • When Type is Class Property:
        • Class: List of distinct classes as defined in SCV Application defaults, or Global.
        • Property: List of distinct properties as defined in SCV Application defaults.
      • When Type is Planning Engine Variable:
        • Class: None.
        • Variable: List of distinct attributes as defined in SCV Application defaults.
      • When Type is SCV Table Column:
        • Table: List of SCV tables.
        • Column: List of columns available for the selected Table.
      • When Type is Other:
        • Attribute: List of distinct attributes as defined in SCV Application defaults.