Data Warehouse – Data Collector / View Data

[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=\’Data Collector / View Data 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_font=\’\’ subheading_color=\’\’ seperator_color=\’\’ icon_color=\’\’ margin=\’5px\’ margin_sync=\’true\’ padding=\’10\’ icon_padding=\’10\’ headline_padding=\’\’ headline_padding_sync=\’true\’ link=\’\’ link_target=\’\’ id=\’\’ custom_class=\’\’ template_class=\’\’ element_template=\’\’ one_element_template=\’\’ 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-kmnn227c\’ 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 Data Collector apps:

  • [Data Collector Name]
  • [Data Collector Name]_Images

Please note: The \’_Images\’ table stores the images (Photos & Signatures URL and associated metadata).

Suggested link fields:

  • [FormSubmissionId]
  • [User].[CreatedByUser] – The user who created the record
  • [User].[LastModifiedByUser] – The user who last updated the record

[/av_textblock]

[av_image src=\’http://appcan.help/wp-content/uploads/2021/04/Data-Warehouse.png\’ attachment=\’3071\’ 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-kmno2ash\’ 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_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-1vrra\’]
[av_heading heading=\’Data Collector Field Mapping\’ 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-kkwjruv9\’ 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-kay82cqu\’ sc_version=\’1.0\’ admin_preview_bg=\’\’]
Below are the list of system fields in Data Collector apps / View Data 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-lwdtt9\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’ av_uid=\’av-4lv1tye\’][av_cell col_style=\’\’ av_uid=\’av-4kzxi5y\’]Data Collector / View Data[/av_cell][av_cell col_style=\’\’ av_uid=\’av-4iqm4d2\’][App Name][/av_cell][av_cell col_style=\’\’ av_uid=\’av-4gnv5d2\’]Comments[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-4g9do7q\’][av_cell col_style=\’\’ av_uid=\’av-4e6rmom\’]Unique Record ID[/av_cell][av_cell col_style=\’\’ av_uid=\’av-4brozgm\’]FormSubmissionID[/av_cell][av_cell col_style=\’\’ av_uid=\’av-4amaac6\’] [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-49fasgm\’][av_cell col_style=\’\’ av_uid=\’av-47b3y6e\’]Revision No.[/av_cell][av_cell col_style=\’\’ av_uid=\’av-45lf86u\’]RevisionNumber[/av_cell][av_cell col_style=\’\’ av_uid=\’av-43y9dt2\’] [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-eliqjq\’][av_cell col_style=\’\’ av_uid=\’av-406ozd2\’]Upload Status[/av_cell][av_cell col_style=\’\’ av_uid=\’av-3zd7lhi\’]UploadStatus[/av_cell][av_cell col_style=\’\’ av_uid=\’av-3x3lxba\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-3v8dvee\’][av_cell col_style=\’\’ av_uid=\’av-3upjady\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-1ddqxi\’]CreatedTimeStamp[/av_cell][av_cell col_style=\’\’ av_uid=\’av-3rj527q\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-3pdrzva\’][av_cell col_style=\’\’ av_uid=\’av-3mxeety\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-3lcbl2e\’]ModifiedTimeStamp[/av_cell][av_cell col_style=\’\’ av_uid=\’av-3kgitna\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-3ixc5l2\’][av_cell col_style=\’\’ av_uid=\’av-ciqoyu\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-3ewmjae\’]LastUploadedTimeStamp[/av_cell][av_cell col_style=\’\’ av_uid=\’av-3dxoe2u\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-3bexxhi\’][av_cell col_style=\’\’ av_uid=\’av-3acwbxi\’]Submitted Time Zone[/av_cell][av_cell col_style=\’\’ av_uid=\’av-38agpvq\’]LastUpLoadedTimeZone[/av_cell][av_cell col_style=\’\’ av_uid=\’av-374jsw6\’] [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-35macti\’][av_cell col_style=\’\’ av_uid=\’av-33fb7fa\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-32jwdjq\’]CreatedByUser[/av_cell][av_cell col_style=\’\’ av_uid=\’av-30h5m9i\’]Link to User table (UserId)[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-aqog9y\’][av_cell col_style=\’\’ av_uid=\’av-2wur1mu\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-2uwubs6\’]LastModifiedByUser[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2u7bh2u\’]Link to User table (UserId)[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2s0z1l2\’][av_cell col_style=\’\’ av_uid=\’av-2q6ahty\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-2p00ag6\’]LastUpdateSource[/av_cell][av_cell col_style=\’\’ av_uid=\’av-9i3q7q\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2lcss5i\’][av_cell col_style=\’\’ av_uid=\’av-2j609ye\’]Published In[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2ijfqeu\’]PublishedIn[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2gxrora\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-2efn37a\’][av_cell col_style=\’\’ av_uid=\’av-2det006\’]User Groups[/av_cell][av_cell col_style=\’\’ av_uid=\’av-2b39vty\’][User Group Name as defined in Admin > \’User Groups\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-29sihza\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-28h5gt2\’][av_cell col_style=\’\’ av_uid=\’av-275ccxi\’]APP FIELDS[/av_cell][av_cell col_style=\’\’ av_uid=\’av-24i9fme\’]All fields from the Data Collector app are available.[/av_cell][av_cell col_style=\’\’ av_uid=\’av-22ldd7q\’][/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-23fbgxy\’ sc_version=\’1.0\’]
[av_row row_style=\’avia-heading-row\’ av_uid=\’av-20y2t2u\’][av_cell col_style=\’\’ av_uid=\’av-20nu5h2\’]Data Collector / View Data[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1xt9t3a\’][App Name]_Images[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1x1kxqu\’]Comments[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1vgvm3a\’][av_cell col_style=\’\’ av_uid=\’av-1txh892\’] [/av_cell][av_cell col_style=\’\’ av_uid=\’av-1rruy46\’]FormImageId[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1qtpyae\’] [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1ovtvl2\’][av_cell col_style=\’\’ av_uid=\’av-1na7bxy\’] [/av_cell][av_cell col_style=\’\’ av_uid=\’av-1kqwxra\’]FormSubmissionID[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1johu3a\’] [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1hedqc6\’][av_cell col_style=\’\’ av_uid=\’av-1fo3kqu\’] [/av_cell][av_cell col_style=\’\’ av_uid=\’av-1f5jx92\’]ResponseReferenceId[/av_cell][av_cell col_style=\’\’ av_uid=\’av-1cyhcee\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-1avl87q\’][av_cell col_style=\’\’ av_uid=\’av-19cpx3q\’]Photo / Signature[/av_cell][av_cell col_style=\’\’ av_uid=\’av-184rhie\’]ImageURL[/av_cell][av_cell col_style=\’\’ av_uid=\’av-16z3sba\’]The URL of the photo / signature is available to add in to reports as required.[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-15bev7a\’][av_cell col_style=\’\’ av_uid=\’av-13khk9y\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-11hunvq\’]SortOrder[/av_cell][av_cell col_style=\’\’ av_uid=\’av-cw39i\’][/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-xnjgc6\’][av_cell col_style=\’\’ av_uid=\’av-wa36ty\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-vb9rdi\’]Latitude[/av_cell][av_cell col_style=\’\’ av_uid=\’av-tnh73a\’]Latitude coordinate where the photo / signature was captured[/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-riskdi\’][av_cell col_style=\’\’ av_uid=\’av-p0swae\’] [/av_cell][av_cell col_style=\’\’ av_uid=\’av-2g0s3a\’]Longitude[/av_cell][av_cell col_style=\’\’ av_uid=\’av-mix33a\’]Longitude coordinate where the photo / signature was captured [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-kqoex2\’][av_cell col_style=\’\’ av_uid=\’av-jhn6py\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-hpusyu\’]Easting[/av_cell][av_cell col_style=\’\’ av_uid=\’av-fo2zee\’]Easting coordinate where the photo / signature was captured [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-ekfq86\’][av_cell col_style=\’\’ av_uid=\’av-c9sjqu\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-b1egvq\’]Northing[/av_cell][av_cell col_style=\’\’ av_uid=\’av-9d61ly\’]Northing coordinate where the photo / signature was captured [/av_cell][/av_row]
[av_row row_style=\’\’ av_uid=\’av-6vsvpi\’][av_cell col_style=\’\’ av_uid=\’av-5du5fq\’][/av_cell][av_cell col_style=\’\’ av_uid=\’av-480g6u\’]CreateTimeStamp[/av_cell][av_cell col_style=\’\’ av_uid=\’av-8xk3a\’][/av_cell][/av_row]
[/av_table]
[/av_one_full]

Scroll to Top