Often when you are utilizing functions to represent sessions within an event, you can assign topics to functions to categorize related functions. For example, a sales conference may have topics such as Direct Sales and Indirect Sales.
Add a Topic
- Click the Topics link from the Main Menu. The Topics page opens.
- Click the Add button. The Add Topic window opens.
- Enter the name of the topic in the Description field.
- Click OK.
Retire a Topic
It is possible to retire or delete topics. It's recommended to retire a topic if it's unused to avoid impacts on views and reports, as well as preventing data loss. Deletion of topics should be an uncommon task as retiring them is the best practice.
- Click the Topics link from the Main Menu. The Topics page opens.
- Locate the topic, then check the box in the Retire column.
- Click Save.
Delete a Topic
You may delete topics when necessary. For example, when not utilized or created in error.
- Click the Topics link from the Main Menu. The Topics page opens.
- Right-click on the topic, then select the Mark for Delete option.
- Click Save.
Add Topics to an Event
Required step: Before assigning topics to functions, first assign the topics to the event.
- Go to the Events page.
- Click to select the event and display the event details.
- Select the Topics tab. You may need to add the tab to your screen layout if it is not available.
- Click Manage. The Select Topics window opens.
- Select topics by moving them from the Available to the Selected panel. Move topics using the green plus sign, right arrow button or double-right arrow button.
- Click OK.
Assign Topics to Functions
- Go to the Events page.
- Click to select the event and display the event details.
- Select the Functions tab.
- Right-click the function, go to Edit, then select the Edit option. The Edit Function window opens.
- Select topic from the Topic drop-down. One or more topics can be assigned to a single function. You may need to add the Topic field to the window layout.
- Click OK.
Remove Topics from Functions
- Go to the Events page.
- Click to select the event and display the event details.
- Select the Functions tab.
- Right-click the function, to go Edit, then select the Edit option. The Edit Function window opens.
- Locate the Topics field, then click once on each topic requiring removal.
- Click OK.
Comments
3 comments
Once you assign a topic to the event, how is that relationship stored?
What field in the EV200_EVENT_MASTER tells me which of the topics from the EV730_TOPICS table were selected or associated with a particular event?
0 upvotes
Hi Pat,
Have you tried looking in EV250_ABSTR_TOPICS - Contains the master list of topics used when processing abstracts. These topics may or may not be associated with an event.
or
EV269_MGR_TOPICS - Contains all of the event abstract topics that an event abstract manager is responsible for.
0 upvotes
Well, I found a way to get the values but not sure it is the most efficient. I link up to the EV251_TOPIC_CROSSREF on the ORG_CODE and EVENT_ID
SELECT dbo.EV200_EVENT_MASTER.EV200_ORG_CODE, dbo.EV200_EVENT_MASTER.EV200_EVT_ID, dbo.EV730_TOPICS.EV730_TOPIC_DESC
FROM dbo.EV730_TOPICS INNER JOIN
dbo.EV251_TOPIC_CROSSREF ON dbo.EV730_TOPICS.EV730_TOPIC_ID = dbo.EV251_TOPIC_CROSSREF.EV251_TOPIC_SEQ AND
dbo.EV730_TOPICS.EV730_ORG_CODE = dbo.EV251_TOPIC_CROSSREF.EV251_ORG_CODE RIGHT OUTER JOIN
dbo.EV200_EVENT_MASTER ON dbo.EV251_TOPIC_CROSSREF.EV251_ORG_CODE = dbo.EV200_EVENT_MASTER.EV200_ORG_CODE AND
dbo.EV251_TOPIC_CROSSREF.EV251_EVENT_ID = dbo.EV200_EVENT_MASTER.EV200_EVT_ID
0 upvotes
Please sign in to leave a comment.