Roster Member Territory

territory_roster_gbl__v

Roster member territory table from Align joined with Roster Member and Territory tables. Mappings are delivered disabled by default. If appropriate objects are brought into Nitro from Align, this mapping table can be enabled in the Align connector.

Global ODS Field	Field Type	Source Data Connector: Align Table: roster_member_territory_ods__aln
composite_key__v	varchar(125)	|source_connector_name__v|vault_roster_member_territory_id__v|start_date__v|
source_system_id__v	varchar(18)	Extracted from Internal Admin Console
native_id__v	varchar(100)	vault_roster_member_territory_id__v
source_connector_name__v	varchar(100)	Extracted from Internal Admin Console
source_table_name__v	varchar(100)	roster_member_territory_ods__aln
address_line_1__v	varchar(384)	roster_member_ods__aln.address_line_1__aln
full_name__v	varchar(360)	roster_member_ods__aln.first_name__aln roster_member_ods__aln.last_name__aln
state__v	varchar(765)	roster_member_ods__aln.state__aln
city__v	varchar(384)	roster_member_ods__aln.city__aln
status__v	varchar(1280)	roster_member_ods__aln.status__aln
email_id__v	varchar(384)	roster_member_ods__aln.email__aln
title__v	varchar(240)	roster_member_ods__aln.title__aln
roster_external_id__v	varchar(360)	external_id__aln
last_name__v	varchar(240)	roster_member_ods__aln.last_name__aln
first_name__v	varchar(120)	roster_member_ods__aln.first_name__aln
postal_code__v	varchar(60)	roster_member_ods__aln.postal_code__aln
territory_id__v	varchar(1000)	territory__aln
territory_name__v	varchar(384)	territory_ods__aln.territory_name__v
territory_description__v	varchar(3000)	territory_ods__aln.description__aln
hierarchy_level__v	varchar(1280)	territory_ods__aln.hierarchy_level__aln
roster_member_territory_external _id__v	varchar(360)	external_id__aln
start_date__v	timestamp	start_date__v
end_date__v	timestamp	end_date__v
last_modified_date__v	timestamp	modified_date__v
territory_start_date__v	date	start_date__aln
territory_end_date__v	date	end_date__aln