Platform Analytics tables

The following tables relate to Platform Analytics data visualizations and dashboards and can be accessed through scripts.

Data visualization tables

Table Description analytics_visualization Parent table for all sys_report* and par_visualization* tables. This table holds all fields common to both Platform Analytics data visualizations and Core UI reports. par_component Contains all data visualizations in the visualization library and all filters in the filter library. Extends sys_metadata. par_component_permission Contains the role, group, and user permissions for all data visualizations and filters in their respective libraries. par_export Lists all scheduled dashboard and data visualization exports. Extends sys_metadata. par_export_job Stores details of every attempt to export a dashboard or data visualization. par_export_visualization Stores the export details of all scheduled data visualization exports. Extends par_export. par_metadata Stores the metadata for each data visualization type. par_notification Lists email notification definitions of scheduled dashboard and data visualization exports. Extends sys_metadata. par_notification_email Stores metadata of scheduled dashboard and data visualization export emails, including subject and message. Extends par_notification. par_notification_email_recipients Stores groups and users who receive a notification email with a scheduled dashboard and data visualization export. Contains the non-metadata information for the emails. par_visualization Contains all data visualizations in the visualization library. Extends par_component. par_visualization_permission Contains the role, group, and user permissions for all data visualizations in the visualization library. Extends par_component_permission. report_stats Contains usage information for migrated reports and data visualizations including run times, most recent view time, and the number of recent executions.

Dashboard tables

Table Description analytics_dashboard Parent table for all par_dashboard* and pa_dashboard* tables. This table holds all fields common to both Platform Analytics and Core UI dashboards. par_automated_kpi_promin_project Stores references to Process Mining maps that are on Platform Analytics dashboards. par_computed_insight Contains all standard proactive analytics insights par_custom_insight_content Contains all custom-built proactive analytics insights par_dashboard Contains all dashboards in the dashboard library. Technical dashboards can be identified by belonging to the Advanced Dashboards experience. Extends sys_metadata. par_dashboard_cache Stores all changes to Platform Analytics dashboard layouts. par_dashboard_canvas Stores the names, descriptions, and layouts of Platform Analytics dashboards and dashboard tabs. Extends sys_metadata. par_dashboard_config Contains the macroponent definitions for each type of data visualization that you can create inside a dashboard. Extends sys_metadata. par_dashboard_filter Lists all filters on Platform Analytics dashboards and the name of the dashboard. par_dashboard_permission Contains the role, group, and user permissions for all dashboards in the dashboard library. Extends sys_metadata. par_dashboard_tab Contains the name, domain, application scope, and parent dashboard of all Platform Analytics dashboard tabs. Extends sys_metadata. par_dashboard_user_metadata Contains all options set by a dashboard viewer that persist between that viewer’s user sessions. Extends sys_metadata. par_dashboard_visibility Cross-references all dashboards in the library by which experiences and workspaces contain them. Extends sys_metadata. par_dashboard_widget Cross-references all components that appear on dashboards by the dashboard canvas and the library component, if any. Extends sys_metadata. par_dashboard_widget_group Contains the configuration for a set of grouped widgets including name, coordinates, and color properties for border and background. par_dashboard_widget_group_mapping Contains a mapping of elements in a widget group to those elements. Group this table by Elements Group to see the widgets in each group clearly. par_export Lists all scheduled dashboard and data visualization exports. par_export_dashboard Stores the export details of all scheduled dashboard exports. Extends par_export. par_export_job Stores details of every attempt to export a dashboard or data visualization. par_indicator_model Contains recommendations related to Performance Analytics analytics in proactive analytics insights. par_insight_user_actions Stores actions that viewers took on proactive analytics insights. par_notification Lists email notification definitions of scheduled dashboard and data visualization exports. par_notification_email Stores subject line and message body of scheduled dashboard and data visualization export emails. Extends par_notification. par_notification_email_recipients Stores groups and users who receive a notification email with a scheduled dashboard and data visualization export. par_recommendation Stores recommendations of Process Mining projects to create. These recommendations are given through Process Mining insights. par_recommendation_user_action Stores whether users accepted or dismissed a Process Mining insight recommendation.

Library recommendation tables

<table id=“table_fwc_dcc_h3c”><thead><tr><th>

Name

</th><th>

Description

</th></tr></thead><tbody><tr><td>

Analytics Library Scan Items

[analytics_library_scan_item]

</td><td>

Stores the results of the scheduled library management jobs

</td></tr><tr><td>

Analytics Library Scan Executions

[analytics_library_scan_execution]

</td><td>

Stores the logs of the scheduled library management jobs

</td></tr></tbody> </table>Parent Topic:Platform Analytics experience reference