Compliance Data Rules in Tide enable specific Data-set fields to be set as mandatory, where specific rule conditions have been met. These Data Validation rules are then applied during Transformation. 

All Users can view Compliance Data Rules, but only Tide System Admin Users can create and edit them. Compliance Data Rules can be accessed by selecting Rules from the top menu. Compliance Data Rules are presented in the grid within the Rules tab of this screen.

To create a new Compliance Data Rule, System Admin can select to Add Rule and select Compliance Data from the button drop down. The sections below explain the different fields within Compliance Data Rules.

Rule Name

The name of the Compliance Data Rule. This should be a clear and concise name that indicates what rule is being validated.

Error Message

This is the error message that will appear on the error screen if the Compliance Data Rule is breached. 

Is this Rule Active?

You can use this field to deactivate a Rule that no longer applies, but the Rule will still be displayed.

Data-set

Select whether this Rule will apply to Risks (Risk Bordereaux), Premium (Premiums Bordereaux), or Claims (Claims Bordereaux) fields. This selection will change the available fields when creating Rule Conditions.

Class of Business

One or many Classes of Business can be selected that this rule applies to. If a Bordereau is being Transformed using a Schema (associated through the Bordereau Questionnaire being used), which is related to one of the Classes of Business of the Compliance Data Rule, then the rule is applied.

Processing Action

If No Action is selected, then the rule is not validated during processing. However, the rule could be used in reporting following processing.

If Mandatory  is selected, then an error raised must be resolved before the record can be Approved‍ and published. 

If Warning is selected, then an error can be ignored, and the record still Approved‍ and published. Tide will still record that the Warning error was ignored.

Rule Conditions

If required, you can then enter one or many conditions that must be met for the rule to be assessed. For example, the rule may only be applicable if a Risk is located in a specific Risk Country. 

Select Add Rule Condition to add one. For non-System Admin Users, you will see the Rule Condition written out in the Rule Condition column of the rules grid.

To create Rule Conditions, first select an Operator that determines the function that is applied to the field. The options are:

• Between
• Not Between
• Equal To
• Not Equal To
• Greater Than
• Less Than
• Greater Than or Equal To
• Less Than or Equal To
• Contains 
• Is Blank

You can then apply the Operator to a field or value, e.g. if you select Greater Than, you may want to apply this to a field, such as Net Premium, or a value, such as 500,000. Depending on your selection, you will be able to enter a value or select another Data-set field. If you select Between or Not Between, then you will be able to enter two values or select two Data-set fields.

On subsequent Rule Conditions you create you will first select the Method. You can select either OR or AND. This determines whether the both Rule Conditions will need to be met (AND), or whether either Rule Condition will need to be met (OR). You can enter as many Rule Conditions as required, with the appropriate Methods.

Select Data-set Fields

You can the select which fields will be subject to the mandatory field validation, if the Rule Condition(s) are met. To do so, select the field from the Available Data-set Fields grid, then select the right arrow to move to the Selected Fields grid. To remove fields, select from the Selected Fields grid, then select the left arrow to move to the Available Data-set Fields grid.