User
user_gbl_ods__v
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 |
|
user_type__v |
varchar(765) |
Type of User |
user_ods__v.user_type__v |
null |
