Ennov InSight Registrations 7.3

Submission Planning and Tracking Queries

The query links related to submission and planning are defined on the Submission Planning and Tracking tab.

For easy reference, the query descriptions are arranged alphabetically by query name.

Assembly Comparison

The Assembly Comparison query enables you to compare two assembly structures, such as a template and an assembly or two current active views, for example, to determine whether document versions are different between sister submissions. The contents of the first assembly is compared with the second assembly. If the folder trees and document names match, version numbers are compared. This query cannot be sorted.

If the folder structure names and numbers in the assemblies are different, the Difference column identifies the sections that have been ADDED or REMOVED, SAME or DIFFERENT. If the folder structure names and numbers match, the documents in that folder structure are then compared.

If an assembly has been removed from the current active view, slip sheets that were added to the leaf and folder no longer appear in the assembly.

When documents are compared, the document names, binding, and file locations and binding IDs are all compared, with precedence given to the binding IDs of the documents. If documents are different in any of these ways, the attributes for each document are reported in the columns on the right of the query. In this way, added or removed sections may be ascertained, and if anything about the base content is different it will show up in the query also.

Note: Export this query to Microsoft Excel™ for ease of viewing when you compare large assemblies.

Assembly Status

The Assembly Status query enables you to view the status of an assembly that contains documents with a specific document assignment status and that has other attributes, for example, a specific percentage of documents that are in a submission and are locked, approved, or past due. This query returns the following:
  • One row for the root plus one row per folder up to three folders in depth
  • The number and percentage of documents in that folder (and any child folders) that satisfy the criteria
  • Bound (approved), Missing Version, Missing (including Missing and Missing Content), and Unassigned based on their assignment status attribute (These are added to the total number of documents in the submission.)
  • Locked documents based on the presence of locked folders in the assembly
  • Past due documents that have a due date earlier than today's date and that are Bound
Note: Documents directly under the assembly root are not included in this query.

List of Application Countries

The List of Application Countries query enables you to view all application countries that are associated with a specific product family and are associated with applications that have specific attributes, for example, all CP applications with a status of planned. This query returns all application attributes and some product family and event attributes.

List of Applications

The List of Applications query enables you to view applications that have specific attributes, for example, all applications in the top 20 countries for a product family. This query returns all application attributes.

List of Assemblies/Templates

The List of Assemblies/Templates query enables you to view assemblies and template that have specific attributes, for example, all approved assemblies and templates. This query returns all assembly and template attributes. You can define the query to return templates, sequences, standalone assemblies, and lifecycle assemblies.

List of Events with Application Properties

The List of Events with Application Properties query enables you to view events that have specific attributes and are associated with applications that have specific attributes, for example, all initial approvals for the year or all non-notified events. This query returns all event attributes and some application attributes.

List of References

The List of References query enables you to view references that have specific attributes, for example, all non-regulatory correspondence with a specific agency. This query returns all reference attributes.

List of References - Rollup by Application

The List of References - Rollup by Application query enables you to view all references that are directly or indirectly associated with an application you specify, for example, all non-regulatory correspondence associated with an application. This query returns all reference attributes. Product and product family references are not included.
Note: The Country Attribute filter does not reset to Select after changing the Product Family Type filter for this query. Restart the query process if this occurs.

List of References - Rollup by Product Family

The List of References - Rollup by Product Family query enables you to view all references that are directly or indirectly associated with a product family that you specify, for example, all non-regulatory correspondence associated with a product family. This query returns all reference attributes.

List of Sequences with Application and Event Properties

The List of Sequences with Application and Event Properties query enables you to view sequences that have specific attributes and are associated with applications and events that have specific attributes, for example, all planned submissions or amendments submitted in the past year that were related to toxicity. This query returns all sequence attributes and some application and event attributes.

List of Tasks

The List of Tasks query enables you to view tasks have specific attributes, for example, all overdue tasks or all upcoming commitments. This query returns all task attributes.

List of Tasks - Rollup by Application

The List of Tasks - Rollup by Application query enables you to view tasks that are directly or indirectly associated with an application that you specify, for example, all tasks associated with an application. This query returns all task attributes. Product and product family tasks are not included.

List of Tasks - Rollup by Product Family

The List of Tasks - Rollup by Product Family query enables you to view tasks that are directly or indirectly associated with a product family that you specify, for example, all tasks associated with a product family. This query returns all task attributes.

List of Tasks - Rollup by Project

The List of Tasks - Rollup by Project query enables you to view a list of tasks that are directly or indirectly associated with a project that you specify. You can limit the returned tasks to those that have attributes that you specify.

The query shows all attributes of the returned tasks.