AI_INTRCT_INFO
Description:
Tracks basic LLM items.

Primary Key
Column Name Ordinal Position
AI_INTRCT_ID 1

Column Information
Name Type Discontinued?
1 AI_INTRCT_ID NUMERIC No
The unique identifier (.1 item) for the interaction record.
2 USER_ID VARCHAR No
A pointer to the ID of the user who is interacting with the AI agents in this session
3 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
4 AI_INTRCT_SESS_STAT_C_NAME VARCHAR No
A status indicating where we are in the life cycle of this session
May contain organization-specific values: No
Category Entries:
Executing
Ready
Error
Active
Discard
Done
Submitted
Deferred
Enqueued
Cancelled
5 STAT_CHNG_UTC_DTTM DATETIME (UTC) No
Tracks the UTC instant when the last status change was made.
6 PAT_ENC_CSN_ID NUMERIC No
Pointer to the patient encounter associated with the workflow
7 PAT_ID VARCHAR No
Pointer to the patient record
8 MSG_ID VARCHAR No
A pointer to the patient message associated with the session
9 EPISODE_ID NUMERIC No
A pointer to the episode associated with the record.
10 MYPT_ID VARCHAR No
A pointer to the ID of the MyChart user (I WPR .1) who is interacting with the AI agents in this session
11 CONVERSATION_GUID VARCHAR No
The GUID use to uniquely identify a conversation with a conversational AI Assistant. This should only be populated for LLM Records of type 45 - Generic Conversation.
12 CONVERSATION_MODEL_ID NUMERIC No
Stores a pointer to the Model (HDA Record) used to associate a conversation with a particular AI Assistant workflow. This should only be populated for LLM Records of type 45 - Generic Conversation.
13 CONVERSATION_MODEL_ID_ACUITY_SYSTEM_NAME VARCHAR No
The name of this HDA record.
14 AI_CONVERSATION_TYPE_C_NAME NUMERIC No
The specific type of conversation with an AI Assistant. Used to distinguish different types of conversations with the same model. This should only be populated for LLM Records of type 45 - Generic Conversation.
May contain organization-specific values: Yes
Category Entries:
Conversational Search (Chart)
Conversational Search (Encounter)
Ambient Feed
15 USER_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.