×

Supercharge your Proficy solution! Download a free trial of Proficy Operations Hub, CSense analytics, and more. Explore our Proficy 2024 releases!

Home
Data Administration
Reporting
Reporting
Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
Reporting Database Replication
Workflow includes an option to install a reporting database. This database can be used with any valid reporting tool, and allows you to build ad-hoc reports on up-to-date data that you synchronize from your production database.
Reporting Database Schema
The following information describes the reporting database schema.
Workflow Tables

Workflow IPI
Get Started
Tutorials
Orientation
Configure Your Environment
Security
Resource Information and Configuration
Data Administration
- Data Administration Introduction
- Electronic Signatures and Audit Trails
- Data Sources
- Archives
- Custom Property Types
- Transferring Workflow
- Reporting
  - Reporting
    Creating reports on data is an important part of any business and Workflow provides a reporting database for you to install that is specially designed to facilitate reporting and analysis. You can use any valid reporting tool with the reporting database and you have the flexibility to design your own ad-hoc reports.
    - Reporting Database Replication
      Workflow includes an option to install a reporting database. This database can be used with any valid reporting tool, and allows you to build ad-hoc reports on up-to-date data that you synchronize from your production database.
      - Upgrade a replicated database
        When upgrading the application, if you are using a replicated database and have replication turned on, you must turn it off, upgrade, and then turn it on again. You must also upgrade the replicated database.
      - Reporting Database Schema
        The following information describes the reporting database schema.
        Response Work Data Tables
        Equipment Model Tables
        Material Model Tables
        Personnel Model Tables
        Workflow Tables
        Audit Tables
        The auditing tables are located in the audit schema.
        Regulatory Compliance Tables
    - Default Reporting Schedule Editor
      The Default Reporting Schedule editor is used to configure a connection with your reporting database, and to configure the synchronization schedule between the production and reporting databases. Synchronizing the two databases allows you to run up-to-date reports on your data.
    - Reporting Datamart Tutorial
    - Post-Installation Checks for Reporting
    - Microsoft Reporting Service Samples Files
Forms and User Displays
Building and Configuring Workflows
eSOP
ActiveX Task Controls
Service Interfaces
Operator Task List in the Workflow Client
Best Practices

Workflow Tables

The following table describes the Workflow reporting database tables and their descriptions.

Table	Description
Dim_Workflow	Workflow definitions.
Dim_WorkflowSchedule	Schedule definitions.
Dim_WorkflowSubprocess	Global subprocess definitions.
Dim_WorkflowCompletionCode	Completion code definitions.
Dim_WorkflowCategory	Category definitions.
Fact_WorkflowsInCategory	Workflow definition and category association.
Fact_WorkflowSchedulesInCategory	Schedule definition and category association.
Fact_WorkflowSubprocessesInCategory	Global subprocess definition and category association.
Fact_WorkflowCompletionCodesInCategory	Completion code definition and category association.
Dim_WorkflowStep	Workflow step definitions.
Dim_WorkflowScheduleStep	Workflow schedule step definitions.
Fact_WorkflowTaskInstance	Workflow instance history data.
Fact_WorkflowTaskStepInstance	Workflow step instance history data.
Fact_WorkflowTrackedVariable	Workflow tracked variables.
Fact_WorkflowStepTrackedVariable	Workflow step tracked variables.
Fact_WorkflowScheduleTrackedVariable	Workflow schedule tracked variables.
Fact_WorkflowScheduleStepTrackedVariable	Workflow schedule step tracked variables.
Fact_WorkflowTaskInstanceTrackedVariable	Workflow instance tracked variables.
Fact_WorkflowTaskStepInstanceTrackedVariable	Workflow step instance tracked variables.

The following diagrams illustrate the relationships between the Workflow tables:

Note: In order to report on this data, tracking configuration in the Workflow model must be set.