care_team_member


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 care_team_member.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 the individual team member of a care team for a patient

Columns

Column Type Size Nulls Auto Default Children Parents Comments
care_team_id Unknown 0 null
patient_data.pid Defined in XML R

The care team this member belongs to
contact_id Unknown 0 null
users.id Defined in XML R

fk to contact.id and is populated if the member is a related person or another patient
created_by Unknown 0 null
users.id Defined in XML R

The id of the user that initially created this record
facility_id Unknown 0 null
facility.id Defined in XML R

fk to facility.id and is populated if the member is an organization or facility
role Unknown 0 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘care_team_roles’
status Unknown 0 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘Care_Team_Status’
updated_by Unknown 0 null
users.id Defined in XML R

The id of the user that last updated this record
user_id Unknown 0 null
users.id Defined in XML R

fk to users.id and is populated if the member is a staff member

Relationships

Close relationships within degrees of separation