Data Warehouse

[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=\’Alerts 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-kmnn3g9o\’ 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=\’\’]
There are 2 tables available for Alerts:

[Message] (This shows all Alerts created)
[MessageUser] (This shows users who were sent alerts)

Suggested link fields:

[Message].[MessageId]
[User].[UserId]

[/av_textblock]

[av_image src=\’http://appcan.help/wp-content/uploads/2021/03/Alerts-1.png\’ attachment=\’2650\’ attachment_size=\’full\’ copyright=\’\’ caption=\’\’ styling=\’\’ align=\’center\’ font_size=\’\’ overlay_opacity=\’0.4\’ overlay_color=\’#000000\’ overlay_text_color=\’#ffffff\’ animation=\’no-animation\’ hover=\’\’ appearance=\’\’ link=\’\’ target=\’\’ title_attr=\’\’ alt_attr=\’\’ lazy_loading=\’disabled\’ id=\’\’ custom_class=\’\’ template_class=\’\’ av_element_hidden_in_editor=\’0\’ av_uid=\’av-kmnilpxu\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_image]

[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_heading heading=\’Alerts (Message & MessageUser)\’ 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-kmmjdokl\’ sc_version=\’1.0\’ admin_preview_bg=\’\’][/av_heading]

[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-31yiwwd\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Below are the list of system fields in \’Document Distributor Apps\’ 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-2zq13wt\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’][av_cell col_style=\’\’]Alerts[/av_cell][av_cell col_style=\’\’][Message][/av_cell][av_cell col_style=\’\’]Comments[/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageId[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Created By[/av_cell][av_cell col_style=\’\’]CreatedBy[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]CreateTimeStamp[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]ModifiedBy[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]ModifiedTimeStamp[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Date Sent[/av_cell][av_cell col_style=\’\’]SendTimeStamp[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Message[/av_cell][av_cell col_style=\’\’]MessageContent[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]IsDeleted[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Subject[/av_cell][av_cell col_style=\’\’]Subject[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[/av_table]

[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-1lftxe5\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’][av_cell col_style=\’\’]Alerts[/av_cell][av_cell col_style=\’\’][MessageUser][/av_cell][av_cell col_style=\’\’]Comments[/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageUserId[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Link for User Name, First Name, Surname, Last Logon[/av_cell][av_cell col_style=\’\’]UserId[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageId[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageStatus[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Message Read[/av_cell][av_cell col_style=\’\’]MessageRead[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’]Message Received[/av_cell][av_cell col_style=\’\’]MessageReceived[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageReadTimeStamp[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]ReadTimeZone[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]MessageReceivedTimeStamp[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[av_row row_style=\’\’][av_cell col_style=\’\’][/av_cell][av_cell col_style=\’\’]ReceivedTimeZone[/av_cell][av_cell col_style=\’\’][/av_cell][/av_row]
[/av_table]

[/av_one_full]

AppCan Support

Data Warehouse – Alerts