Data Warehouse Tables

[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=\’AppCan Data Warehouse – Tables\’ 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_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 AppCan Data Warehouse provides the following tables:
[/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-lwdtt9\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’ av_uid=\’av-1k5hre4\’][av_cell col_style=\’\’ av_uid=\’av-1h3naa4\’][Table / View Name][/av_cell][av_cell col_style=\’\’ av_uid=\’av-1fm7mqk\’]Table Description[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1eyrd7w\’][av_cell col_style=\’\’ av_uid=\’av-1cj9pvg\’][DataSyncStatus][/av_cell][av_cell col_style=\’\’ av_uid=\’av-4pd0qk\’]This shows the list of tables, and the synchronisation status (Last Updated and Next Update From)[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-18y4srg\’][av_cell col_style=\’\’ av_uid=\’av-17ifil8\’][DocumentDistributor][/av_cell][av_cell col_style=\’\’ av_uid=\’av-163ib7w\’]This table shows the list of Document Distributors created on your AppCan Cloud Portal[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-14smurg\’][av_cell col_style=\’\’ av_uid=\’av-12x2l18\’][DocumentDistributorFolder][/av_cell][av_cell col_style=\’\’ av_uid=\’av-11vvf5o\’]This table shows the list of Document Distributors Folders created on your AppCan Cloud Portal and should be linked to [DocumentDistributor][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-z3m0vw\’][av_cell col_style=\’\’ av_uid=\’av-y9l4uk\’][Document][/av_cell][av_cell col_style=\’\’ av_uid=\’av-wh6occ\’]This table shows the list of Document Distributors Documents created on your AppCan Cloud Portal and should be linked to [DocumentDistributorFolder][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-v043h8\’][av_cell col_style=\’\’ av_uid=\’av-sv1bi4\’][GlobalDataField][/av_cell][av_cell col_style=\’\’ av_uid=\’av-2o5k70\’]This table shows the list of Global Data Fields created on your AppCan Cloud Portal and should be linked to [GlobalDataFieldOption][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2mere4\’][av_cell col_style=\’\’ av_uid=\’av-npongc\’][GlobalDataFieldOption][/av_cell][av_cell col_style=\’\’ av_uid=\’av-mh7zzw\’]This table shows the list of Global Data Field Options.[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-kijmrw\’][av_cell col_style=\’\’ av_uid=\’av-img2lo\’][Message][/av_cell][av_cell col_style=\’\’ av_uid=\’av-h06t24\’]This table shows the list of Alerts created on your AppCan Cloud Portal and should be linked to [MessageUser][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-fxupf0\’][av_cell col_style=\’\’ av_uid=\’av-dgkbto\’][MessageUser][/av_cell][av_cell col_style=\’\’ av_uid=\’av-1bj37w\’]This table shows the list of user Alerts have been sent to.[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-ar90zw\’][av_cell col_style=\’\’ av_uid=\’av-9pd7rw\’][Data Collector App Name][/av_cell][av_cell col_style=\’\’ av_uid=\’av-73yy3w\’]These tables provides the fields and data for Data Collector apps.[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-60ojwc\’][av_cell col_style=\’\’ av_uid=\’av-4p2ing\’][Data Collector App Name]_Images[/av_cell][av_cell col_style=\’\’ av_uid=\’av-35qpek\’]This view provides the associated media (photos / signatures and metadata) for the Data Collector app.[/av_cell][/av_row]
[/av_table]

[/av_one_full]

Scroll to Top