Salesforce: Contact Daily History

Description

• Each record is a daily record in a contact, starting with its first active date and updating up toward either the current date (if still active) or its last active date.

Supported Data Sources

• Salesforce

Columns

Type	Name	Description
STRING	contact_day_id	Surrogate key hashed on date_day and contact_id
DATE	date_day	Date on which the opportunity had these field values.
STRING	contact_id	The unique, system-generated ID assigned during creation.
DATETIME	_fivetran_start	The time when the record was first created or modified in the source, based on a timestamp value in the source table that monotonically increases over time with data change or update.
DATETIME	_fivetran_end	The time until which the record was active minus epsilon, where epsilon is the smallest time difference that can be stored in the timestamp type value.
DATE	_fivetran_date
STRING	history_unique_key	Surrogate key hashed on _fivetran_start and contact_id.
BOOLEAN	_fivetran_active	true if it is the currently active record. false if it is a historical version of the record. Only one version of the record can be true.
DATETIME	_fivetran_synced	The time at which fivetran last synced this record.
STRING	account_id	ID of the account that’s the parent of this contact.
STRING	email	The contact’s email address.
STRING	first_name	The contact’s first name up to 40 characters.
BOOLEAN	is_deleted	Indicates whether the object has been moved to the Recycle Bin (true) or not (false). Label is Deleted.
DATETIME	last_activity_date	Value is the most recent of either: Due date of the most recent event logged against the record. Due date of the most recently closed task associated with the record.
STRING	last_modified_by_id	Last Modified By ID
DATETIME	last_modified_date	Last Modified Date
STRING	last_name	Required. Last name of the contact up to 80 characters.
INTEGER	last_referenced_date	The timestamp when the current user last accessed this record, a record related to this record, or a list view.
DATETIME	last_viewed_date	The timestamp when the current user last viewed this record or list view. If this value is null, the user might have only accessed this record or list view (LastReferencedDate) but not viewed it.
STRING	mailing_city	City mailing address details.
STRING	mailing_country	Country mailing address details.
STRING	mailing_country_code
INTEGER	mailing_postal_code	Postal code mailing address details.
STRING	mailing_state	State mailing address details.
STRING	mailing_street	Street mailing address details.
INTEGER	master_record_id	If this record was deleted as the result of a merge, this field contains the ID of the record that remains. If this record was deleted for any other reason, or has not been deleted, the value is null. This is a relationship field.
INTEGER	mobile_phone	Contact’s mobile phone number.
STRING	name
STRING	owner_id	The ID of the owner of the account associated with this contact. This is a relationship field.
STRING	phone	Telephone number for the contact. Label is Business Phone.
INTEGER	reports_to_id	This field doesn’t appear if IsPersonAccount is true. This is a relationship field.
STRING	title	Title
STRING	lead_source	The lead’s source.
STRING	description
INTEGER	individual_id	ID of the data privacy record associated with this contact. This field is available if Data Protection and Privacy is enabled. This is a relationship field.
INTEGER	home_phone	The contact’s home telephone number.
INTEGER	row_num