Reporting Database

The reporting database gives you access to run your own reports against a dedicated SQL database, hosted securely in Azure.

Each customer has their own Azure SQL Server, with test, UAT and production versions of the database. The server is protected by a firewall that will only allow connections from a trusted range of IP addresses provided by the customer.

The following article describes the tables and the data they hold.

Form

All of the in-progress and completed digital forms.

FormType

The library of forms the customer has - composed of product forms and those created by eDesigner.

FormManagementUser

The list of users with access to the eGovHub management application.

FormPortalPermission

The list of permission types in the eGovHub forms portal.

FormPortalGroup

The list of security groups in the eGovHub forms portal.

FormPortalGroupPermission

Shows which eGovHub forms portal groups have been assigned which permission.

FormPortalUser

The list of users with access to the eGovHub forms portal.

FormPortalUserGroup

Shows which form portal users are in which groups (and therefore what permissions they have)

PortalSilo

The library of silos available in the customers OneVu portal.

PortalAccount

The list of accounts that have signed into OneVu.

PortalAccountAddress

Where known, the physical address of the person signing into OneVu.

PortalAccountSilo

Shows which OneVu accounts (PortalAccounts) have registered to view which OneVu silos (PortalSilo)

PortalAccountTimeline

The timeline events for a OneVu account

PortalPermission

The list of permission types in OneVu Control and CsVu

PortalGroup

The list of security groups in OneVu Control and CsVu

PortalGroupPermission

Shows which OneVu groups grant which permissions

PortalUser

The list of users with access to OneVu Control or CsVu

PortalUserGroup

Shows which OneVu users are in which groups (and therefore what permissions they have)

WorkflowPermission

The list of permission types in OpenProcess

WorkflowGroup

The list of security groups in OpenProcess

WorkflowGroupPermission

Shows which OpenProcess groups grant which permissions

WorkflowUser

The list of users with access to OpenProcess

WorkflowUserGroup

Shows with OpenProcess users are in which groups (and therefore what permissions they have)

WorkflowProcessType

The library of OpenProcess workflows the customer has built

WorkflowProcess

A running or completed OpenProcess workflow

WorkflowStep

A step in a running or completed OpenProcess workflow

WorkflowStepAllocation

The user allocated to complete a step in an OpenProcess workflow.

WorkflowProcessPortalAccount

Where a workflow is started via OneVu (from a form submission), this shows the OneVu account that the workflow is linked to.