AccountCleanInfo

Stores the metadata Data.com Clean uses to determine an account record’s clean status. AccountCleanInfo helps you automate the cleaning or related processing of account records. This object is removed in API version 67.0

Note

When your Data.com Prospector or Data.com Clean contract expires, Data.com features, objects, and fields will be removed from your org.

To support customers’ needs around compliance and to remain a leader in trust and privacy, Salesforce removed all contact data from the Data.com service on February 1, 2021.

For more information, see Data.com Prospector and Clean Retirement.

Account Clean Info provides a snapshot of the data in your Salesforce account record and its matched Data.com record at the time the Salesforce record was cleaned.

Account Clean Info includes a number of bit vector fields, whose component fields each correspond to individual object fields and provide related data or status information about those fields. For example, the bit vector field IsDifferent has an IsDifferentState field. If the IsDifferentState field’s value is False, that means the State field value is the same on the Salesforce account record and its matched Data.com record.

AccountCleanInfo bit vector fields include:

CleanedBy indicates who (a user) or what (a Clean job) cleaned the account record.
IsDifferent indicates whether or not a field on the account record has a value that differs from the corresponding field on the matched Data.com record.
IsFlaggedWrong indicates whether or not a field on the account record has a value that is flagged as wrong to Data.com.
IsReviewed indicates whether or not a field on the account record is in a Reviewed state, which means that the value was reviewed but not accepted.

Their individual bits are defined here.

Supported Calls

describeSObjects(), getDeleted(), getUpdated(), query(), retrieve(), update()

Fields

