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 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
10 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.
11 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.
12 CONVERSATION_MODEL_ID_ACUITY_SYSTEM_NAME VARCHAR No
The name of this HDA record.
13 EPISODE_ID NUMERIC No
A pointer to the episode associated with the record.