Tableau Connector for Salesforce

Build 25.0.9434

ContactCleanInfo

Schema file for ContactCleanInfo.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String False

Name of the record.

CurrencyIsoCode String False

ISO code for the currency in which the revenue amount is expressed.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

ContactId String True

Contact.Id

ID of the Contact associated with this record.

LastMatchedDate Datetime True

Date associated with LastMatched.

LastStatusChangedDate Datetime True

Date associated with LastStatusChanged.

LastStatusChangedById String True

User.Id

ID of the LastStatusChangedBy associated with this record.

IsInactive Bool False

Indicates whether the record has the Inactive characteristic.

FirstName String True

First name of the contact or person account.

LastName String True

Last name of the contact or person account. Required for person accounts.

Email String True

Email address for the contact or person account.

Phone String True

Phone number for the contact or account.

Street String True

Street address.

City String True

City portion of the address.

State String True

State or province portion of the address.

PostalCode String True

Postal code portion of the address.

Country String True

Country portion of the address.

Latitude Double True

Used with Longitude to specify the precise geolocation of an address.

Longitude Double True

Used with Latitude to specify the precise geolocation of an address.

GeocodeAccuracy String True

Accuracy level of the geocode for the address.

Title String True

Title of the contact or person, for example CEO or Vice President.

ContactStatusDataDotCom String True

Field containing ContactStatusDataDotCom information.

IsReviewedName Bool False

Indicates whether the record has the ReviewedName characteristic.

IsReviewedEmail Bool False

Indicates whether the record has the ReviewedEmail characteristic.

IsReviewedPhone Bool False

Indicates whether the record has the ReviewedPhone characteristic.

IsReviewedAddress Bool False

Indicates whether the record has the ReviewedAddress characteristic.

IsReviewedTitle Bool False

Indicates whether the record has the ReviewedTitle characteristic.

IsDifferentFirstName Bool True

Indicates whether the record has the DifferentFirstName characteristic.

IsDifferentLastName Bool True

Indicates whether the record has the DifferentLastName characteristic.

IsDifferentEmail Bool True

Indicates whether the record has the DifferentEmail characteristic.

IsDifferentPhone Bool True

Indicates whether the record has the DifferentPhone characteristic.

IsDifferentStreet Bool True

Indicates whether the record has the DifferentStreet characteristic.

IsDifferentCity Bool True

Indicates whether the record has the DifferentCity characteristic.

IsDifferentState Bool True

Indicates whether the record has the DifferentState characteristic.

IsDifferentPostalCode Bool True

Indicates whether the record has the DifferentPostalCode characteristic.

IsDifferentCountry Bool True

Indicates whether the record has the DifferentCountry characteristic.

IsDifferentTitle Bool True

Indicates whether the record has the DifferentTitle characteristic.

IsDifferentStateCode Bool True

Indicates whether the record has the DifferentStateCode characteristic.

IsDifferentCountryCode Bool True

Indicates whether the record has the DifferentCountryCode characteristic.

CleanedByJob Bool True

Field containing CleanedByJob information.

CleanedByUser Bool True

Field containing CleanedByUser information.

IsFlaggedWrongName Bool False

Indicates whether the record has the FlaggedWrongName characteristic.

IsFlaggedWrongEmail Bool False

Indicates whether the record has the FlaggedWrongEmail characteristic.

IsFlaggedWrongPhone Bool False

Indicates whether the record has the FlaggedWrongPhone characteristic.

IsFlaggedWrongAddress Bool False

Indicates whether the record has the FlaggedWrongAddress characteristic.

IsFlaggedWrongTitle Bool False

Indicates whether the record has the FlaggedWrongTitle characteristic.

DataDotComId String True

ID of the DataDotCom associated with this record.

SOQL String False

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String False

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String False

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record was last modified.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434