Field Name	Details
AccountId	Type reference Properties Filter, Group, Sort Description The unique, system-generated ID assigned when the account record was created.
AccountSite	Type string Properties Filter, Group, Nillable, Sort Description Information about the account’s location, such as single location, headquarters, or branch.
Address	Type address Properties Filter, Nillable Description The compound form of the address. Read-only. See Address Compound Fields for details on compound address fields.
AnnualRevenue	Type currency Properties Filter, Nillable, Sort Description Estimated annual revenue of the account.
City	Type string Properties Filter, Group, Nillable, Sort Description Details for the billing address of the account.
CleanedByJob	Type boolean Properties Filter Description Indicates whether the account record was cleaned by a Data.com Clean job (`true`) or not (`false`).
CleanedByUser	Type boolean Properties Filter Description Indicates whether the account record was cleaned by a Salesforce user (`true`) or not (`false`).
CompanyName	Type string Properties Filter, Group, Nillable, Sort Description The name of the company.
CompanyStatusDataDotCom	Type picklist Properties Filter, Group, Nillable, Sort Description The status of the company per Data.com. Values are: `Company is In Business per Data.com` or `Company is Out of Business per Data.com.`
Country	Type string Properties Filter, Group, Nillable, Sort Description Details for the billing address of the account.
DandBCompanyDunsNumber	Type string Properties Filter, Group, Nillable, Sort Description The D-U-N-S Number on the D&B Company record (if any) that is linked to the account.
DataDotComId	Type string Properties Filter, Group, Nillable, Sort Description The ID Data.com maintains for the company.
Description	Type textarea Properties Nillable Description A description of the account.
DunsNumber	Type string Properties Filter, Group, Nillable, Sort Description The Data Universal Numbering System (D-U-N-S) number is a unique, nine-digit number assigned to every business location in the Dun & Bradstreet database that has a unique, separate, and distinct operation. D-U-N-S numbers are used by industries and organizations around the world as a global standard for business identification and tracking.
DunsRightMatchConfidence	Type int Properties Filter, Group, Nillable, Sort Description The account’s DUNSRight confidence code.
DunsRightMatchGrade	Type string Properties Filter, Group, Nillable, Sort Description The account’s DUNSRight match grade.
Fax	Type phone Properties Filter, Group, Nillable, Sort Description The account’s fax number.
Industry	Type picklist Properties Filter, Group, Nillable, Sort Description The industry the account belongs to.
IsDifferentAccountSite	Type boolean Properties Filter Description Indicates whether the account’s AccountSite field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentAnnualRevenue	Type boolean Properties Filter Description Indicates whether the account’s AnnualRevenue field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentCity	Type boolean Properties Filter Description Indicates whether the account’s City field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentCompanyName	Type boolean Properties Filter Description Indicates whether the account’s AccountName field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentCountry	Type boolean Properties Filter Description Indicates whether the account’s Country field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentCountryCode	Type boolean Properties Filter Description Indicates whether the account’s Country Code field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentDandBCompanyDunsNumber	Type boolean Properties Filter Description Indicates whether the account’s DandBCompanyID field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentDescription	Type boolean Properties Filter Description Indicates whether the account’s Description field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentDunsNumber	Type boolean Properties Filter Description Indicates whether the account’s DunsNumber field value is different from the D-U-N-S Number on its matched Data.com record (`true`) or not (`false`).
IsDifferentFax	Type boolean Properties Filter Description Indicates whether the account’s Fax field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentIndustry	Type boolean Properties Filter Description Indicates whether the account’s Industry field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentNaicsCode	Type boolean Properties Filter Description Indicates whether the account’s NaicsCode field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentNaicsDescription	Type boolean Properties Filter Description Indicates whether the account’s NaicsDescription field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentNumberOfEmployees	Type boolean Properties Filter Description Indicates whether the account’s NumberOf Employees field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentOwnership	Type boolean Properties Filter Description Indicates whether the account’s Ownership field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentPhone	Type boolean Properties Filter Description Indicates whether the account’s Phone field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentPostalCode	Type boolean Properties Filter Description Indicates whether the account’s PostalCode field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentSic	Type boolean Properties Filter Description Indicates whether the account’s Sic field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentSicDescription	Type boolean Properties Filter Description Indicates whether the account’s SicDescription field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentState	Type boolean Properties Filter Description Indicates whether the account’s State field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentStateCode	Type boolean Properties Filter Description Indicates whether the account’s State Code field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentStreet	Type boolean Properties Filter Description Indicates whether the account’s State field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentTickerSymbol	Type boolean Properties Filter Description Indicates whether the account’s TickerSymbol field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentTradestyle	Type boolean Properties Filter Description Indicates whether the account’s Tradestyle field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentWebsite	Type boolean Properties Filter Description Indicates whether the account’s Website field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsDifferentYearStarted	Type boolean Properties Filter Description Indicates whether the account’s YearStarted field value is different from the corresponding value on its matched Data.com record (`true`) or not (`false`).
IsFlaggedWrongAccountSite	Type boolean Properties Filter, Update Description Indicates whether the account’s AccountSite field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongAddress	Type boolean Properties Filter, Update Description Indicates whether the account’s Address field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongAnnualRevenue	Type boolean Properties Filter, Update Description Indicates whether the account’s AnnualRevenue field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongCompanyName	Type boolean Properties Filter, Update Description Indicates whether the account’s CompanyName field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s Description field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongDunsNumber	Type boolean Properties Filter, Update Description Indicates whether the account’s DunsNumber field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongFax	Type boolean Properties Filter, Update Description Indicates whether the account’s Fax field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongIndustry	Type boolean Properties Filter, Update Description Indicates whether the account’s Industry field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongNaicsCode	Type boolean Properties Filter, Update Description Indicates whether the account’s NaicsCode field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongNaicsDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s NaicsDescription field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongNumberOfEmployees	Type boolean Properties Filter, Update Description Indicates whether the account’s NumberOfEmployees field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongOwnership	Type boolean Properties Filter, Update Description Indicates whether the account’s Ownership field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongPhone	Type boolean Properties Filter, Update Description Indicates whether the account’s Phone field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongSic	Type boolean Properties Filter, Update Description Indicates whether the account’s Sic field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongSicDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s SicDescription field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongTickerSymbol	Type boolean Properties Filter, Update Description Indicates whether the account’s TickerSymbol field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongTradestyle	Type boolean Properties Filter, Update Description Indicates whether the account’s Tradestyle field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongWebsite	Type boolean Properties Filter, Update Description Indicates whether the account’s Website field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsFlaggedWrongYearStarted	Type boolean Properties Filter, Update Description Indicates whether the account’s YearStarted field value is flagged as wrong to Data.com (`true`) or not (`false`).
IsInactive	Type boolean Properties Defaulted on create, Filter, Group, Sort Description Indicates whether the account has been reported to Data.com as `Inactive` (`true`) or not (`false`).
IsReviewedAccountSite	Type boolean Properties Filter, Update Description Indicates whether the account’s AccountSite field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedAddress	Type boolean Properties Filter, Update Description Indicates whether the account’s Address field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedAnnualRevenue	Type boolean Properties Filter, Update Description Indicates whether the account’s AnnualRevenue field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedCompanyName	Type boolean Properties Filter, Update Description Indicates whether the account’s CompanyName field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedDandBCompanyDunsNumber	Type boolean Properties Filter, Update Description Indicates whether the account’s DandBCompanyID field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s Description field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedDunsNumber	Type boolean Properties Filter, Update Description Indicates whether the account’s DunsNumber field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedFax	Type boolean Properties Filter, Update Description Indicates whether the account’s Fax field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedIndustry	Type boolean Properties Filter, Update Description Indicates whether the account’s Industry field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedNaicsCode	Type boolean Properties Filter, Update Description Indicates whether the account’s NaicsCode field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedNaicsDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s NaicsDescription field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedNumberOfEmployees	Type boolean Properties Filter, Update Description Indicates whether the account’s NumberOfEmployees field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedOwnership	Type boolean Properties Filter, Update Description Indicates whether the account’s Ownership field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedPhone	Type boolean Properties Filter, Update Description Indicates whether the account’s Phone field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedSic	Type boolean Properties Filter, Update Description Indicates whether the account’s Sic field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedSicDescription	Type boolean Properties Filter, Update Description Indicates whether the account’s SicDescription field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedTickerSymbol	Type boolean Properties Filter, Update Description Indicates whether the account’s TickerSymbol field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedTradestyle	Type boolean Properties Filter, Update Description Indicates whether the account’s Tradestyle field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedWebsite	Type boolean Properties Filter, Update Description Indicates whether the account’s Website field value is in a `Reviewed` state (`true`) or not (`false`).
IsReviewedYearStarted	Type boolean Properties Filter, Update Description Indicates whether the account’s YearStarted field value is in a `Reviewed` state (`true`) or not (`false`).
LastMatchedDate	Type dateTime Properties Filter, Sort Description The date the account record was last matched and linked to a Data.com record.
LastStatusChangedById	Type reference Properties Filter, Group, Nillable, Sort Description The ID of who or what last changed the record’s Clean Status field value: a Salesforce user or a Clean job.
LastStatusChangedDate	Type dateTime Properties Filter, Nillable, Sort Description The date on which the record’s Clean Status field value was last changed.
Latitude	Type double Properties Filter, Nillable, Sort Description Used with Longitude to specify the precise geolocation of a billing address. Data not currently provided.
Longitude	Type double Properties Filter, Nillable, Sort Description Used with Latitude to specify the precise geolocation of a billing address. Data not currently provided.
NaicsCode	Type string Properties Filter, Group, Nillable, Sort Description The six-digit North American Industry Classification System (NAICS) code is the standard used by business and government to classify business establishments into industries, according to their economic activity for the purpose of collecting, analyzing, and publishing statistical data related to the U.S. business economy.
NaicsDescription	Type string Properties Filter, Group, Nillable, Sort Description A brief description of an organization’s line of business, based on its NAICS code.
Name	Type string Properties Filter, Group, Sort, Update Description Field label is Account Clean Info Name. The name of the account. Maximum size is 255 characters.
NumberOfEmployees	Type int Properties Filter, Group, Nillable, Sort Description The number of employees working at the account.
Ownership	Type picklist Properties Filter, Group, Nillable, Sort Description Ownership type for the account, for example Private, Public, or Subsidiary.
Phone	Type phone Properties Filter, Group, Nillable, Sort Description The phone number for the account.
PostalCode	Type string Properties Filter, Group, Nillable, Sort Description Details for the billing address of the account.
Sic	Type string Properties Filter, Group, Nillable, Sort Description Standard Industrial Classification code of the company’s main business categorization, for example, 57340 for Electronics.
SicDescription	Type string Properties Filter, Group, Nillable, Sort Description A brief description of an organization’s line of business, based on its SIC code.
State	Type string Properties Filter, Group, Nillable, Sort Description Details for the billing address of the account.
Street	Type textarea Properties Filter, Group, Nillable, Sort Description Details for the billing address of the account.
TickerSymbol	Type string Properties Filter, Group, Nillable, Sort Description The stock market symbol for the account.
Tradestyle	Type string Properties Filter, Group, Nillable, Sort Description A name, different from its legal name, that an organization can use for conducting business. Similar to “Doing business as” (DBA).
Website	Type url Properties Filter, Group, Nillable, Sort Description The website of the account.
YearStarted	Type string Properties Filter, Group, Nillable, Sort Description The year the company was established or the year when current ownership or management assumed control of the company.

