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.
All of the in-progress and completed digital forms.
The library of forms the customer has - composed of product forms and those created by eDesigner.
The list of users with access to the eGovHub management application.
The list of permission types in the eGovHub forms portal.
The list of security groups in the eGovHub forms portal.
Shows which eGovHub forms portal groups have been assigned which permission.
The list of users with access to the eGovHub forms portal.
Shows which form portal users are in which groups (and therefore what permissions they have)
The library of silos available in the customers OneVu portal.
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
The list of security groups in OneVu Control and CsVu
PortalGroupPermission
Shows which OneVu groups grant which permissions
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
The list of security groups in OpenProcess
WorkflowGroupPermission
Shows which OpenProcess groups grant which permissions
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
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.
