Delete a topic workflow configuration

  1. In the left navigation pane, click the Settings icon (Settings icon).
  2. In the Configure System section, click Manage Topic Workflow Configurations.
  3. Click the Row Action menu (Row menu) for a configuration, and then click Delete.
  4. On the Delete Workflow configuration page, choose:
    • Remove Reference only—Deletes the configuration by reference.

      The configuration and any existing topics, including all comments and the associated attachments, are no longer accessible from the application. However, all of the data remains in the database and can be re-imported if necessary.

    • Delete permanently—Deletes the configuration from the database, along with all topics, including all comments and attachments associated with them. You must be a superuser to delete a topic workflow configuration permanently.

      A message informs you that for 21 CFR Part 11 compliance, you must print each topic for the topic workflow configuration and export tables from the Oracle account. Before you print the topics, verify that the topic workflow configuration options that allow addition of comments to topics, actions, and attachments are all checked. This assures all comments are included, even if these settings were changed in the topic workflow configuration over time.

Tables that store topic data and workflow configurations

The tables shown below store data for topics and topic workflow configurations. The _x suffix represents the unique identifier in the TM_CONFIG_LOCAL table for a topic workflow configuration.

Topic tables Topic workflow configurations tables

TM_TOPIC_x

TM_CONFIG_LOCAL

TM_TOPIC_COMMENT_x

TM_STATE_x

TM_ATTACHMENT_x

TM_STATE_TOPICATTRIBUTE_x

TM_ATTACHMENT_CONTENT_x

TM_STATE_TRANSITIONS_x

TM_ATTACHMENT_COMMENT_x

TM_TOPIC_FIELD_x

TM_TOPICWORKTEAM_x

TM_TOPIC_CODEVALUES_x

TM_TOPICLINKS_x

TM_EMAIL_NOTIFN_RULES_x

TM_TOPIC_ACTION_x

TM_ATTACH_ATTR_x

TM_ACTION_COMMENT_x

TM_ATTACH_TYPE_x

TM_ACTION_ATTACHMENT_x

TM_ACTIONSTATE_x

TA_ATTACH_CONTENT_x

TM_ACTIONSTATE_ATTR_x

TA_ATTACH_COMMENT_x

TM_ACTIONSTATETRANS_x

--

NY_REASON_CATEGORY

--

NY_RULES_x

--

NY_MESSAGE_x

--

NY_DESTINATION_x

--

NY_STATE_RULE_MAP_x

--

NY_ACTION_RULE_MAP_x

--

NY_FIELD_MODIFY_MAP_x

--

NY_CATEGORY_MAP_x

--

NY_REMIND_x

--

NY_HISTORY_x

--

NY_ACTION_REMIND_MAP_x