VIS_HUB_PAT_ENC_WIG_ST

Description: |
This table stores the the current Visit Hub Widget state for the associated Widget Hash and was last updated at the associated update instant.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
5 | CM_CT_OWNER_ID | VARCHAR | No |
The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6 | WIDGET_IDENT | VARCHAR | No |
Holds the widget's hash to associate with the related widget statuses in I EPT 27206. The hash is composed of the activity descriptor and the widget menu's run parameters.
7 | WIDGET_UPDATE_INST_UTC_DTTM | DATETIME (UTC) | No |
Holds the instant that the associated menu ID in EPT 27205 has its statuses in I EPT 27206 updated.