SMRTDTA_ELEM_DATA
Description:
The SMRTDTA_ELEM_DATA table stores metadata (context, linked records, time of entry, etc.) concerning SmartData element values entered by users through SmartForms, SmartTools or other documentation tools that file discrete data to SmartData elements. The actual element values entered by end users are stored in the SMRTDTA_ELEM_VALUE table.

Primary Key
Column Name Ordinal Position
HLV_ID 1

Column Information
Name Type Discontinued?
1 HLV_ID NUMERIC No
The unique ID of the SmartData element value.
2 ELEMENT_ID VARCHAR No
The SmartData identifier (SDI) for this row.
3 CUR_VALUE_DATETIME DATETIME (Local) No
The date and time when the SmartData element value was entered by a user through a SmartForm, SmartTool or other documentation tool that files discrete data to SmartData elements.
4 CUR_VALUE_USER_ID VARCHAR No
The unique ID of the user who entered the SmartData element value for this row. This column is frequently used to link to the CLARITY_EMP table.
5 CUR_VALUE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 CONTEXT_NAME VARCHAR No
The name of the context associated with this row. Contexts organize SmartData element data into different categories and determine under what circumstances data is stored. Examples of contexts include "Patient" and "Episode".
7 CONTACT_SERIAL_NUM NUMERIC No
The unique contact serial number for a contact this record is linked to. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
8 RECORD_ID_VARCHAR VARCHAR No
The unique ID of the linked record that is associated with the SmartData element value of the current row. The type of linked record (patient, order, note, etc.) is determined by the context specified in the CONTEXT_NAME column of the current row. This column will be populated with a varchar version of the numeric ID if the type is numeric.
9 PAT_LINK_ID VARCHAR No
The unique ID of the patient record linked to the SmartData element. This column is frequently used to link to the PATIENT table.
10 SRC_NOTE_ID VARCHAR No
Links to the note record that created the current value.
11 SRC_NOTE_STATUS_C_NAME VARCHAR No
The status of the source note.
May contain organization-specific values: Yes
Category Entries:
Incomplete
Signed
Addendum
Deleted
Revised
Cosigned
Finalized
Unsigned
Cosign Needed
Incomplete Revision
Cosign Needed Addendum
Shared
12 CUR_VAL_UTC_DTTM DATETIME (UTC) No
UTC version of HLV 70
13 SET_BY_C_NAME VARCHAR No
Stores how this value was set
May contain organization-specific values: No
Category Entries:
Manual
Macro
AI