|
Name |
Type |
Discontinued? |
|
| 1 |
CONVERSATION_ID |
NUMERIC |
No |
|
|
|
| The unique identifier (.1 item) for the secure chat conversation record. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
USER_ID |
VARCHAR |
No |
|
|
|
| The user ID of a user participating in the conversation. |
|
|
| 4 |
USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 5 |
USER_MYPT_ID |
VARCHAR |
No |
|
|
|
| The patient access account ID of a patient or proxy in the conversation. |
|
|
| 6 |
USER_ACTIVE_C_NAME |
VARCHAR |
No |
|
|
|
| This indicates if the participant is considered active in the conversation or not |
| May contain organization-specific values: No |
| Category Entries: |
| Active |
| Inactive |
|
|
| 7 |
LST_READ_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| The time the participant last read a message in the conversation. The time is used to generate read receipts whenever a user opens up the conversation. |
|
|
| 8 |
UPDATE_INSTANT_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This indicates the time of the last update that the user would be concerned with. |
|
|
| 9 |
LST_READ_MSG_LN |
INTEGER |
No |
|
|
|
| The line number of the message last read by the participant. |
|
|
| 10 |
LST_READ_MSG_DAT |
NUMERIC |
No |
|
|
|
| The DAT of the message last read by the participant. |
|
|
| 11 |
READ_ALL_MSG_YN |
VARCHAR |
No |
|
|
|
| Flag needed to index conversations with new messages. |
| May contain organization-specific values: No |
| Category Entries: |
| Yes |
| No |
|
|
| 12 |
ADDED_FROM_GROUP_YN |
VARCHAR |
No |
|
|
|
| Item used to determine whether or not a user was included in the conversation part of a group instead of being added normally. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 13 |
UNREAD_MESSAGE_CNT |
INTEGER |
No |
|
|
|
| The number of unread messages in the conversation for this user. Used to cache unread message counts. |
|
|
| 14 |
LAST_IMPORTANT_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| This item stores the last unread important message instant; when a message with a higher than normal priority is sent we set this to the time that the message was sent. |
|
|
| 15 |
USER_PRIORITY_C_NAME |
VARCHAR |
No |
|
|
|
| This item stores the priority of the message to display for the user in the Secure Chat conversation list. |
| May contain organization-specific values: No |
| Category Entries: |
| Unspecified |
| Silent |
| Normal |
| Important |
| Urgent |
|
|
| 16 |
LST_REACTION_LN |
INTEGER |
No |
|
|
|
| Line (of TLK 3500 superitem) of last reaction a user has received for one of their messages. |
|
|
| 17 |
LST_REACT_CONTACT_DATE |
DATETIME |
No |
|
|
|
| DAT of last reaction a user has received for one of their messages. |
|
|
| 18 |
LST_REACTION_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| Instant of last reaction a user has received for one of their messages. |
|
|
| 19 |
LATEST_REACTION_SEEN_UTC_DTTM |
DATETIME (UTC) |
No |
|
|
|
| Instant of latest reaction (by anyone to any message) seen by user |
|
|
| 20 |
SHOW_IN_UNREAD_YN |
VARCHAR |
No |
|
|
|
| Indicates whether this conversation should count towards the user in this row of superitem 2000's unread counts. |
| The category values for this column were already listed for column: READ_ALL_MSG_YN |
|
|
