# ContactCleanInfo: Contact Clean Info - Name: `ContactCleanInfo` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Contact Clean Info ## Table Columns The columns of the table `ContactCleanInfo` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `City` | `string` | City | ☐ | | | `CleanedByJob` | `boolean` | Cleaned by Job | ☐ | | | `CleanedByUser` | `boolean` | Cleaned by User | ☐ | | | `ContactId` | `string` | Contact ID | ☐ | | | `ContactStatusDataDotCom` | `string` | Contact Status Data.com | ☐ | | | `Country` | `string` | Country | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `DataDotComId` | `string` | Data.com ID | ☐ | | | `Email` | `string` | Email | ☐ | | | `FirstName` | `string` | First Name | ☐ | | | `GeocodeAccuracy` | `string` | Geocode Accuracy | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsDifferentCity` | `boolean` | Is Different City | ☐ | | | `IsDifferentCountry` | `boolean` | Is Different Country | ☐ | | | `IsDifferentCountryCode` | `boolean` | Is Different Country Code | ☐ | | | `IsDifferentEmail` | `boolean` | Is Different Email | ☐ | | | `IsDifferentFirstName` | `boolean` | Is Different First Name | ☐ | | | `IsDifferentLastName` | `boolean` | Is Different Last Name | ☐ | | | `IsDifferentPhone` | `boolean` | Is Different Phone | ☐ | | | `IsDifferentPostalCode` | `boolean` | Is Different Postal Code | ☐ | | | `IsDifferentState` | `boolean` | Is Different State | ☐ | | | `IsDifferentStateCode` | `boolean` | Is Different State Code | ☐ | | | `IsDifferentStreet` | `boolean` | Is Different Street | ☐ | | | `IsDifferentTitle` | `boolean` | Is Different Title | ☐ | | | `IsFlaggedWrongAddress` | `boolean` | Is Flagged Wrong Address | ☐ | | | `IsFlaggedWrongEmail` | `boolean` | Is Flagged Wrong Email | ☐ | | | `IsFlaggedWrongName` | `boolean` | Is Flagged Wrong Name | ☐ | | | `IsFlaggedWrongPhone` | `boolean` | Is Flagged Wrong Phone | ☐ | | | `IsFlaggedWrongTitle` | `boolean` | Is Flagged Wrong Title | ☐ | | | `IsInactive` | `boolean` | Is Inactive | ☐ | | | `IsReviewedAddress` | `boolean` | Is Reviewed Address | ☐ | | | `IsReviewedEmail` | `boolean` | Is Reviewed Email | ☐ | | | `IsReviewedName` | `boolean` | Is Reviewed Name | ☐ | | | `IsReviewedPhone` | `boolean` | Is Reviewed Phone | ☐ | | | `IsReviewedTitle` | `boolean` | Is Reviewed Title | ☐ | | | `LastMatchedDate` | `datetime` | Last Matched Date | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastName` | `string` | Last Name | ☐ | | | `LastStatusChangedById` | `string` | Last Status Changed by ID | ☐ | | | `LastStatusChangedDate` | `datetime` | Last Status Changed Date | ☐ | | | `Latitude` | `double` | Latitude | ☐ | | | `Longitude` | `double` | Longitude | ☐ | | | `Name` | `string` | Name | ☐ | | | `Phone` | `string` | Phone | ☐ | | | `PostalCode` | `string` | Postal Code | ☐ | | | `State` | `string` | State | ☐ | | | `Street` | `string` | Street | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Title` | `string` | Title | ☐ | |