|
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 |
|
|
|
|
13 |
SET_BY_C_NAME |
VARCHAR |
No |
|
|
|
Stores how this value was set |
May contain organization-specific values: No |
Category Entries: |
Manual |
Macro |
AI |
|
|