Working with your Squad tables

Following is the information that is synced: who’s on your Impact Squad, your Squad’s contact information, the status of your Impact Foundations activities, and records of your consent (for example, for Accelerators that require you to accept additional terms and conditions).

Table 1. Source and target tables that are synced

Source field	Source table	Target field	Target table
name	sn_impact_common_impact_contact	name	sn_impact_common_impact_contact
idi_role	sn_impact_common_impact_contact	idi_role	sn_impact_common_impact_contact
firstname	sn_impact_common_impact_contact	firstname	sn_impact_common_impact_contact
email	sn_impact_common_impact_contact	email	sn_impact_common_impact_contact
role	sn_impact_common_impact_contact	role	sn_impact_common_impact_contact
firstname	sn_impact_common_impact_contact	firstname	sn_impact_common_impact_contact
company	sn_impact_common_impact_contact	company	sn_impact_common_impact_contact
idi_role	sn_impact_common_impact_contact	idi_role	sn_impact_common_impact_contact
lastname	sn_impact_common_impact_contact	lastname	sn_impact_common_impact_contact
is_squad	sn_impact_common_impact_contact	is_squad	sn_impact_common_impact_contact
lastname	sn_impact_common_impact_contact	lastname	sn_impact_common_impact_contact
email	sn_impact_common_impact_contact	email	sn_impact_common_impact_contact
updated_by_user	sn_impact_common_customer_consent	updated_by_user	x_snc_cusp_play_customer_consent
sys_updated_by	sn_impact_common_customer_consent	sys_updated_by	x_snc_cusp_play_customer_consent
assignment_group	sn_impact_common_impact_activity	assignment_group	x_snc_cusp_activity_base
state	sn_impact_common_impact_activity	state	x_snc_cusp_activity_base
comments	sn_impact_common_impact_activity	comments	x_snc_cusp_activity_base
data_fields	sn_impact_common_impact_activity	data_fields	x_snc_cusp_activity_base
migration_status	sn_impact_cust_impact_data_migration_status	migration_status	sn_impact_squad_impact_data_migration_status
error_log	sn_impact_cust_impact_data_migration_status	error_log	sn_impact_squad_impact_data_migration_status
failed_records	sn_impact_cust_impact_data_migration_status	failed_records	sn_impact_squad_impact_data_migration_status
percentage_complete	sn_impact_cust_impact_data_migration_status	percentage_complete	sn_impact_squad_impact_data_migration_status
migration_timestamp	sn_impact_cust_impact_data_migration_status	migration_timestamp	sn_impact_squad_impact_data_migration_status
failed_sys_ids	sn_impact_cust_impact_data_migration_status	failed_sys_ids	sn_impact_squad_impact_data_migration_status
table	sn_impact_cust_impact_data_migration_status	table	sn_impact_squad_impact_data_migration_status
sys_created_on	sn_impact_cust_impact_data_migration_status	sys_created_on	sn_impact_squad_impact_data_migration_status
migration_number	sn_impact_cust_impact_data_migration_status	migration_number	sn_impact_squad_impact_data_migration_status
total_records_attempted	sn_impact_cust_impact_data_migration_status	total_records_attempted	sn_impact_squad_impact_data_migration_status
feature	sn_impact_cust_impact_data_migration_status	feature	sn_impact_squad_impact_data_migration_status
successful_records	sn_impact_cust_impact_data_migration_status	successful_records	sn_impact_squad_impact_data_migration_status
firstname	sn_impact_common_impact_contact	firstname	sn_impact_common_impact_contact
email	sn_impact_common_impact_contact	email	sn_impact_common_impact_contact
name	sn_impact_common_impact_contact	name	sn_impact_common_impact_contact
is_squad	sn_impact_common_impact_contact	is_squad	sn_impact_common_impact_contact
lastname	sn_impact_common_impact_contact	lastname	sn_impact_common_impact_contact
sys_created_on	sn_impact_common_customer_consent	sys_created_on	x_snc_cusp_play_customer_consent
sys_created_by	sn_impact_common_customer_consent	sys_created_by	x_snc_cusp_play_customer_consent
expiration_date	sn_impact_common_customer_consent	expiration_date	x_snc_cusp_play_customer_consent
consent_state	sn_impact_common_customer_consent	consent_state	x_snc_cusp_play_customer_consent
sys_mod_count	sn_impact_common_customer_consent	sys_mod_count	x_snc_cusp_play_customer_consent
sys_updated_by	sn_impact_common_customer_consent	sys_updated_by	x_snc_cusp_play_customer_consent
sys_updated_on	sn_impact_common_customer_consent	sys_updated_on	x_snc_cusp_play_customer_consent
active	sn_impact_common_subproduction_sync	active	sn_impact_common_subproduction_sync
date	sn_impact_common_subproduction_sync	date	sn_impact_common_subproduction_sync
cost	sn_impact_common_subproduction_sync	cost	sn_impact_common_subproduction_sync
state	sn_impact_common_subproduction_sync	state	sn_impact_common_subproduction_sync
category	sn_impact_common_subproduction_sync	category	sn_impact_common_subproduction_sync
description	sn_impact_common_subproduction_sync	description	sn_impact_common_subproduction_sync
attachment	sn_impact_common_subproduction_sync	attachment	sn_impact_common_subproduction_sync
name	sn_impact_common_subproduction_sync	name	sn_impact_common_subproduction_sync
standard_objective	sn_impact_cust_impact_objective	business_objective_reference	x_snc_octane_bvmp_business_objective_data
progress_state	sn_impact_cust_impact_objective	progress_state	x_snc_octane_bvmp_business_objective_data
sys_created_by	sn_impact_cust_impact_objective	sys_created_by	x_snc_octane_bvmp_business_objective_data
objective_color	sn_impact_cust_impact_objective	objective_color	x_snc_octane_bvmp_business_objective_data
objective_status	sn_impact_cust_impact_objective	overall_status	x_snc_octane_bvmp_business_objective_data
description	sn_impact_cust_impact_objective	description	x_snc_octane_bvmp_business_objective_data
is_custom	sn_impact_cust_impact_objective	user_defined	x_snc_octane_bvmp_business_objective_data
end_date	sn_impact_cust_impact_objective	targeted_completion_date	x_snc_octane_bvmp_business_objective_data
sys_updated_by	sn_impact_cust_impact_objective	sys_updated_by	x_snc_octane_bvmp_business_objective_data
start_date	sn_impact_cust_impact_objective	start_date	x_snc_octane_bvmp_business_objective_data
name	sn_impact_cust_impact_objective	title	x_snc_octane_bvmp_business_objective_data