Starter contract

salesforce_contact

18 rules · plain YAML · starts in observation mode

OpenDQV Cloud starter template (v0.1) — your tenant inherits this baseline. First customer edit creates v1.0 in your audit trail; pin by yaml_hash for replay. Salesforce Contact — data quality validation for CRM contact records

These are starting points you own. Every rule below ships in the trial, starts in observation mode, and is yours to read, edit, or delete from day one. Rules that reference a lookup list (lookup_file) validate against reference data you control in your tenant.
Rules as at 29 August 2026 — starting points you own, not a maintained regulatory feed. We correct errors in these samples; tracking regulatory change in your active contracts is yours.
RuleFieldSeverityWhat it enforces (the message your team sees)
first_name_requiredFirstNameerrorFirstName is required.
last_name_requiredLastNameerrorLastName is required.
first_name_formatFirstNameerrorFirstName must be 1-40 characters: letters, accented chars, spaces, hyphens, apostrophes.
last_name_formatLastNameerrorLastName must be 1-80 characters: letters, accented chars, spaces, hyphens, apostrophes.
email_requiredEmailerrorEmail is required for contacts.
email_formatEmailerrorEmail must be a valid format (e.g. user@company.com).
phone_formatPhonewarningPhone should be 7-20 digits with optional +, spaces, hyphens, parens.
mobile_formatMobilePhonewarningMobilePhone should be 7-20 digits.
mailing_street_requiredMailingStreetwarningMailingStreet is recommended for contacts.
mailing_city_requiredMailingCitywarningMailingCity is recommended.
mailing_state_formatMailingStatewarningMailingState should be a valid state/province name or abbreviation.
mailing_zip_formatMailingPostalCodewarningMailingPostalCode should be a valid postal/zip code.
mailing_country_not_emptyMailingCountrywarningMailingCountry is recommended.
birthdate_formatBirthdateerrorBirthdate must be a valid date (YYYY-MM-DD).
title_lengthTitlewarningTitle should be under 128 characters.
department_lengthDepartmentwarningDepartment should be under 80 characters.
account_name_not_emptyAccountNamewarningAccountName is recommended — orphan contacts are hard to manage.
duplicate_checkEmailerrorDuplicate Email detected within this batch — possible duplicate contact. Cross-system uniqueness against the Salesforce master register requires Salesforce duplicate management; OpenDQV validates the input batch only.

Run your own data against this contract in the free trial — drop a CSV in the dashboard, no code, no credit card. Start free trial →