SMRTDTA_ELEM_CONCEPT
Description:
This table is a bridge between concept context SmartData element values and the source SmartData element value records.
Primary Key
Column Name
Ordinal Position
HLV_ID
1
Column Information
Name
Type
Discontinued?
1
HLV_ID
NUMERIC
No
The unique identifier (.1 item) for the value record.
2
PARENT_HLV_ID
NUMERIC
No
The unique ID of the linked concept record that is associated with the SmartData element value.
3
PAT_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.
4
ELEMENT_ID
VARCHAR
No
The SmartData identifier (SDI) for this row.