AGENDA_TOPIC_INFO
Description:
Table of no-add single row information about visit agenda topics (VATs).

Primary Key
Column Name Ordinal Position
AGENDA_TOPIC_ID 1

Column Information
Name Type Discontinued?
1 AGENDA_TOPIC_ID NUMERIC No
The unique identifier (.1 item) for the topic record.
2 CREATION_UTC_DTTM DATETIME (UTC) No
UTC instant that the record was first created
3 AGENDA_CODEASSIST_C_NAME NUMERIC No
Indicates the type of agent which created this topic
May contain organization-specific values: No
Category Entries:
Added directly by user
Agent - Dynamic Questions
Agent - Patient to Provider
Agent - Zero State
Indirect - Diagnosis
4 LINKED_AGENDA_ID NUMERIC No
Agenda that contains the given topic
5 CLIN_TITLE VARCHAR No
The title/name of this topic
6 CLIN_DESC VARCHAR No
The description for this topic
7 CREATED_BY_USER_ID VARCHAR No
Clinical user who created the topic
8 CREATED_BY_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 PAT_TITLE VARCHAR No
The topic title/name for a patient topic
10 PAT_DESC VARCHAR No
The description for a patient topic
11 CREATED_BY_MYPT_ID VARCHAR No
MyChart user who created the topic
12 DYN_QUES_ANSWER_ID VARCHAR No
Reference to the answers for questions asked by the dynamic questions agent within MyChart
13 DYN_QUES_ORIG_TEXT VARCHAR No
Text entered by the MyChart user which prompted the use of the dynamic questions agent
14 PAT_PRIMARY_YN VARCHAR No
Has the patient marked this as their primary topic?
May contain organization-specific values: No
Category Entries:
No
Yes
15 ASSOCIATED_DX_UID VARCHAR No
The diagnosis this agenda topic was associated with during creation, if applicable.
16 AGENT_TOPIC_SUMMARY VARCHAR No
Topic summary or reason for the topic as generated by the AI agent.