Roster Member Territory

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