shared_attributes


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of shared_attributes.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Dynamic patient, encounter, and transaction table properties created via LBF/LBT mechanism

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
encounter BIGINT 19 null
form_encounter.encounter Defined in XML R

0 if patient attribute, else this is an encounter attribute and references the form_encounter.encounter property
field_id VARCHAR 31 null
layout_options.field_id Defined in XML R

references layout_options.field_id and is the unique property name of this shared attribute
last_update DATETIME 19 null

time of last update
user_id BIGINT 19 null
users.id Defined in XML R

User who last updated this shared attribute
field_value TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc pid + encounter + field_id

Relationships

Close relationships within degrees of separation