Module Rules

User

Rule IDRule DescriptionNotes
import_col_not_nullImport ID column must not be empty
email_col_not_nullEmail Address column must not be empty
is_client_not_nullClient ID column must not be empty
is_valid_emailEmail Address must be in valid formatCan contain letters (a-z), numbers (0-9), and periods (.). Cannot contain an ampersand (&), equals sign (=), underscore (_), apostrophe ('), dash (-), comma (,), brackets (<,>), or more than one period (.). Can begin or end with non-alphanumeric characters, but not periods.
valid_birth_date_formatBirth date must be in "yyyy-mm-dd" format
valid_originating_ts_formatOriginating Source Timestamp must be in "yyyy-mm-dd hh:mi:ss" formatDuplicate user records are not allowedVerifies the combination of values under the scv_user_id and email_address fields.
unique_scv_user_emailDuplicate user records are not allowedVerifies if there are duplicate entries considering a compound value consisting of scv_user_id and email_address

Contact Preferences

Rule IDRule DescriptionNotes
option_modified_at_formatOption Modified At must respect the following format "yyyy-mm-dd"
key_col_not_nullPreference Key must not be empty
modified_at_col_not_nullOption Modified At must not be empty

Custom Data Field

Rule IDRule DescriptionNotes
import_col_not_nullImport ID must not be empty
email_col_not_nullEmail Address column must not be empty
is_client_not_nullClient ID column must not be empty

Ticket

Rule IDRule DescriptionNotes
product_name_col_not_nulllProduct Name column must not be empty
product_id_col_not_nullProduct ID column must not be empty

Retail

Rule IDRule DescriptionNotes
product_description_col_not_nullProduct Description column must not be empty
product_id_col_not_nulProduct ID column must not be empty
transaction_date_col_not_nullTransaction Date column must not be empty
transaction_id_col_not_nullTransaction ID column must not be empty

Digital Usage

Rule IDRule DescriptionNotes
content_id_col_not_nullContent ID column must not be empty
content_name_col_not_nullContent Name column must not be empty
first_usage_at_col_not_nullFirst Usage At column must not be empty

Strucured Event

Rule IDRule DescriptionNotes
usage_at_col_not_nullUsage At column must not be empty
category_col_not_nullCategory column must not be empty
action_col_not_nullAction column must not be empty
label_col_not_nullLabel column must not be empty