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
| Rule | Field | Severity | What it enforces (the message your team sees) |
|---|---|---|---|
| first_name_required | FirstName | error | FirstName is required. |
| last_name_required | LastName | error | LastName is required. |
| first_name_format | FirstName | error | FirstName must be 1-40 characters: letters, accented chars, spaces, hyphens, apostrophes. |
| last_name_format | LastName | error | LastName must be 1-80 characters: letters, accented chars, spaces, hyphens, apostrophes. |
| email_required | error | Email is required for contacts. | |
| email_format | error | Email must be a valid format (e.g. user@company.com). | |
| phone_format | Phone | warning | Phone should be 7-20 digits with optional +, spaces, hyphens, parens. |
| mobile_format | MobilePhone | warning | MobilePhone should be 7-20 digits. |
| mailing_street_required | MailingStreet | warning | MailingStreet is recommended for contacts. |
| mailing_city_required | MailingCity | warning | MailingCity is recommended. |
| mailing_state_format | MailingState | warning | MailingState should be a valid state/province name or abbreviation. |
| mailing_zip_format | MailingPostalCode | warning | MailingPostalCode should be a valid postal/zip code. |
| mailing_country_not_empty | MailingCountry | warning | MailingCountry is recommended. |
| birthdate_format | Birthdate | error | Birthdate must be a valid date (YYYY-MM-DD). |
| title_length | Title | warning | Title should be under 128 characters. |
| department_length | Department | warning | Department should be under 80 characters. |
| account_name_not_empty | AccountName | warning | AccountName is recommended — orphan contacts are hard to manage. |
| duplicate_check | error | Duplicate 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 →