patient_history


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

Contains previous historical entries of the patient’s care team (providers and facilities) as well as patient previous name information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
uuid BINARY 16 √ NULL
date DATETIME 19 current_timestamp()
care_team_provider TEXT 65535 √ NULL

List of care team providers where each id is the provider id contained in the users.id. Entries are separated by a the pipe | symbol.
care_team_facility TEXT 65535 √ NULL

List of care team facilities where each id is the facility/organization id contained in the facilities.id. Entries are separated by a the pipe | symbol
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
history_type_key VARCHAR 36 √ NULL
previous_name_prefix TEXT 65535 √ NULL
previous_name_first TEXT 65535 √ NULL
previous_name_middle TEXT 65535 √ NULL
previous_name_last TEXT 65535 √ NULL
previous_name_suffix TEXT 65535 √ NULL
previous_name_enddate DATE 10 √ NULL
created_by BIGINT 19 √ NULL
users.id Defined in XML R

The user that created this record

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pid_idx Performance Asc pid
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation