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
id INT 10 √ null
care_team_id INT 10 null
patient_data.pid Defined in XML R

The care team this member belongs to
user_id BIGINT 19 √ NULL
users.id Defined in XML R

fk to users.id and is populated if the member is a staff member
contact_id BIGINT 19 √ NULL
users.id Defined in XML R

fk to contact.id and is populated if the member is a related person or another patient
role VARCHAR 50 null
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘care_team_roles’
facility_id BIGINT 19 √ NULL
facility.id Defined in XML R

fk to facility.id and is populated if the member is an organization or facility
provider_since DATE 10 √ NULL
status VARCHAR 100 √ 'active'
list_options.option_id Defined in XML R

fk to list_options.option_id WHERE list_options.list_id=‘Care_Team_Status’
date_created DATETIME 19 √ current_timestamp()
date_updated DATETIME 19 √ current_timestamp()
created_by BIGINT 19 √ NULL
users.id Defined in XML R

The id of the user that initially created this record
updated_by BIGINT 19 √ NULL
users.id Defined in XML R

The id of the user that last updated this record
note TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
care_team_member_unique Must be unique Asc/Asc/Asc/Asc care_team_id + user_id + facility_id + contact_id

Relationships

Close relationships within degrees of separation