Usage

Administrators can modify a limited set of AccountCleanInfo fields from the Account Clean Info page.

Developers can create triggers that read the Account Clean Info fields to help automate the cleaning or related processing of account records. For example, you might create a trigger that reads the Clean Status field on the Account object. If an account record’s Clean Status field value is Different but the record has no Billing Street value, the trigger could update the record’s status to Not Compared.

Create triggers that read AccountCleanInfo fields to help automate the cleaning or related processing of account records. For example:

Keep account records’ status InSync if the only difference from matched records is the Phone format (for example, (415) 353-8000 on the account record versus 415 353 8000 on the matched Data.com record).

trigger AccountPhoneTrigger on Account (before update) {

   for (Account account: Trigger.new) {
       Account oldAccount = Trigger.oldMap.get(account.ID);
       if (account.CleanStatus == 'Different') {
           List <AccountCleanInfo> cleanInfo = [Select Id, IsDifferentPhone, IsReviewedPhone, Phone from AccountCleanInfo where AccountId = :account.Id];
           if (cleanInfo.size() > 0 && cleanInfo[0].IsDifferentPhone && cleanInfo[0].Phone.StartsWith('+')) {
               // if Data.com phone number is marked Different but starts with ‘+’, ignore this
               // and set the status to “Reviewed”
               AccountCleanInfo cleanInfoToUpdate = new AccountCleanInfo();
               cleanInfoToUpdate.Id = cleanInfo[0].Id;
               cleanInfoToUpdate.IsReviewedPhone = true;
               update cleanInfoToUpdate;
               account.CleanStatus = 'Reviewed';
           }
       }
   }
}

Create a customized set of Industry field values for accounts. Use triggers to map values from fields on imported or cleaned records onto a standard set of values.
Read the CleanStatus field value on the Account object. If that value is Different, but a Salesforce record has no street address value, update the record’s status to Not Compared.

Associated Objects

This object has the following associated objects. If the API version isn’t specified, they’re available in the same API versions as this object. Otherwise, they’re available in the specified API version and later.

AccountCleanInfoChangeEvent (API version 62.0): Change events are available for the object.