form_transfer_summary


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

Records transfer summary of care and is an alternative to recording referrals in the transactions table

Columns

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

The primary key which is the same as the forms.form_id column
date DATETIME 19 √ null
pid BIGINT 19 √ null
patient_data.pid Defined in XML R

The internal patient identifier
user VARCHAR 255 √ null
groupname VARCHAR 255 √ null
authorized TINYINT 3 √ null
activity TINYINT 3 √ null
client_name VARCHAR 255 √ null
provider VARCHAR 255 √ null
transfer_to VARCHAR 255 √ null
transfer_date DATE 10 √ null
status_of_admission TEXT 65535 √ null
diagnosis TEXT 65535 √ null
intervention_provided TEXT 65535 √ null
overall_status_of_discharge TEXT 65535 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id

Relationships

Close relationships within degrees of separation