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
Calculation
Autopopulation
Copy Forward
14 | SET_BY_USER_ID | VARCHAR | No |
Stores by which user this value was set
15 | SET_BY_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.