Data Warehouse – Users

[av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’aviaTBcustom_margin\’ margin=\’0px\’ margin_sync=\’true\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ radius_sync=\’true\’ padding=\’0px\’ padding_sync=\’true\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ attachment=\’\’ attachment_size=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight_size=\’1.1\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-1vrra\’]

[av_heading heading=\’Users Fields\’ tag=\’h1\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’\’ icon_color=\’\’ margin=\’5px\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-1x6u23\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_heading heading=\’AppCan Data Warehouse\’ tag=\’h3\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’\’ icon_color=\’\’ margin=\’5px\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kmnn4umk\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_hr class=\’custom\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’10px\’ custom_margin_bottom=\’10px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-3fbm\’ admin_preview_bg=\’\’]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-ka00b6ed\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
The details below provide the field mappings.

Suggested link fields:

  • UserId

[/av_textblock]

[av_hr class=\’invisible\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’20\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’10px\’ custom_margin_bottom=\’10px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-3fbm\’ admin_preview_bg=\’\’]

[/av_one_full][av_one_full first min_height=\’\’ vertical_alignment=\’av-align-top\’ space=\’\’ row_boxshadow_color=\’\’ row_boxshadow_width=\’10\’ custom_margin=\’aviaTBcustom_margin\’ margin=\’0px,20px\’ mobile_breaking=\’\’ border=\’\’ border_color=\’\’ radius=\’0px\’ radius_sync=\’true\’ padding=\’0px\’ padding_sync=\’true\’ column_boxshadow_color=\’\’ column_boxshadow_width=\’10\’ background=\’bg_color\’ background_color=\’\’ background_gradient_color1=\’\’ background_gradient_color2=\’\’ background_gradient_direction=\’vertical\’ src=\’\’ attachment=\’\’ attachment_size=\’\’ background_position=\’top left\’ background_repeat=\’no-repeat\’ highlight_size=\’1.1\’ animation=\’\’ link=\’\’ linktarget=\’\’ link_hover=\’\’ title_attr=\’\’ alt_attr=\’\’ mobile_display=\’\’ id=\’\’ custom_class=\’\’ aria_label=\’\’ av_uid=\’av-2nr9kb1\’]
[av_heading heading=\’Users (Table: User)\’ tag=\’h3\’ style=\’blockquote modern-quote\’ subheading_active=\’\’ show_icon=\’\’ icon=\’ue800\’ font=\’\’ size=\’\’ av-medium-font-size-title=\’\’ av-small-font-size-title=\’\’ av-mini-font-size-title=\’\’ subheading_size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ icon_size=\’\’ av-medium-font-size-1=\’\’ av-small-font-size-1=\’\’ av-mini-font-size-1=\’\’ color=\’custom-color-heading\’ custom_font=\’\’ icon_color=\’\’ margin=\’5px\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kmm8y0b9\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[av_hr class=\’custom\’ icon_select=\’no\’ icon=\’ue808\’ font=\’entypo-fontello\’ position=\’center\’ shadow=\’no-shadow\’ height=\’50\’ custom_border=\’av-border-thin\’ custom_width=\’100%\’ custom_margin_top=\’10px\’ custom_margin_bottom=\’10px\’ custom_border_color=\’\’ custom_icon_color=\’\’ id=\’\’ custom_class=\’\’ av_uid=\’av-2m4vsq5\’ admin_preview_bg=\’\’]

[av_textblock size=\’\’ av-medium-font-size=\’\’ av-small-font-size=\’\’ av-mini-font-size=\’\’ font_color=\’\’ color=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-kmm8ybun\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Below are the list of system fields in \’User Administration\’ and their corresponding field mapping in the AppCan Data Warehouse:
[/av_textblock]

[av_table purpose=\’tabular\’ pricing_table_design=\’avia_pricing_default\’ pricing_hidden_cells=\’\’ caption=\’\’ responsive_styling=\’avia_responsive_table\’ alb_description=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_uid=\’av-2jjavv1\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’ av_uid=\’av-2ru925v\’][av_cell col_style=\’\’ av_uid=\’av-2qktgzn\’]User Administration[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2ozo2mr\’]Table [User][/av_cell][av_cell col_style=\’\’ av_uid=\’av-2nc0nj7\’]Comments[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2ku7exf\’][av_cell col_style=\’\’ av_uid=\’av-2kjvjkz\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-2i165kj\’]UserId[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2gu433n\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2fgte7n\’][av_cell col_style=\’\’ av_uid=\’av-2d01nwz\’]Username[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2ca3ldf\’]Username[/av_cell][av_cell col_style=\’\’ av_uid=\’av-29avfbn\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-7z4rxf\’][av_cell col_style=\’\’ av_uid=\’av-274×537\’]First Name[/av_cell][av_cell col_style=\’\’ av_uid=\’av-25f9hoj\’]FirstName[/av_cell][av_cell col_style=\’\’ av_uid=\’av-230apcj\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-7dsdw3\’][av_cell col_style=\’\’ av_uid=\’av-784zcz\’]Last Name[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1xrjv5f\’]Surname[/av_cell][av_cell col_style=\’\’ av_uid=\’av-6xygwz\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1vbzn7n\’][av_cell col_style=\’\’ av_uid=\’av-1t2sc0j\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-1rd9m2r\’]Fullname[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1q3pyar\’]Combined [FirstName] & [Surname][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1o4efqr\’][av_cell col_style=\’\’ av_uid=\’av-1mpasw3\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-1kkz8ur\’]LastActivityDate[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1jcn3fn\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1hb2k7n\’][av_cell col_style=\’\’ av_uid=\’av-1ghyw5v\’]Mobile No[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1duuw9v\’]Telephone[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1cjtv77\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1b6ww4z\’][av_cell col_style=\’\’ av_uid=\’av-199ilv7\’]Email Address[/av_cell][av_cell col_style=\’\’ av_uid=\’av-17meh7n\’]Email[/av_cell][av_cell col_style=\’\’ av_uid=\’av-15lv0v7\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-15831xf\’][av_cell col_style=\’\’ av_uid=\’av-137c3ir\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-111fyg3\’]IsDeleted[/av_cell][av_cell col_style=\’\’ av_uid=\’av-z85ryr\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-xsyxdf\’][av_cell col_style=\’\’ av_uid=\’av-vmm2g3\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-u8gig3\’]IsEnabled[/av_cell][av_cell col_style=\’\’ av_uid=\’av-tlsyvn\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2rhdhf\’][av_cell col_style=\’\’ av_uid=\’av-pgr3kz\’]App Version[/av_cell][av_cell col_style=\’\’ av_uid=\’av-8hhdv\’]AppVersion[/av_cell][av_cell col_style=\’\’ av_uid=\’av-mokhmb\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-ksekkj\’][av_cell col_style=\’\’ av_uid=\’av-jggynn\’]Device OS[/av_cell][av_cell col_style=\’\’ av_uid=\’av-ha6obn\’]DeviceOS[/av_cell][av_cell col_style=\’\’ av_uid=\’av-fs8dhf\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-et0srn\’][av_cell col_style=\’\’ av_uid=\’av-bvud1f\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-a3mrg3\’]LastModifiedTimeStamp[/av_cell][av_cell col_style=\’\’ av_uid=\’av-9hnfsj\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-7chg2r\’][av_cell col_style=\’\’ av_uid=\’av-5apu83\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-46c7z7\’][User Groups][/av_cell][av_cell col_style=\’\’ av_uid=\’av-38r5qr\’][/av_cell][/av_row]
[/av_table]
[/av_one_full]

Scroll to Top