User

Global user table that sourced from multiple connectors: CRM, Vault and Align. Fields are mapped into a conformed data model from all three sources. To prevent either source from pushing data to global ODS, set the mapping table value on the enabled: attribute to false.

Global ODS Field Field Type

Source Data

Connector: CRM

Table: user_ods__v

Source Data

Connector: Vault

Table: user_ods__sys

Source Data

Connector: Align

Table: roster_member_ods__aln

composite_key__v varchar(100)

|source_connector_name__v|souce_table_name__v|native_id__v|

|source_connector_name__v|souce_table_name__v|native_id__v|

|source_connector_name__v|souce_table_name__v|native_id__v|

source_system_id__v varchar(18)

Extracted from Internal Admin Console

Extracted from Internal Admin Console

Extracted from Internal Admin Console

native_id__v varchar(18) user_ods__v.crm_user_id__v

user_ods__sys.vault_user_id__v

roster_member_ods__aln.vault_roster_member_id__v

source_connector_

name__v

varchar(100)

Extracted from Internal Admin Console

Extracted from Internal Admin Console

Extracted from Internal Admin Console

source_table_name__v varchar(100) user_ods__v user_ods__sys roster_member_ods__aln
first_name__v varchar(120) user_ods__v.firstname__v

user_ods__sys.first_name

__sys

roster_member_ods__aln.first_name__aln

last_name__v varchar(240) user_ods__v.lastname__v

user_ods__sys.last_name__sys

roster_member_ods__aln.last_name__aln

city__v varchar(120) null null

roster_member_ods__aln.city__aln

country__v varchar(240) null null

roster_member_ods__aln.country__aln

isactive__v boolean user_ods__v.isactive__v null null
master_align_id__v varchar(108) null null

roster_member_ods__aln.master_align_id__aln

postal_code__v varchar(60) null null

roster_member_ods__aln.postal_code__aln

profile_name__v varchar(3900)

user_ods__v.profile_name_vod__v

user_ods__sys.security_profile__sys

roster_member_ods__aln.crm_profile_name__aln

external_id__v varchar(100) null null

roster_member_ods__aln.external_id__aln

address_line_1__v varchar(384) null null

roster_member_ods__aln.address_line_1__aln

full_name__v varchar(360)

user_ods__v.firstname__v user_ods__v.lastname__v

user_ods__sys.first_name__sys user_ods__sys.last_name__sys

roster_member_ods__aln.first_name__aln roster_member_ods__aln.last_name__aln

administrative_area__v varchar(765) user_ods__v.state__v null

roster_member_ods__aln.state__aln

status__v varchar(1280) null null

roster_member_ods__aln.status__v

email__v varchar(384) user_ods__v.email__v null

roster_member_ods__aln.email__aln

title__v varchar(240) user_ods__v.title__v null

roster_member_ods__aln.title__aln

alias__v varchar(24) user_ods__v.alias__v null

roster_member_ods__aln.alias__aln

roster_start_date__v date null null

roster_member_ods__aln.start_date__aln

roster_end_date__v date null null

roster_member_ods__aln.end_date__aln

start_date__v timestamp user_ods__v.start_date__v user_ods__sys.start_date__v

roster_member_ods__aln.start_date__v

end_date__v timestamp user_ods__v.end_date__v user_ods__sys.end_date__v

roster_member_ods__aln.end_date__v

last_modified_date__v timestamp user_ods__v.lastmodifieddate

user_ods__sys.modified_date__v

roster_member_ods__aln.modified_date__v