issue_encounter


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 issue_encounter.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

Links patient medical issues in the lists table with patient service encounters

Columns

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

The internal patient identifier
list_id INT 10 null
lists.id Defined in XML R

Represents the specific medical issue (allergy,surgery,etc) this encounter is linked to
encounter INT 10 null
form_encounter.encounter Defined in XML R

References form_encounter.encounter, representing the encounter that is connected to the issue
resolved BOOLEAN 3 null

0=Issue not resolved,1=Issue is resolved
uuid BINARY 16 √ NULL

UUID for this issue encounter record, for data exchange purposes
created_by BIGINT 19 √ NULL
users.id Defined in XML R

fk to users.id for the user that entered in the issue encounter data
updated_by BIGINT 19 √ NULL
users.id Defined in XML R

fk to users.id for the user that last updated the issue encounter data
created_at DATETIME 19 √ current_timestamp()

timestamp when this issue encounter record was created
updated_at DATETIME 19 √ current_timestamp()

timestamp when this issue encounter record was last updated

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
uniq_issue_key Must be unique Asc/Asc/Asc pid + list_id + encounter
uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation