therapy_groups_participant_attendance


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

Track patient attendance to a therapy group session as contained in the Used by the form_group_attendance table

Columns

Column Type Size Nulls Auto Default Children Parents Comments
form_id INT 10 null
form_group_attendance.id Defined in XML R

The group attendance encounter form that is the container entity used to track this patient’s attendance
pid BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
meeting_patient_comment TEXT 65535 √ null

Comments about the participant’s attendance in the meeting
meeting_patient_status VARCHAR 15 √ null
list_options.option_id Defined in XML R

The patient status in the meeting from the list_options.list_id=‘groupstat’

Indexes

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

Relationships

Close relationships within degrees of separation