therapy_groups


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.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 all of the therapy groups that exist in the system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id INT 10 √ null
form_group_attendance.group_id Defined in XML R
form_groups_encounter.group_id Defined in XML R
forms.therapy_group_id Defined in XML R
openemr_postcalendar_events.pc_gid Defined in XML R
therapy_groups_counselors.group_id Defined in XML R
therapy_groups_participants.group_id Defined in XML R

Surrogate id of the record used as the primary incrementing key
group_name VARCHAR 255 null
group_start_date DATE 10 null

Represents the date the group should start
group_end_date DATE 10 √ null

Represents the date the group should end
group_type TINYINT 3 null

Represents the type of therapy group. 1=Closed, 2=Open, 3=Training
group_participation TINYINT 3 null

Represents the participant requirements for the group. 1=Mandatory, 2=Optional
group_status INT 10 null

Represents the current status of the therapy group. 10=Active, 20=Finished, 30=Canceled
group_notes TEXT 65535 √ null

Notes about the overall therapy group
group_guest_counselors VARCHAR 255 √ null

Names of guest counselors participating in the group that do not exist in the users table
name Unknown 0 null

The name of the therapy group

Indexes

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

Relationships

Close relationships within degrees of separation